Home Forums SQL Server 2005 Development Store result in Variable of dynamic query RE: Store result in Variable of dynamic query

  • November 2, 2009 at 12:10 am

    #1073671

    with small correction...

    declare @lstr varchar(200)

    declare @word table (tableName varchar (50))

    set @lstr = 'select top 1 name from sysobjects'

    insert @word

    exec(@lstr)

    select * from @word

    🙂