word版可編輯-數(shù)據(jù)庫(kù)設(shè)計(jì)文檔模板精心整理-文庫(kù)吧資料
2025-05-19 22:40本頁(yè)面
【正文】 typeWHERE userId=userId CREATE PROCEDURE Login_DeleteuserId varchar(10) AS DELETE [Login]WHERE userId=userId CREATE PROCEDURE Login_GetModeluserId varchar(10) AS SELECT userId,password,userName,tel,birthday,registerTime,typeFROM [Login]WHERE userId=userId CREATE PROCEDURE Login_GetList AS SELECT userId,password,userName,tel,birthday,registerTime,typeFROM [Login]CREATE PROCEDURE Product_info_GetMaxIdASDECLARE TempID intSELECT TempID = max([proId])+1 FROM [Product_info]IF TempID IS NULLRETURN 1ELSERETURN TempIDCREATE PROCEDURE Product_info_ExistsproId intASDECLARE TempID intSELECT TempID = count(1) FROM [Product_info] WHERE proId=proId IF TempID = 0RETURN 0ELSERETURN 1CREATE PROCEDURE Product_info_ADDproId int output,name varchar(50),price varchar(6),proDate smalldatetime,storage varchar(4) AS INSERT INTO [Product_info]([name],[price],[proDate],[storage])VALUES(name,price,proDate,storage)SET proId = IDENTITYCREATE PROCEDURE Product_info_UpdateproId int,name varchar(50),price varchar(6),proDate smalldatetime,storage varchar(4) AS UPDATE [Product_info] SET [name] = name,[price] = price,[proDate] = proDate,[storage] = storageWHERE proId=proId CREATE PROCEDURE Product_info_DeleteproId int AS DELETE [Product_info]WHERE proId=proId CREATE PROCEDURE Product_info_GetModelproId int AS SELECT proId,name,price,proDate,storageFROM [Product_info]WHERE proId=proId CREATE PROCEDURE Product_info_GetList AS SELECT proId,name,price,proDate,storageFROM [Product_info]CREATE PROCEDURE Repair_info_GetMaxIdASDECLARE TempID intSELECT TempID = max([repairId])+1 FROM [Repair_info]IF TempID IS NULLRETURN 1ELSERETURN TempIDCREATE PROCEDURE Repair_info_ExistsrepairId intASDECLARE TempID intSELECT TempID = count(1) FROM [Repair_info] WHERE repairId=repairId IF TempID = 0RETURN 0ELSERETURN 1CREATE PROCEDURE Repair_info_ADDrepairId int output,repairName nchar(10),repairtel nchar(10),product varchar(50),customer varchar(20),date smalldatetime,customertel nchar(10) AS INSERT INTO [Repair_info]([repairName],[repairtel],[product],[customer],[date],[customertel])VALUES(repairName,repairtel,product,customer,date,customertel)SET repairId = IDENTITYCREATE PROCEDURE Repair_info_UpdaterepairId int,repairName nchar(10),repairtel nchar(10),product varchar(50),customer varchar(20),date smalldatetime,customertel nchar(10) AS UPDATE [Repair_info] SET [repairName] = repairName,[repairtel] = repairtel,[product] = product,[customer] = customer,[date] = date,[customertel] = customertelWHERE repairId=repairId CREATE PROCEDURE Repair_info_DeleterepairId int AS DELETE [Repair_info]WHERE repairId=repairId CREATE PROCEDURE Repair_info_GetModelrepairId int AS SELECT repairId,repairName,repairtel,product,customer,date,customertelFROM [Repair_info]WHERE repairId=repairId CREATE PROCEDURE Repair_info_GetList AS SELECT repairId,repairName,repairtel,product,customer,date,customertelFROM [Repair_info]CREATE PROCEDURE Seller_info_Existsname varchar(50)ASDECLARE TempID intSELECT TempID = count(1) FROM [Seller_info] WHERE name=name IF TempID = 0RETURN 0ELSERETURN 1CREATE PROCEDURE Seller_info_ADDname varchar(50),telephone varchar(20),address varchar(50),product varchar(50),stockNum varchar(6),stockDate smalldatetime,stockPrice varchar(10) AS INSERT INTO [Seller_info]([name],[telephone],[address],[product],[stockNum],[stockDate],[stockPrice])VALUES(name,telephone,address,product,stockNum,stockDate,stockPrice)CREATE PROCEDURE Seller_info_Updatename varchar(50),telephone varchar(20),address varchar(50),product varchar(50),stockNum varchar(6),stockDate smalldatetime,stockPrice varchar(10) AS UPDATE [Seller_info] SET [tele
研究報(bào)告相關(guān)推薦
鄂ICP備17016276號(hào)-1