Re: Stored Procedures - Am I going insane?

[Paul Hastings]

> Typically, when you're building SQL on the fly, you'll have to build a
> string, then use EXECUTE (in SQL 6.5) or sp_executesql (in SQL 7 or 2000)
to
> execute the string.

sp_executesql will gain you something in terms of optimization, etc. but
this isn't the kind of thing that ought to be in an sp (unless you're doing
this for security or management reasons). i might use cf if nothing was
being returned & the sql executed quickly enough or use cf to write the
sql & then run the whole thing on the db box. DTS is another thing you
might look at.


~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists