编译不报错，运行产生 “*****列名无效”的错误

 

declare @tbname varchar(50)

declare v_cur cursor for select tbname from dbo.tbs

declare @sql nvarchar(4000)

declare @dbname varchar(50)

set @dbname = 'GTA_BTR'

open v_cur

fetch v_cur into @tbname

while @@fetch_status = 0

 begin

   set @sql='update dbo.tbs set csum =(select count(*) from '+@tbname+') where tbname ='+@