Sql例⼦Sp_ExecuteSql带参数
Declare@i int, @projectCount int
Declare@Sqlstr NVarchar(400)
--参数
Declare@projectid Varchar(20)
Declare@SubmitOrNot Varchar(20)ssion
declare@NotSubmitReason Varchar(1000)
declare@NotSubmitNote Varchar(1000)
Declare@ustatus Varchar(10)
Declare@ProjectName Varchar(200)toudou
--循环变量起始
t@i=0
--得到所有的项⽬
lect@projectCount=count(projectid) from t_project_manage
print@projectcounthtml的含义
--开始循环每⼀⾏
while@i<@projectCount
cdfibegin
warbleSet@Sqlstr='Select top 1 @projectid = projectid, @projectName=projectName, @Ustatus=ustatus,@NotSubmitReason=NotSubmitReason, @NotSubmitNote=NotSubmitNote from V_ProjectWeeklyReportNotSubmit Where projectid not in
(Select top '+Str(@i) +'projectid from V_ProjectWeeklyReportNotSubmit where SubmitOrNot = 0 or SubmitOrNot is null)'
Exec Sp_ExecuteSql @Sqlstr,N'@projectid Varchar(500) OutPut,@ProjectName Varchar(200) OutPut,@ustatus Varchar(10) OutPut,
@NotSubmitReason Varchar(1000) OutPut, @NotSubmitNote Varchar(1000) OutPut',above all
@projectid Output, @ProjectName Output,@ustatus Output,
@NotSubmitReason Output, @NotSubmitNote Output
Select@projectid,@ProjectName,@ustatus, @NotSubmitReason, @NotSubmitNote--⼀⾏⼀⾏把职⼯号显⽰出来
英语演讲mp3
begin
--插⼊未提交表
inrt into[dbo].[T_Project_Weekly_Report_NotSubmit]
([ProjectID] ,[WeekStartDate] ,[SubmitDate] ,[NotSubmitReason] ,[NotSubmitNote])
values
(@projectid, dateadd(day, -7, getdate()), getdate(), @NotSubmitReason, @NotSubmitNote)四六级官网报名网站
end
生活大爆炸第九季
ecler--print @projectid
t@i=@i+1
end
