改成這樣:CREATE PROCEDURE pro_test1
as
declare @sql varchar(100)
declare @sql1 varchar(100)
declare @sql2 varchar(100)
declare @d1 varchar(100)
declare @d2 varchar(100)
declare @d3 varchar(100)
set @d1=convert(varchar(10),getdate(),120)+' 08:01:26'
set @d2=convert(varchar(10),getdate(),120)+' 12:08:54'
set @d3= convert(varchar(10),getdate(),120)+' 17:00:35'
set @sql='insert into IO'+datename(yy,getdate())+datename(mm,getdate()) + ' values (''0229'','''+@d1+''',''01-1'',0)'
set @sql1='insert into IO'+datename(yy,getdate())+datename(mm,getdate())+ ' values (''0229'','''+@d2+''',''01-1'',0)'
set @sql2='insert into IO'+datename(yy,getdate())+datename(mm,getdate()) + ' values (''0229'','''+@d3+''',''01-1'',0)'
exec (@sql)
exec (@sql1)
exec (@sql2)GO
as
declare @sql varchar(100)
declare @sql1 varchar(100)
declare @sql2 varchar(100)
declare @d1 varchar(100)
declare @d2 varchar(100)
declare @d3 varchar(100)
set @d1=convert(varchar(10),getdate(),120)+' 08:01:26'
set @d2=convert(varchar(10),getdate(),120)+' 12:08:54'
set @d3= convert(varchar(10),getdate(),120)+' 17:00:35'
set @sql='insert into IO'+datename(yy,getdate())+datename(mm,getdate()) + ' values (''0229'','''+@d1+''',''01-1'',0)'
set @sql1='insert into IO'+datename(yy,getdate())+datename(mm,getdate())+ ' values (''0229'','''+@d2+''',''01-1'',0)'
set @sql2='insert into IO'+datename(yy,getdate())+datename(mm,getdate()) + ' values (''0229'','''+@d3+''',''01-1'',0)'
exec (@sql)
exec (@sql1)
exec (@sql2)GO
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货