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 ...

Get Programming Microsoft® SQL Server® 2012 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.