set @sqlstr='insert into td values(' + '''' + @userid + ''','
+ '''' + cast(@tddate as varchar) + ''','
+ '''' + cast(@tdtime as varchar) + ''','
+ '''' + cast(@lddate as varchar) + ''','
+ '''' + cast(@ldtime as varchar) + ''','
+ cast(@t as varchar) + ')'
+ '''' + cast(@tddate as varchar) + ''','
+ '''' + cast(@tdtime as varchar) + ''','
+ '''' + cast(@lddate as varchar) + ''','
+ '''' + cast(@ldtime as varchar) + ''','
+ cast(@t as varchar) + ')'
CREATE PROCEDURE inserttd
@userid varchar(4),
@tddate datetime,
@tdtime datetime,
@lddate datetime,
@ldtime datetime,
@t int
AS
insert into tb values(@userid,@tddate,@tdtime,@lddate,@ldtime,@t)
GO
@userid varchar(4),
@tddate datetime,
@tdtime datetime,
@lddate datetime,
@ldtime datetime,
@t int
AS
declare @sqlstr varchar(2000)
set @sqlstr='insert td values('''+@userid+''','''+CONVERT(varchar(10),@tddate,120)+''','''+CONVERT(varchar(10),@tdtime,120)+''','''+CONVERT(varchar(10),@lddate,120)+''','''+CONVERT(varchar(10),@ldtime,120)+''')'
exec(@sqlstr)