Viewing 2 posts - 1 through 2 (of 2 total)
Select 'xyz' will not return any error.
so @@error return 0
April 27, 2010 at 5:05 am
#1158089
we can also do it like.........
declare @sql varchar(100)
Set @sql = 'declare @cnt as int; Select @cnt=count(*) from ' + @tablevariable +'; SELECT @cnt'
Exec (@sql)
I think it was old question...
April 6, 2010 at 6:21 am
#1146421