How many rows will be returned in the following scripts?
DECLARE @DBMS TABLE(DBMS VARCHAR(15)) INSERT INTO @DBMS SELECT 'SQL Server' UNION SELECT 'MySQL' UNION SELECT 'DB2' UNION SELECT 'Oracle' UNION SELECT 'PostgreSQL' UNION SELECT 'SQLite' UNION SELECT 'Access' UNION SELECT 'EnterpriseDB' DECLARE @DBMSValue VARCHAR SET @DBMSValue = 'SQL' SELECT * FROM @DBMS WHERE DBMS LIKE '%' + @DBMSValue + '%'
A. 0
B. 2
C. 4
D. 6
E. 8
F. Error will be generated
Answer:[D]
Highlight to find out the answer.
No comments:
Post a Comment