Create stored procedure

Answer 1

What do you mean by stored procedure. Is it in sql server or do you mean method in c#.

Answer 2

Yes..this one

Answer 3

Please elaborate more, option 1 or option 2.

Answer 4

Which option?

Answer 5

Which option?

Answer 6

You want to create a stored procedure in sql server ?

Answer 7

Yes

Answer 8

Sorry I went of the radar for sometime. Hope this answer is still valuable for you.

A stored procedure is a group of sql statement that can be repeated multiple times.

It is created and stored in a special location
In my sql express 2014 it is in Databases-> my database -> Programmability -> Stored procedures

Click left mouse on Stored Procedure and choose option Stored Procedure
(this how it work in my sql express server in other version is can be different)

This creates a stored procedure template.

Have a look at this link to see how a stored procedure is create in sql server
https://technet.microsoft.com/nl-nl/library/ms345415(v=sql.110).aspx

This link explains more about the contents (sql statements) of a stored procedure
https://www.mssqltips.com/sqlservertutorial/160/sql-server-stored-procedure-tutorial/

Answer 9

Ohh thank u