News:
DEFAULT
CONTENT
DOCUMENT
FILESTREAM
Useful resources, columns
SELECT Name FROM person.employees WHERE Name LIKE '[_]n' GO
Which of the following values will be returned by the above code?
In
Sin
_n
All of the above
Useful resources, LIKE
core.sp_delete_data
core.sp_purge_data
core.sp_remove_data
None of the above
Useful resources, Managing Data Collection
DBCC CHECKIDENT ('table_name', RESEED, new_reseed_value)
It checks the current iDentity fielD value of the specifieD table.
It sets the identity field value to the new reseed value.
It sets the identity field value to 1.
All of the above.
Useful resources, DBCC CHECKIDENT
n (n= number of expressions in the element list passed to CUBE)
n+1 (n= number of expressions in the element list passed to CUBE)
2^n (n= number of expressions in the element list passed to CUBE)
2^n+1 (n= number of expressions in the element list passed to CUBE)
Useful resources, GROUP BY
1 to 116
1 to 127
1 to 128
1 to 512
Useful resources, Identifiers
ABCD
ABDC
DCAB
DCBA
Push, delete
Insert, pop
Put, extract
Push, pop
Useful resources, Stack
15
20
50
100
Breadth-first search
Depth-first search