Chapter 2. T-SQL Enhancements
—Stephen Forte and Leonard Lobel
By now, you must have heard that you can write Microsoft SQL Server stored procedures in any language that uses the common language runtime (CLR), such as Microsoft Visual C# or Microsoft Visual Basic .NET. This is great news if you’ve never mastered Transact-SQL (T-SQL), right? We hate to be the bearer of bad news, but CLR stored procedures are not a cure-all for your SQL Server programming challenges. As you’ll see in Chapter 3, writing a stored procedure in a language that uses the CLR is useful for a number of database programming dilemmas—for instance, CLR stored procedures are often a good replacement for extended stored procedures in earlier versions of SQL Server. For almost ...
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.
