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×¢Èë¹¥»÷µÄ¼òµ¥Ê¾Àý¡£
¡¡¡¡statement := "SELECT * from Users WHERE Value= " + a_variable + "
ÉÏÃæÕâÌõÓï¾äÊǺÜÆ ......
ÍâÁª½Ó:ÍâÁª½Ó¿ÉÒÔÊÇ×óÏòÍâÁª½Ó¡¢ÓÒÏòÍâÁª½Ó»òÍêÕûÍⲿÁª½Ó¡£
ÔÚ from ×Ó¾äÖÐÖ¸¶¨ÍâÁª½Óʱ£¬¿ÉÒÔÓÉÏÂÁм¸×é¹Ø¼ü×ÖÖеÄÒ»×éÖ¸¶¨£º
LEFT JOIN »ò LEFT OUTER JOIN;
×óÏòÍâÁª½ÓµÄ½á¹û¼¯°üÀ ......
Àý×Ó£º int id = Convert.ToInt32(replace((Request.QueryString["id"]), ""));
public static string replace(string str, string str2)
{
str = str.Replace(";", str2);
str = ......
֮ǰżȻ¹äÍøÒ³µÄʱºò¿´µ½µÄ,ÏêϸµÄÍøÖ·Íü¼Çcopy¹ýÀ´ÁË£¬ÕæÊDZ§Ç¸¡£¾õµÃ¼òµ¥Ò׶®,ËùÒÔתÁË,ÎûÎû
ÓйطÖÒ³ SQL µÄ×ÊÁϺܶ࣬ÓеÄʹÓô洢¹ý³Ì£¬ÓеÄʹÓÃÓαꡣ±¾È˲»Ï²»¶Ê¹ÓÃÓα꣬ÎÒ¾õµÃËüºÄ×Ê¡¢Ð§Âʵͣ»Ê¹Óô洢¹ý³ÌÊǸö²»´íµÄÑ¡Ôñ£¬ÒòΪ´æ´¢¹ý³ÌÊǾ¹ýÔ¤±àÒëµÄ£¬Ö´ÐÐЧÂʸߣ¬Ò²¸üÁé»î¡£ÏÈ¿´¿´µ¥Ìõ SQL Óï¾äµÄ·ÖÒ³ SQL ......