asp.net 2.0中使用sql server 2005的clr存储过程经验与教训

 

How to Create Managed Stored Procedures?
 

public class ContactCode

{

[SqlProcedure(Name="GetContactNames")]

public static void GetContactNames()

{

SqlCommand cmd = SqlContext.GetCommand();

cmd.CommandText = "SELECT FirstName + ' ' + LastName" +

" AS [Name] FROM Person.Contact";

SqlDataReader rdr = cmd.ExecuteReader();

SqlPipe sp = SqlContext.GetPipe();

sp.Send(rdr);

}

}