END
DECLARE @d INT
set @d = 1
IF @d = 1 BEGIN
-- 打印
PRINT '正確'
END
ELSE BEGIN
PRINT '錯誤'
END
-- Sql 里的多條件選擇語句.
DECLARE @iRet INT, @PKDisp VARCHAR(20)
SET @iRet = 1
Select @iRet =
CASE
WHEN @PKDisp = '一' THEN 1
WHEN @PKDisp = '二' THEN 2
WHEN @PKDisp = '三' THEN 3
WHEN @PKDisp = '四' THEN 4
WHEN @PKDisp = '五' THEN 5
ELSE 100
END
-- 循環語句
WHILE 條件 BEGIN
延伸閱讀
文章來源于領測軟件測試網 http://www.kjueaiud.com/