摘要： ALTER PROC [dbo].[FM_Business_Search]@Business nvarchar(200), @ReceiveState nvarchar(10),@BusinessDate1 datetime,@BusinessDate2 datetime ASdeclare @sql NVARCHAR(4000)declare @Time1 varchar(50) d... 阅读全文

摘要： if exists ( select 1 from Spe_IReportExp WHERE IReportNO = @IReportNO) begin UPDATE Spe_IReportExp SET Site = @Site , Temperature = @Temperature , Humidity = @Humidity , Limi... 阅读全文

摘要： declare @TempStr nvarchar(500) select @TempStr = InsIDs from Spe_UsedInstrument where IReportNO = @IReportNO declare @sql varchar(2000) set @sql='select instrument... 阅读全文

摘要： insert into Spe_IReportExp_Habitselect @HID , Site , Temperature , Humidity , Limit from Spe_IReportExp where IReportNO = @IRNO文章来源:http://blog.163.com/kwanchan@yeah/blog/static/8553861420086207593641... 阅读全文

摘要： insert into Spe_IReport_Habit values ( @HabitName , @HUserID , @HUserPst , getdate() , @HConclusion , @HIsAvailable , @TestDate , ... 阅读全文