Home Forums SQL Server 7,2000 T-SQL dynamic sql RE: dynamic sql

  • June 17, 2004 at 9:35 am

    #510879

    declare @sql varchar(1000), @col_name varchar(10), @orderby varchar(10)

    set @col_name = 'column'

    set @orderby = 'desc'

    set @sql = 'SELECT  c1,c2,c3,c4,c5,c6

       INTO #emp_temp1 FROM #emp_temp order by ' +@col_name+' '+@orderby

    print @sql

    exec (@sql)


    Shamless self promotion - read my blog http://sirsql.net