可以,使用动态sql语句
declare @tablename varchar(50)
declare @sql varchar(1024)
select @tablename = name from alltable where id = 1
set @sql='insert '+ @tablename+'(id,count) values(1,1)'
然后
execute(@sql)
declare @tablename varchar(50)
declare @sql varchar(1024)
select @tablename = name from alltable where id = 1
set @sql='insert '+ @tablename+'(id,count) values(1,1)'
然后
execute(@sql)
declare @v_sql varchar(200)
select @tablename = name from alltable where id = 1
set @v_sql = 'insert into '+@tablename+' (id,count) values(1,1)'
exec (@v_sql)
然后execute 就行了
select @sql = 'insert into'+@s_tablename +' (id,count,date) values('+@s_id+
','+@s_count+','+@s_date+')'
但当变量是整型或日期型时就会出错。
请问是不是要类型转换?如何转换呢