wt is use of Stored procedure in SQL server? give me with examples where it is used in real time?

Hi

Please go through the link for better understanding about Stored Procedure:

http://msdn.microsoft.com/en-us/library/ms190782(v=SQL.100).aspx

Cheers

Cheers
www.SQLServerbuddy.blogspot.com
iLink Multitech Solutions

Bathala.ramesh430, if this helps please login to Mark As Answer. | Alert Moderator

Hi,

Refer this link...You get idea about stored procedures....

http://www.sql-server-performance.com/articles/dba/stored_procedures_basics_p1.aspx

Cheers :)

Thanks,
T.Saravanan

Bathala.ramesh430, if this helps please login to Mark As Answer. | Alert Moderator

Hi,

This link gives over all idea of how to write a Store procedure

http://blog.sqlauthority.com/2009/09/23/sql-server-insert-values-of-stored-procedure-in-table-use-table-valued-function/

Thanks
Karthik
www.f5Debug.net

Bathala.ramesh430, if this helps please login to Mark As Answer. | Alert Moderator

Hi,

1)Stored procedure is an Predefined Collection of SQL Statements.
2)Its Precompiled Execution
3)Reduce the Client server NetWork Traffic
4)more number of Sql statement can execute single store procedure
5)Easy to Error Handling
6)Reusability
7) sp have input and output parameters


create procedure sp_test
@empid
as
select * from emp where empid=@empid

Hope this will help

Regards

sriram

Bathala.ramesh430, if this helps please login to Mark As Answer. | Alert Moderator