Q&A

Q1:What happens if two tables that contain a similarly named column are used in a SELECT statement?
A1: This leads to ambiguity. In order to resolve this ambiguity, you need to preface these column names with the table name separated by a dot, for example Book.Title.
Q2:I generated a script from a SQL Server database. I see lots of square brackets in the SQL statement. Why are these used?
A2: SQL Server uses square brackets around keywords and identifiers. This enables you to use spaces in identifiers. Because few database designers use spaces in table or column names, you will rarely see these brackets in hand-written SQL code. SQL code generated by SQL Server often has these brackets, though.
Q3:Are RowGUIDs sequential?
A3: No. RowGUIDs are ...

Get Sams Teach Yourself Microsoft® Windows® DNA Programming in 21 Days now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.