O'Reilly logo

Programming Microsoft® SQL Server™ 2008 by Leonard Lobel, Andrew Brust, and Stephen Forte

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

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

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