SQL clr - MS-SQL Server / ·Ç¼¼Êõ°æ

ÏëÓÃSQL CLR×öÈçϵĴ洢¹ý³Ì,µ«ÊÇ·¢ÏÖ±¨´í: 
{ÓÉÓÚ´úÂëÒѾ­¹ýÓÅ»¯»òÕß±¾»ú¿ò¼ÜλÓÚµ÷ÓöÑÕ»Ö®ÉÏ£¬ÎÞ·¨¼ÆËã±í´ïʽµÄÖµ¡£} 
¶øÇÒÈç¹ûÊý¾Ý´Ócase 1ͨ¹ýʱ¾ÍÊÇÕýÈ·µÄ,´Ócase 2ͨ¹ýʱ´íÎó 
²¢ÇÒÔÚcase 2ÖеÄmyCommand.CommandTextºóÈç¹ûÊǸöselectÓï¾ä¾ÍÊÇÕýÈ·µÄ,µ«ÊÇÔËÐд洢¹ý³Ì¾Íͨ²»¹ý,¶øÇÒµ¥¶À²âÊÔ´æ´¢¹ý³ÌÊÇÕýÈ·µÄ,ºÃÏñÎÊÌâÊdzöÔÚrecordµÄ·¢ËÍÉÏ,Çó½Ì! 
[SqlProcedure] 
public static void procClr(SqlXml sx) 
{ 
XPathDocument doc = new XPathDocument(sx.CreateReader()); 
XPathNavigator nav = doc.CreateNavigator(); 
XPathNodeIterator i = nav.Select(@"/NewDataSet/StandardDT"); 

SqlDataRecord record =new SqlDataRecord(new SqlMetaData("i_num", SqlDbType.Int)); 

SqlPipe sp = SqlContext.Pipe; 
sp.SendResultsStart(record); 

while (i.MoveNext()) 
{ 
//----½âÎöXMLÊý¾Ý---- 
  int inum=Convert.ToInt32(i.Current.Evaluate("string(i_num[1]/text())")); 
//-----´¦ÀíÊý¾Ý------ 
  int flag=Function(inum);//×Ô¶¨Ò庯Êý,ÎÞÎó 
  switch(flag) 
  { 
  case 1: 
  { 
  record.SetValues(1); 
  break;  
  } 
  case 2: 
  { 
  using (SqlConnection myConnection = new S