declare @a tinyint,
@b Tinyint,
@c Tinyint,
select @aaaa='insert '+@aimtable+ '(a,b,c) values('+cast(@a as varchar(10))+','+cast(@b as varchar(10))+','+cast(@c as varchar(10))+')'
exec (@aaaa)
@b Tinyint,
@c Tinyint,
select @aaaa='insert '+@aimtable+ '(a,b,c) values('+cast(@a as varchar(10))+','+cast(@b as varchar(10))+','+cast(@c as varchar(10))+')'
exec (@aaaa)
declare @aimtable varchar(20)
我给了几个值,还是有错误,自己找不出来,只好又贴上来了
select @aimtable='table1'
declare @a tinyint,@b Tinyint, @c Tinyint
select @a=1
select @b=1
select @c=1
select @aaaa='insert '+@aimtable+ '(a,b,c) values('+cast(@a as varchar(10))+','+cast(@b as varchar(10))+','+cast(@c as varchar(10))+')'
exec (@aaaa)服务器: 消息 170,级别 15,状态 1,行 1
第 1 行: ')' 附近有语法错误。
---->
declare @aaaa varchar(200)
这里有老龟奴zyq_123雍亲正当大版主,还有人称辣花摧魔前青楼名妓smoke当镇小版主,肯定能满足您的需要!!!快来吧~~~~~~