What will be the output of the following statements?
DECLARE @iRet INT
SELECT @iRet = ISNULL(@iRet,'1') + MyValue
FROM (SELECT '1' MyValue UNION SELECT '1' UNION SELECT '2') t1
SELECT @iRet
A. An error will be generated
B. '112'
C. 4
D. '1112'
Answer:[C]
Highlight to find out the answer.
Tuesday, February 23, 2010
Find output
at 7:03 PM
Labels: SQL Server, SQL Server Test, SQL Server Tip
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment