【1】サンプル
例1
USE [Database Name] GO SET ANSI NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE PROCEDURE [dbo].[procedure.Name] @PROCEDURE_ID INT AS BEGIN SET NOCOUNT ON; IF @PROCEDURE_ID > 0 SELECT * FROM tableName1 WHERE ID = @PROCEDURE_ID AND DELETEFLAG <> 2 ORDER BY Name ELSE SELECT * FROM tableName WHERE DELETEFLAG <> 2 ORDER BY Name END
参考文献
簡単なサンプル
http://7ujm.net/SQL/procedure.html
関連記事
ストアド ~ 基礎知識編 ~
https://dk521123.hatenablog.com/entry/2010/08/06/112528
SQL Server
ストアド ~ 入門編 ~
https://dk521123.hatenablog.com/entry/2012/01/01/234650