examples of stored procedures

Question

1.00/5 (1 vote)

See more:

SQL

Can you please share some more examples of stored procedures

Posted 18-Apr-14 21:36pm

Member 10759885

Add a Solution

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

karthik Udhayakumar · Answer 1 · 2014-04-18T21:49:00

Solution 1

Hello,
pls refer the following articles

Overview of SQL Server Stored Procedure[^]

Sql Server - How to write a Stored procedure in Sql server[^]

http://www.mssqltips.com/sqlservertutorial/168/different-options-for-creating-sql-server-stored-procedures/[^]
All the best:) Happy learning

Posted 18-Apr-14 21:49pm

karthik Udhayakumar

Tom Marvolo Riddle · Answer 2 · 2014-04-18T21:49:00

Solution 2

See this :
Sql Server - How to write a Stored procedure in Sql server[^]

and more here
https://www.google.co.in/#q=examples+of+stored+procedures&safe=off[^]

and please read Code Project Quick Answers FAQ[^] before posting another question

Posted 18-Apr-14 21:49pm

Tom Marvolo Riddle

Member 10459318 · Answer 3 · 2014-04-18T22:12:00

A stored procedure is group of T-SQL (Transact SQL) statements. If you have a situation, where you write the same query over and over again, you can save that specific query as a stored procedure and call it just by it's name.

Creating a stored procedure with input parameters: This SP, accepts GENDER and DEPARTMENTID parameters. Parameters and variables have an @ prefix in their name.

Create Procedure spGetEmployeesByGenderAndDepartment
@Gender nvarchar(50),
@DepartmentId int
as
Begin
Select Name, Gender from tblEmployee Where Gender = @Gender and DepartmentId = @DepartmentId
End

then execute your procedure using on of the below syntax:

1. EXECUTE spGetEmployeesByGenderAndDepartment 'Male', 1 ( here the order of assiging value should be same as i it is used while creating the input parameter)

2.EXECUTE spGetEmployeesByGenderAndDepartment @DepartmentId=1, @Gender ='Male'