If you use sp_executesql it will get optimized and the
execution plan can be reused in most cases. This means
the benefits of stored procedures, plus the query
is dynamic. Give it a look.
Jeremy Allen
elliptIQ Inc.
--
http://www.neighborware.com
America's Leading Community Network Software
>-----Original Message-----
>From: Nate Smith [mailto:[EMAIL PROTECTED]]
>Sent: Thursday, August 30, 2001 6:36 PM
>To: CF-Talk
>Subject: RE: Stored Procedure
>
>
>Ok... comment out the EXEC statement and change it to PRINT @DynSQL. Then
>call this SP from QueryAnalyzer and see if the query looks correct.
>
>-Nate
>
>-----Original Message-----
>From: Fuon See Tu [mailto:[EMAIL PROTECTED]]
>Sent: Thursday, August 30, 2001 6:30 PM
>To: CF-Talk
>Subject: RE: Stored Procedure
>
>
>ive tested it, and it doesnt work. it seems that it is loking at
>the commas
>
>too!!!
>
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
