■ サンプル
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