......... -- 游标2 -- DECLARE @sql VARCHAR(8000) SET @sql=' DECLARE CalendarContent CURSOR FOR-- 出错 无法动态拼写sql select m.id,shouji,m.content from '+@db+'.dbo.qp_MyCalendar m left join '+@db+'.dbo.qp_username u on m.username=u.username where issmstip=1 and replace(replace(replace(CONVERT(varchar(16), getdate(), 120),'':'',''''),''-'',''''),'' '','''')>= convert(varchar(10),calendartime,112)+starttimehour+starttimemini' EXEC(@sql) ......
......... -- 游标2 -- DECLARE @sql VARCHAR(8000) SET @sql=' DECLARE CalendarContent CURSOR FOR select m.id,shouji,m.content from '+@db+'.dbo.qp_MyCalendar m left join '+@db+'.dbo.qp_username u on m.username=u.username where issmstip=1 and replace(replace(replace(CONVERT(varchar(16), getdate(), 120),'':'',''''),''-'',''''),'' '','''')>= convert(varchar(10),calendartime,112)+starttimehour+starttimemini' EXEC(@sql) ......
-- 游标2
--
DECLARE @sql VARCHAR(8000)
SET @sql='
DECLARE CalendarContent CURSOR FOR-- 出错 无法动态拼写sql
select m.id,shouji,m.content from '+@db+'.dbo.qp_MyCalendar m left join '+@db+'.dbo.qp_username u
on m.username=u.username
where issmstip=1 and replace(replace(replace(CONVERT(varchar(16), getdate(), 120),'':'',''''),''-'',''''),'' '','''')>=
convert(varchar(10),calendartime,112)+starttimehour+starttimemini'
EXEC(@sql)
......
-- 游标2
--
DECLARE @sql VARCHAR(8000)
SET @sql='
DECLARE CalendarContent CURSOR FOR
select m.id,shouji,m.content from '+@db+'.dbo.qp_MyCalendar m left join '+@db+'.dbo.qp_username u on m.username=u.username where issmstip=1 and replace(replace(replace(CONVERT(varchar(16), getdate(), 120),'':'',''''),''-'',''''),'' '','''')>=
convert(varchar(10),calendartime,112)+starttimehour+starttimemini'
EXEC(@sql)
......