Business Intelligence Development Studio sql server 2012

Business Intelligence Development Studio sql server 2012 how to#

These are but a sample of the extensive amount of useful information contained in this book. He discusses how an ORDER BY clause affects a query and why the result set is no longer considered a table. He shows how the new OFFSET-FETCH operator in SQL Server 2012 is superior to the TOP operator. He explains how NULL values are used and what they mean to statement evaluation. He describes why there’s a discrepancy between the way a SELECT statement is written and the way it is processed.

Business Intelligence Development Studio sql server 2012 how to#

When the author discusses joins, for instance, he describes how SQL Server supports two standard syntaxes for cross joins-ANSI SQL-92 and ANSI SQL-89-and then shows how to create cross joins that adhere to each standard, while explaining why one is better than the other.Īnd he doesn’t stop there. Yet it’s not just his careful explanations of T-SQL language components that make this book shine, but also the range and depth of the information. These issues in themselves might not seem like such a big deal, but the combination of good coding practices and precise explanations help to ensure that those new to SQL programming establish good habits from the start and know why they’re doing what they’re doing. Once again, he explains how the statement and function work and why he has included them. The example also includes an IF statement that contains the OBJECT_ID function to check for the table’s existence before creating it. Along with this, he explains the statement’s purpose and then discusses why its use is important. In his CREATE TABLE example, Ben-Gan starts with a USE statement that sets the current database context. Take, for instance, the discussion on creating tables-one of the few sections devoted to data definition language (DDL). In fact, the book abounds with detailed and insightful information that’s not only useful, but that also reaches deeply into the T-SQL landscape, while providing a wide perspective of the terrain. He also avoids providing us pages of repetitive examples with little in the way of substance. It’s the most complex and versatile of the DML players, and many of the elements used in SELECT apply also to the other statements.Īt the same time, he neither limits the book to DML, nor does he confine it to T-SQL syntax and its mechanics. Yet it’s the SELECT statement that takes center stage, and for good reason. Not only does he confidently explore the SELECT statement-in all its querying glory-but he also delves into statements used to insert, update, and delete data.

He drills into T-SQL with unerring precision, particularly when it comes to data manipulation language (DML). Each page of T-SQL Fundamentals testifies to his breadth of knowledge and years of experience with SQL Server. Make no mistake, Itzik Ben-Gan knows his stuff.

Paperback Edition: Amazon US | Amazon UK.Microsoft SQL Server 2012 T-SQL Fundamentals