-----------------------------------------------------------
New Message on BDOTNET
-----------------------------------------------------------
From: ImpressedDotNeteer
Message 3 in Discussion
Hi Vinod,
Thanks for you reply.
I am generating a dynamic sql in stored procedure and want to execute that dynamic sql
by using EXEC sp_executesql @dynamicSQL,@param1,@parm2. This sp_executesql accepts
first parameter as DSQL query and then you can pass list of variables/values to be
used in that DSQL. My problem is that length of my DSQL is getting increased above
4000 and sp_executesql is unable to process this query. Is there any way I can execute
a DSQL of length more than 4000 using �sp_executesql/any other way� such that I should
be able to pass values to my DSQL.
Note: I need to pass parameters/values to generate my DSQL based on those passed
values.(you can interpret @param1 and @param2 as some values).
Hope I am clear with this. I will attach my SP otherwise.
Thanks & Regards,
Manpreet<o:p></o:p>
-----------------------------------------------------------
To stop getting this e-mail, or change how often it arrives, go to your E-mail
Settings.
http://groups.msn.com/bdotnet/_emailsettings.msnw
Need help? If you've forgotten your password, please go to Passport Member Services.
http://groups.msn.com/_passportredir.msnw?ppmprop=help
For other questions or feedback, go to our Contact Us page.
http://groups.msn.com/contact
If you do not want to receive future e-mail from this MSN group, or if you received
this message by mistake, please click the "Remove" link below. On the pre-addressed
e-mail message that opens, simply click "Send". Your e-mail address will be deleted
from this group's mailing list.
mailto:[EMAIL PROTECTED]
