DML Syntax Standard Include the table owner when referencing a table in DML (i.e., select columnA from dbo.tableB). Otherwise, SQL server looks to see if the user running the query owns the table, ...

If you've mastered the DML syntax in previous versions of SQL, concentrate, instead, on the few new additions such as the TABLESAMPLE for aggregates and the new PIVOT and UNPIVOT operators for ...