ตอนที่ 8 : การใช้ If ....Else If...Else สร้างเงื่อนไข (SQL Server : Stored Procedure)

IF (Expression)
	BEGIN
		// Statement
	END

IF (Expression)
	BEGIN
		// Statement
	END
ELSE IF (Expression)
	BEGIN
		// Statement
	END

IF (Expression)
	BEGIN
		// Statement
	END
ELSE IF (Expression)
	BEGIN
		// Statement
	END
ELSE
	BEGIN
		// Statement
	END

USE [mydatabase]
GO
/****** Object:  StoredProcedure [dbo].[myStoredProcedure]    Script Date: 12-Sep-15 12:39:38 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

CREATE PROCEDURE [dbo].[myStoredProcedure]
	@pType	VARCHAR(2)	
AS
BEGIN
	
	-- Declare Variable
	DECLARE @sName VARCHAR(50)
	DECLARE @sEmail VARCHAR(50)

	-- Declare cursor from select table 'CUSTOEMR'
	IF (@pType = 1)
		BEGIN
			DECLARE cursor_customer CURSOR FOR 
			SELECT NAME,EMAIL FROM CUSTOMER
			WHERE COUNTRY_CODE = 'TH'
		END
	ELSE IF (@pType = 2)
		BEGIN
			DECLARE cursor_customer CURSOR FOR 
			SELECT NAME,EMAIL FROM CUSTOMER
			WHERE COUNTRY_CODE = 'US'
		END
	ELSE
		BEGIN
			DECLARE cursor_customer CURSOR FOR 
			SELECT NAME,EMAIL FROM CUSTOMER
			WHERE COUNTRY_CODE = 'UK'
		END

	-- Open Cursor
	OPEN cursor_customer 
	FETCH NEXT FROM cursor_customer 
	INTO @sName, @sEmail;

	-- Loop From Cursor
	WHILE (@@FETCH_STATUS = 0) 
	BEGIN 
		
		-- Display
		PRINT 'Name : ' + @sName + ', Email : ' + @sEmail

		FETCH NEXT FROM cursor_customer -- Fetch next cursor
		INTO @sName, @sEmail  -- Next into variable
	END
	
	-- Close cursor
	CLOSE cursor_customer; 
	DEALLOCATE cursor_customer; 

END