SQL Server with Mr. Denny:

CREATE PROCEDURE

1

December 8, 2008  1:06 PM

Just how awesome are table parameters in SQL Server 2008?



Posted by: Denny Cherry
CREATE PROCEDURE, SQL Server 2008, T/SQL, Table Variables

I would have to say, that one of the coolest new features of SQL Server 2008 is the ability to pass a table as a single parameter to a stored procedure. While we have been able to do this in the past, by using XML to pass more than one value in, then break it apart. But this is just such a...

July 10, 2008  11:00 AM

My Experience with putting a CRL Procedure into SQL



Posted by: Denny Cherry
C#, CREATE ASSEMBLY, CREATE PROCEDURE, Encryption, Microsoft.SqlServer.Server, SQL CLR Procedure, SQL Server 2005, SQL Server stored procedures, T/SQL

A little while ago I came upon a situation where I needed to put a CRL procedure into SQL Server 2005.  Now I've been using SQL Server 2005 since the day it went RTM, and this is the first occasion that I've needed to put a CLR procedure into SQL.  Could I have done what I needed to without a CRL...


1

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to: