Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 Store Procedure

Author  Topic 

Sonu619
Posting Yak Master

202 Posts

Posted - 2010-05-20 : 19:11:15
Hi all,

Could some one please explain me, why we need store procedure ( I know the advantage of store procedure) where we can use, and where should we use store procedure. What kind of project we can done from store procedure. Thanks in advance.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-05-20 : 19:43:24
From a DBA perspective, stored procedures should be used for all data access to a database. You can use them in all programming languages that I know of. We use them on mission critical, Enterprise systems as well as on tiny, not important systems.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

Sonu619
Posting Yak Master

202 Posts

Posted - 2010-05-20 : 22:25:57
Great Tara, Thanks for your reply.
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-05-20 : 22:54:40


Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page
   

- Advertisement -