Home Forums SQL Server 7,2000 T-SQL variable in the FROM clause RE: variable in the FROM clause

  • March 18, 2005 at 8:50 am

    #547798

    declare @selField varchar(50)

    declare @selTbl varchar(50)

    declare @sql varchar(100)

    set @selField = 'name'

    set @selTbl = 'sysobjects'

    SET @sql = 'SELECT ' + @selField + ' from ' + @selTbl

    EXEC(@sql)