Stored ProcedureExplanation in detail from the vry basic.

Posted by Gokul under Sql Server on 12/1/2010 | Points: 10 | Views : 1417 | Status : [Member] | Replies : 2
I am new to Stored Procedure. Can any one guide me how to start write the stored procedure?Can any one one explain about the stored procedure and how to pass the values in the coding for the storeed procedure?

Thanks and Regards,
GokulNath Nithy.



Responses

Posted by: PandianS on: 12/1/2010 [Member] [MVP] Silver | Points: 25

Up
0
Down
Hi

Please refer the BOL link given below

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

Cheers

Cheers
www.SQLServerbuddy.blogspot.com
iLink Multitech Solutions

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

Posted by: T.saravanan on: 12/2/2010 [Member] [MVP] Silver | Points: 25

Up
0
Down
Hi Gokul,

Refer the link for know about Stored Procedure...

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

If you pass the value into Stored Procedure from frontEnd means

http://stackoverflow.com/questions/3806229/how-to-pass-value-to-a-stored-procedure-using-c

Cheers :)

Thanks,
T.Saravanan

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

Login to post response