Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

SQL Server 2005ÖеÄCLR(2)

ÎÄÕµ¼º½ SQL Server 2005 ѧϰ±Ê¼ÇϵÁÐÎÄÕµ¼º½
       ÕâÒ»½ÚÔÛÃÇÀ´ËµËµClRµÄÐÔÄÜ£¬ÎÒÃDz»ÄÜֻʹÓÃËü¶ø²»È¥¿¼Âǵ½µÍ ΪʲôҪʹÓÃËü»òÊÇÔÚʲôʱºòÓ¦¸ÃʹÓÃËü£¬ÏñÎÒ֮ǰдµÄº¯ÊýµÃµ½Ò»¸ö×Ö·ûµÄ³¤¶ÈµÄ·½·¨¾ÍûÓÐÌ«´ó±ØÒªÁË£¬µ«Èç¹ûÊÇÏñ²ð·Ö×Ö·ûÕâÑùµÄ·½·¨Ó¦¸Ã¾ÍÓбØÒªÁË£¬±ÈÈçc#ÀïµÄSplit ()·½·¨£¬ÔÚSqlÀï¾ÍûÓÐÕâÑùµÄº¯ÊýÕâ¸öʱºò ÎÒÃǾͿÉÒÔʹÓÃClrÀ´Íê³ÉÁË£¬
ÆäʵʵÏÖ µÄ·½·¨ÊǸúÉÏÒ»½ÚSQL Server 2005ÖеÄCLR(1) ÀïµÄûÓÐÈκηֱðÖ»ÊǰѺ¯ÊýµÄ´úÂë»»³ÉÏÂÃæµÄ´úÂë¾Í¿ÉÒÔÁË
´úÂë
using System;
using System.Data;
using System.Data.SqlClient;
using System.Data.SqlTypes;
using Microsoft.SqlServer.Server;
public partial class UserDefinedFunctions
{
    //±íʾע²áΪSqlÖеĺ¯Êý
    [Microsoft.SqlServer.Server.SqlFunction]
    public static string sqlSplit(string str, int x)
    {
        // ·µ»Ø×Ö·û´®µÄ³¤¶È
        return str.Split(',')[x].ToString ().Trim();
    }
};
   ÕâÀïÊǼòµ¥µÄʵÏÖ£¬´ó¼Ò¿ÉÒÔ¸ù¾Ý×Ô¼ºµÄÐèÒªÀ´ÊµÏÖ
  ˵µ½ËûµÄÐÔÄÜÎÒÃÇÏÈÀ´ºÍT-SQlÓïÑԱȽÏһϰÉ
  1.±à³ÌÄ£ÐÍ
  T-Sql 
       ¹ý³Ì´úÂëÄÚ²¿Ç¶Èë²éѯÓïÑÔ
            Òâ˼¾ÍÊÇ˵£¬ÔÚT-SqlÀïÎÒÃÇÒ»°ãÊǰѲéѯÓï¾äдÔÚ´æ´¢¹ý³ÌÀïµÄ£¬ÕâÑùµÄЧÂʺܸߣ¬ÒòΪËüÊÇÖ±½Ó·ÃÎÊÊý¾Ý¿â£¬µ«ÊÇÈç¹û³öÏÖ²»Í¬Êý¾Ý¿â¼äµÄÒÆÖ²¾ÍºÜ²»·½±ãÁË
  CLR
¡¡¡¡¡¡intp-proc ado.netÊý¾Ý·ÃÎÊ£¨ÕâÀïÒªµ¼º½Ò»¸öusing System.Data.SqlClient;£©
         ×¢£º  Ïà±ÈT-Sql¿Ï¶¨ÊÇÔÚÖ´ÐÐЧÂÊÉÏÓÐЩ²»×ãÁË£¬ÒòΪËü±Ï¾¹ÊǾ­¹ýÒ»²ãµÄ·â×°µÄ£¬¶ø×îºó»¹ÊÇͨ¹ýAdoÀ´Ö´ÐÐT-SQlÓï¾ä£¬µ«Ò²²»ÊÇÍêȫûÓÐÓÃÎäÖ®µØ
        ÈÝÒ×ÔÚ¸÷²ãÖ®¼äÒƶ¯´úÂëºÍÀûÓÃÏÖÓм¼Êõ
        


Ïà¹ØÎĵµ£º

Áù¸ö½¨Òé·ÀÖ¹SQL×¢Èëʽ¹¥»÷

     SQL×¢Èë¹¥»÷µÄΣº¦ÐԺܴó¡£ÔÚ½²½âÆä·ÀÖ¹°ì·¨Ö®Ç°£¬Êý¾Ý¿â¹ÜÀíÔ±ÓбØÒªÏÈÁ˽âÒ»ÏÂÆä¹¥»÷µÄÔ­Àí¡£ÕâÓÐÀûÓÚ¹ÜÀíÔ±²ÉÈ¡ÓÐÕë¶ÔÐԵķÀÖδëÊ©¡£
¡¡  Ò»¡¢ SQL×¢Èë¹¥»÷µÄ¼òµ¥Ê¾Àý¡£
¡¡¡¡statement := "SELECT * from Users WHERE Value= " + a_variable + "
    ÉÏÃæÕâÌõÓï¾äÊǺÜÆ ......

¹ØÓÚSQLÖÐÓÃJoin in ²éѯµÄÓ÷¨


ÍâÁª½Ó:ÍâÁª½Ó¿ÉÒÔÊÇ×óÏòÍâÁª½Ó¡¢ÓÒÏòÍâÁª½Ó»òÍêÕûÍⲿÁª½Ó¡£
ÔÚ   from   ×Ó¾äÖÐÖ¸¶¨ÍâÁª½Óʱ£¬¿ÉÒÔÓÉÏÂÁм¸×é¹Ø¼ü×ÖÖеÄÒ»×éÖ¸¶¨£º   
 LEFT   JOIN   »ò   LEFT   OUTER   JOIN;    
×óÏòÍâÁª½ÓµÄ½á¹û¼¯°üÀ ......

·ÀÖ¹sql×¢Èë ÊÊÓÃÓÚ URL ID ´¿Êý×Ö

Àý×Ó£º  int id = Convert.ToInt32(replace((Request.QueryString["id"]), ""));
    public static string replace(string str, string str2)
    {
        str = str.Replace(";", str2);
        str = ......

(ÍøÕª)SQL·ÖÒ³Óï¾ä


֮ǰżȻ¹äÍøÒ³µÄʱºò¿´µ½µÄ,ÏêϸµÄÍøÖ·Íü¼Çcopy¹ýÀ´ÁË£¬ÕæÊDZ§Ç¸¡£¾õµÃ¼òµ¥Ò׶®,ËùÒÔתÁË,ÎûÎû
ÓйطÖÒ³ SQL µÄ×ÊÁϺܶ࣬ÓеÄʹÓô洢¹ý³Ì£¬ÓеÄʹÓÃÓαꡣ±¾È˲»Ï²»¶Ê¹ÓÃÓα꣬ÎÒ¾õµÃËüºÄ×Ê¡¢Ð§Âʵͣ»Ê¹Óô洢¹ý³ÌÊǸö²»´íµÄÑ¡Ôñ£¬ÒòΪ´æ´¢¹ý³ÌÊǾ­¹ýÔ¤±àÒëµÄ£¬Ö´ÐÐЧÂʸߣ¬Ò²¸üÁé»î¡£ÏÈ¿´¿´µ¥Ìõ SQL Óï¾äµÄ·ÖÒ³ SQL ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ