Post reply

How do I execute a variable that contains a query string?

  • August 6, 2008 at 10:54 am

    #195346

    Hi there,

    Given the following….

    declare @qrystr varchar(4000)

    set @qrystr = 'select * from table1'

    How do I execute the actual query?

    Thank you very much.

  • August 6, 2008 at 11:03 am

    #854012

    You can either use exec(@qrystr) or use sp_executesql. Tend towards sp_executesql, since it at least slightly reduces the dangers of dynamic SQL (which is what this is).

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • August 6, 2008 at 12:32 pm

    #854062

    Thank you.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply