Stored procedures vs dynamic SQL?? URGENT _

[RDC]

Stored procedures vs dynamic SQL?? URGENT _

just need quick advantage.. PLEASE..

 

[mwolf00]

dynamic SQL needs to be parsed before execution each time whereas a stored procedure generates an execution plan which it reuses each subsequent execution improving its performance.

Programming today is a race between software engineers striving to build better and bigger idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning. - Rick Cook (No, I'm not Rick)

 

[nigelrivett]

And dynamic sql needs user permissions on the objects

======================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.

 

[SQLSister]

And dynamic SQL can result in run time errors as every possible sQL statemetn will not be tested. If you can do something without dynamic SQL, you should.