13

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.

Stan
  • 37,207
  • 50
  • 124
  • 185

4 Answers4

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
3

How to write a Stored procedure in Sql server

Majid
  • 13,853
  • 15
  • 77
  • 113
1

Here is a very helpful clip from youtube.

Introduction to creating Basic stored procedures in SQL Server 2008

or SQL 2008 Series: Introduction to Stored Procedures

OammieR
  • 2,800
  • 5
  • 30
  • 51