Simple stored procedure for insertion

Posted Date: 28 Nov 2008	Resource Type: Code Snippets	Category: SQL
Author: bob	Member Level: Gold
Rating:	Points: 3

A stored procedure is a named group of SQL statements that have been previously created and stored in the server database. Stored procedures accept input parameters so that a single procedure can be used over the network by several clients using different input data. And when the procedure is modified, all clients automatically get the new version. Stored procedures reduce network traffic and improve performance. Stored procedures can be used to help ensure the integrity of the database.

here shows a simple stored procedure used for insertion of data into the table called emp with two fields.


Create procedure insert_emp(@eid int,@ename varchar(20) as
Begin
Insert into emp values(@eid,@ename);
End

For more details, visit http://dotnetmaterial9.blogspot.com/2008/11/sqlserver-faqs.html

Responses

No responses found. Be the first to respond and make money from revenue sharing program.

Feedbacks

Popular Tags

What are tags ?

Search Tags

Http://dotnetmaterial9.blogspot.com/2008/11/sqlserver-faqs.html .

Post Feedback

This is a strictly moderated forum. Only approved messages will appear in the site. Please use 'Spell Check' in Google toolbar before you submit.
You must Sign In to post a response.

	Next Resource: OPENXML
	Previous Resource: connection to sql server with connected architecture
	Return to Discussion Resource Index
	Post New Resource
	Category: SQL

Post resources and earn money!

Related Resources