Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.
Controls conditional execution of a SQL statement, as an alternative to the Watcom SQL IF statement.
IF expression statement
[ ELSE [ IF expression ] statement ]
The Transact-SQL IF conditional and the ELSE conditional each control the execution of only a single SQL statement or compound
statement (between the keywords BEGIN and END).
In comparison to the Watcom SQL IF statement, there is no THEN in the Transact-SQL IF statement. The Transact-SQL version
also has no ELSEIF or END IF keywords.
The following example illustrates the use of the Transact-SQL IF statement:
IF (SELECT max(ID) FROM sysobjects) < 100
PRINT 'These are the user-created objects'
SELECT name, type, ID
WHERE ID < 100
The following two statement blocks illustrate Transact-SQL and Watcom SQL compatibility:
/* Transact-SQL IF statement */
IF @v1 = 0
ELSE IF @v1 = 1
/* Watcom SQL IF statement */
IF v1 = 0 THEN
ELSEIF v1 = 1 THEN