prepared query or statement

#1

Whats a prepared query ? How do you generate it ? How is it different from
say an adhoc or parameterised query

#2

Hassan
I assume you are talking about the Prepare SQL event in SQL Server Profiler,
am I right?

http://support.microsoft.com/default...b;en-us;224587

"Hassan" <Hassan (AT) hotmail (DOT) com> wrote

Quote:

Whats a prepared query ? How do you generate it ? How is it different from
say an adhoc or parameterised query

#3

This should explain the differences:
http://www.microsoft.com/technet/pro...05/recomp.mspx

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/

"Hassan" <Hassan (AT) hotmail (DOT) com> wrote

Quote:

Whats a prepared query ? How do you generate it ? How is it different from say an adhoc or
parameterised query

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

prepared query or statement

microsoft.public.sqlserver.server microsoft.public.sqlserver.server

prepared query or statement - 12-26-2005 , 01:21 AM

Re: prepared query or statement - 12-26-2005 , 01:54 AM

Re: prepared query or statement - 12-26-2005 , 04:03 AM