> It makes sense the sp can only be compiled if it is complete.
actually, it can be compiled as long as it has some idea of what will happen
for example,
WHERE foo = @param
the compiler knows that a value will be substituted at run time
it knows that foo has an index, so it knows it can compile the execution
plan for this query using an index search
so stored procs only have to be as "complete" as necessary to determine what
execution plan to use
rudy
____ • The WDVL Discussion List from WDVL.COM • ____
To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED]
Send Your Posts To: [EMAIL PROTECTED]
To change subscription settings to the wdvltalk digest version:
http://wdvl.internet.com/WDVL/Forum/#sub
________________ http://www.wdvl.com _______________________
You are currently subscribed to wdvltalk as: archive@jab.org
To unsubscribe send a blank email to [EMAIL PROTECTED]
