Please recommend some websites with a quick guide. MSDN is good but it's hard to pick up some basic stuff in a short time. Thanks.
Asked
Active
Viewed 8.0k times
4 Answers
12
here are some good ones:
SQL Server Stored Procedures for Beginners
SQL Server Stored Procedure Basics
SQL Server Stored Procedures 101
Stored Procedure Basics
find more here: google: sql server stored procedure basics

KM.
- 101,727
- 34
- 178
- 212
-
The first link (http://www.sql-server-performance.com/articles/dba/stored_procedures_basics_p1.aspx) is broken. I couldn't find the article using that site's search box or google, so I couldn't fix it myself. – ajerneck Oct 24 '18 at 12:50
-
I bet that link was working over 8 years ago when it was answered! ;-) – KM. Oct 30 '18 at 20:43
6
Actually the documentation has some pretty good links:
This is a good start on MSDN for basic Stored Procedure syntax with examples.

Jeremy
- 4,808
- 2
- 21
- 24
-
MSDN aims to be extremely thorough and complete to the point of nearsightedness. Not necessarily good for beginners. – Marcelo Mason Aug 29 '14 at 15:53
1
Here is a very helpful clip from youtube.
Introduction to creating Basic stored procedures in SQL Server 2008

OammieR
- 2,800
- 5
- 30
- 51