Post reply

dynamic query

  • April 17, 2008 at 3:25 pm

    #71151

    I have to break dynamic query into two as it was more than 4000 characters long.

    I have to use Execute(@nsql_1 + ' ' + @nsql_2) now

    how can I use two parameters to use sp_executesql?

    EXECUTE @error = sp_executesql @nsql, N'@min_date SMALLDATETIME,@max_date SMALLDATETIME',@min_date,@max_date

    Thanks for help....

  • April 17, 2008 at 7:42 pm

    #804076

    I don't think you can. Build your parameters inline with your sql, and use the straight EXEC command instead of sp_executesql.

  • April 17, 2008 at 11:10 pm

    #804098

    [font="Verdana"]

    Declare @sql VarChar(MAX)

    Set @sql = '{You whole select statement}'

    EXECUTE @error = sp_executesql @sql, N'@min_date SMALLDATETIME, @max_date SMALLDATETIME', @min_date,@max_date

    Mahesh

    [/font]

    MH-09-AM-8694

  • April 18, 2008 at 5:42 am

    #804253

    Ah yes, varchar(Max). Sorry, I was still in SQL 2000 land...

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

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