Difference between Normal Stored Procedures and Dynamic stored procedures

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » T-SQL (SS2K5) » Difference between Normal Stored Procedures...

Difference between Normal Stored Procedures and Dynamic stored procedures

Rate Topic

Display Mode

Topic Options

Author

Message

shiv-356842

Posted Wednesday, December 26, 2007 10:58 PM

SSC Veteran

Group: General Forum Members
Last Login: Wednesday, May 15, 2013 1:06 AM
Points: 239, Visits: 1,026

Hi Friends,

What is difference between Normal Stored Procedures and Dynamic Stored Procedures with good example can you any body please explain me

Thans & Regards
siva

Post #436551

ChiragNS

Posted Wednesday, December 26, 2007 11:29 PM

SSCrazy

Group: General Forum Members
Last Login: Wednesday, April 24, 2013 5:02 AM
Points: 2,365, Visits: 1,825

Hi

Do u mean dynamic queries?

"Keep Trying"

Post #436553

Adam Haines

Posted Thursday, December 27, 2007 2:34 PM

SSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 7:18 AM
Points: 2,278, Visits: 2,995

"Dynamic Stored Procedures" is a Stored Procedure that uses dynamic sql instead of traditional tsql. You have to be careful here because you may not be as effective in retrieving data. Should you choose to use dynamic sql you should use the sp_executesql function, as it allows parameters and execution plan reuse.

more info:
http://www.sqlservercentral.com/articles/Miscellaneous/howtobuilddynamicstoredprocedures/968/
http://msdn2.microsoft.com/en-us/library/ms188001.aspx

My blog: http://jahaines.blogspot.com

Post #436842

« Prev Topic | Next Topic »

Permissions