变量代替表名有关问题 set identity_insert 表名 on

2013-08-01

变量代替表名问题 set identity_insert 表名 ondeclare @tablenaem varchar(100)set @tablenametest1se

变量代替表名问题 set identity_insert 表名 on
declare @tablenaem varchar(100)

set @tablename='test1'

set identity_insert @tablename on

执行时报错变量? identity_insert
[解决办法]


DECLARE @sql NVARCHAR(4000) 
DELCARE @tablename varchar(100)
SET @sql='SET IDENTITY_INSERT '+@TABLENAME +' ON' 
EXEC sp_executesql @sql

[解决办法]
declare @tablenaem varchar(100)
set @tablename='test1'
exec ('set identity_insert' + @tablename + 'on')