What is the meaning of the following T-SQL comma

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

What is the meaning of the following T-SQL command: SELECT TOP 10 * FROM user WHERE last_name = 'Johnson'

"SELECT TOP 10 * FROM user WHERE last_name = 'Johnson'" will return the first 10 records that have "Johnson" as the value in the "last_name" column from the "user" table.

(Continued on next question...)

Other Job Interview Questions

• What can you do with the "BULK INSERT" T-SQL command in MS SQL Server?
• What is the meaning of an Outer Join operatin of two tables?
• Is T-SQL language syntax case-sensitive?
• What is "osql"? What can you do with "osql"?
• What is the use of *.ndf files in MS SQL Server?
• When "SET CONCAT_NULL_YIELDS_NULL ON", concatenating a null value with a string will yield a NULL result. But this only applies to the current session if you use in Query Analyzer. Is this true?
• What is the "master" database? Can I delete it to save disk space?
• What is a Torn Page in MS SQL Server?
• What is "bcp"?
• What is the default TCP/IP port # used by MS SQL Server to receive connection requests?
• More...