word版可編輯-數(shù)據(jù)庫(kù)設(shè)計(jì)文檔模板精心整理-全文預(yù)覽
【正文】 t_storage] WHERE ExitStorageId=ExitStorageId IF TempID = 0RETURN 0ELSERETURN 1CREATE PROCEDURE Exit_storage_ADDExitStorageId int output,product varchar(50),date smalldatetime,num varchar(6),storageManagerId nvarchar(50) AS INSERT INTO [Exit_storage]([product],[date],[num],[storageManagerId])VALUES(product,date,num,storageManagerId)SET ExitStorageId = IDENTITYCREATE PROCEDURE Exit_storage_UpdateExitStorageId int,product varchar(50),date smalldatetime,num varchar(6),storageManagerId nvarchar(50) AS UPDATE [Exit_storage] SET [product] = product,[date] = date,[num] = num,[storageManagerId] = storageManagerIdWHERE ExitStorageId=ExitStorageId CREATE PROCEDURE Exit_storage_DeleteExitStorageId int AS DELETE [Exit_storage]WHERE ExitStorageId=ExitStorageId CREATE PROCEDURE Exit_storage_GetModelExitStorageId int AS SELECT ExitStorageId,product,date,num,storageManagerIdFROM [Exit_storage]WHERE ExitStorageId=ExitStorageId CREATE PROCEDURE Exit_storage_GetList AS SELECT ExitStorageId,product,date,num,storageManagerIdFROM [Exit_storage]CREATE PROCEDURE Login_ExistsuserId varchar(10)ASDECLARE TempID intSELECT TempID = count(1) FROM [Login] WHERE userId=userId IF TempID = 0RETURN 0ELSERETURN 1CREATE PROCEDURE Login_ADDuserId varchar(10),password varchar(16),userName varchar(20),tel varchar(20),birthday smalldatetime,registerTime smalldatetime,type nvarchar(50) AS INSERT INTO [Login]([userId],[password],[userName],[tel],[birthday],[registerTime],[type])VALUES(userId,password,userName,tel,birthday,registerTime,type)CREATE PROCEDURE Login_UpdateuserId varchar(10),password varchar(16),userName varchar(20),tel varchar(20),birthday smalldatetime,registerTime smalldatetime,type nvarchar(50) AS UPDATE [Login] SET [password] = password,[userName] = userName,[tel] = tel,[birthday] = birthday,[registerTime] = registerTime,[type] = 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 0ELSE
研究報(bào)告相關(guān)推薦
鄂ICP備17016276號(hào)-1