Visual Studio/SQL Server Integration

Visual Studio 2008 and SQL Server 2008 integrate tightly in a number of ways. It’s important to realize, however, that the use of Visual Studio integration 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 have been 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 ...

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