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
 General SQL Server Forums
 New to SQL Server Programming
 Stored Procedures

Author  Topic 

gurusamy.senthil
Yak Posting Veteran

65 Posts

Posted - 2006-04-25 : 02:07:48
I am new to sql server, I just want to know the purpose of using stored procedures. When and where to use the stored procedures. What are the advantage and disadvantage of using stored procedures.
Any possiblity to exec using in any programming language or we have to compile an stored procedures. If we compile ones how the program is communicating with stored procedures.

Plz any one help me.

Senthil Kumar .g

chiragkhabaria
Master Smack Fu Yak Hacker

1907 Posts

Posted - 2006-04-25 : 02:16:33
I guess you need to search on Google or check on BOOK online..

Basically stored procedure are use, to run the batch of sql scripts which are going to be use again n again .. some thing like OO fundamentals of Reusability....



If Debugging is the process of removing Bugs then i Guess programming should be process of Adding them.
Go to Top of Page

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2006-04-25 : 02:21:09
Make use of SQL Server help file
Refer this
http://databases.about.com/od/sqlserver/l/aastoredprocs.htm

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page
   

- Advertisement -