O'Reilly logo

Programming Microsoft® SQL Server® 2012 by Leonard Lobel and Andrew Brust

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Visual Studio/SQL Server Integration

SSDT and SQL Server 2012 integrate tightly in a number of ways. It’s important to realize, however, that the use of SSDT is completely optional and the use of T-SQL is a sufficient substitute. With the release of SQL Server 2005, T-SQL was enhanced with new data definition language (DDL) commands for maintaining CLR assemblies, types, and aggregates, and its existing commands for stored procedures, triggers, and functions were enhanced to recognize code within deployed assemblies. Visual Studio can execute those commands on your behalf. It can also make writing individual SQL CLR classes and functions easier.

Ultimately, we think all developers should be aware of both SSDT–assisted and more manual coding and ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required