Post reply

Can you SET ANSI_NULLS in dynamic sql?

  • January 10, 2006 at 5:45 pm

    #613959

    Ahh, figured it out. You can do it by nesting the EXECs

    EXEC ('SET ANSI_NULLS ON EXEC(''' + @sql + ''')')

    cool.

Viewing post 1 (of 2 total)

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