bhuvnesh.dogra (11/11/2008)
hideclare @lstr varchar(200)
declare @word varchar(20)
set @lstr = 'select top 1 name from sysobjects'
set @word = exec(@lstr)
select @word
i want ot store result comes from dynamic query into variable @word.(or above code is not working)
Please help
you may try like:
declare@wordtable (tableNamevarchar (50))
declare@lstrvarchar (200)
set@lstr = 'select name from sysobjects where xtype = ''u'''
insert@word
exec(@lstr)
select* from @word