declare @gid table(gid int) declare @sql nvarchar(1000),@flag intdeclare gettabname cursor for select name from sysobjects where name like 'tempt%' and xtype='U'open gettabname fetch next from gettabname into @tablename while @@fetch_status<>-1 begin set @sql='if exists(select 1 from '+@tablename+' where userid='''+@userid+''') set @flag=1 else @flag=0 ' exec sp_executesql @sql,N'@flag int output',@flag output if @flag=1 insert @gid select replace(@tablename,'tempt','') fetch next from gettabname into @tablename end close gettabname deallocate gettabname select * from @gid
declare @sql nvarchar(1000),@flag intdeclare gettabname cursor for
select name from sysobjects where name like 'tempt%' and xtype='U'open gettabname
fetch next from gettabname into @tablename
while @@fetch_status<>-1
begin
set @sql='if exists(select 1 from '+@tablename+' where userid='''+@userid+''') set @flag=1 else @flag=0 '
exec sp_executesql @sql,N'@flag int output',@flag output
if @flag=1
insert @gid select replace(@tablename,'tempt','')
fetch next from gettabname into @tablename
end
close gettabname
deallocate gettabname
select * from @gid