SQLServer ά»¤Ë÷ÒýʵÏÖ²éѯÓÅ»¯
Ë÷Òý·ÖΪÁ½´óÀà:¾Û¼¯Ë÷ÒýºÍ·Ç¾Û¼¯Ë÷Òý
Ò»¡¢¾Û¼¯Ë÷Òý
µ±Êý¾Ý±íÖеÄÒ»Áб»È·¶¨ÎªÖ÷¼üºó,SQLServer»á×Ô¶¯ÎªËü½¨Á¢¾Û¼¯Ë÷Òý,ÒòΪ¾Û¼¯Ë÷ÒýÊDZêʶÿ¸ö¼Ç¼Ðеļü,ËùÒÔËü½«±»Ó¦Óõ½Ã¿¸ö²éѯÖÐ.
¶þ¡¢·Ç¾Û¼¯Ë÷Òý
·Ç¾Û¼¯Ë÷ÒýµÄÇé¿ö¾Í±È½Ï¸´ÔÓÁË,ÒòΪËüÊÇÏà¶ÔÓÚ±í¶ÀÁ¢×éÖ¯µÄ,ÔÚSQLServerÖÐÓе¥¶ÀµÄ½á¹¹À´´æ´¢·Ç¾Û¼¯Ë÷Òý.
ÓÐÒ»µãÊÇҪעÒâµÄ,²»Òª´úÌæ²éѯÓÅ»¯Æ÷È¥Ö¸¶¨Ä³¸öË÷Òý,DBAÓ¦¸ÃÏë°ì·¨±ÜÃâÓÅ»¯Æ÷²»Ê¹ÓÃË÷Òý½øÐвéѯ:
1¡¢¸ßËéƬÂÊ
µ±Ë÷ÒýËéƬÂʳ¬¹ý40%µÄʱºò,ÓÅ»¯Æ÷»á·ÅÆúʹÓÃË÷Òý,ÒòΪÔÚËéƬÂÊÈç´Ë¸ßµÄË÷ÒýÖÐɨÃèÊý¾Ý»¹²»ÈçÖ±½Óµ½±íÖÐȥɨÃè.
DBAÓ¦¸Ã³£³£¼àÊÓË÷ÒýËéƬÂÊ,µ±´ïµ½30%µÄʱºò¾ÍÒª¿¼ÂÇÖØÐÂ×éÖ¯Ë÷Òý
2¡¢Î¨Ò»ÐÔ
Èç¹ûÒ»¸öË÷Òý²»ÊÇΨһË÷Òý,ÄÇôÓÅ»¯Æ÷»áÈÏΪֱ½Óµ½Êý¾Ý±íÖÐɨÃè±ÈʹÓÃÕâ¸öË÷ÒýµÄЧÂÊÒª¸ß
3¡¢²éѯÖÐʹÓÃÁ˺¯Êý
µ±²éѯÖÐʹÓÃÁ˺¯Êýʱ,ÔÚ¸ÃÁÐÉϽ¨Á¢µÄË÷ÒýÊDz»»á±»Ê¹ÓõÄ.
ÀýÈç:col½¨Á¢ÁËË÷Òý,µ«ÊÇÔÚ²éѯÖÐʹÓÃÁË convert(nvarchar,col)=’test’,Õâʱ²éѯÓÅ»¯Æ÷²»»áʹÓøÃË÷Òý
4¡¢²éѯ´íÎóµÄ×Ö¶Î
Èç¹û½¨Á¢×éºÏ×ֶεÄË÷Òý,ÄÇôֻÓе±µÚÒ»¸öÁб»²éѯʹÓÃʱ,¸ÃË÷Òý²Å»á±»Ê¹ÓÃ
ÀýÈç:½¨Á¢Ò»¸öË÷Òý(col1,col2,col3),µ±²éѯÖÐʹÓÃcol2=’test’ʱË÷Òý²»»á±»Ê¹ÓÃ.Ö»ÓÐcol1=’test’ÕâÑùµÄ²éѯ,Õâ¸öË÷Òý²Å»á±»Ê¹ÓÃ
Èç¹ûÄãÏë¶Ôcol3²éѯʱʹÓÃË÷Òý,ÄÇôֻÄܽ¨Á¢Á½¸öË÷Òý,Ò»¸ö½¨Á¢ÔÚcol1ÉÏ,ÁíÒ»¸ö½¨Á¢ÔÚcol3ÉÏ
ÁíÍâÒ»¸öҪעÒâµÄÊÇ,·Ç¾Û¼¯Ë÷ÒýÓë¾Û¼¯Ë÷Òý²»Í¬,¾Û¼¯Ë÷ÒýÌî³äÒò×ÓΪ100%²¢ÇÒûÓÐËéƬ,ÒòΪÊý¾Ýʱ˳Ðò×·¼ÓµÄ.·Ç¾Û¼¯Ë÷ÒýÒª¿¼Âǵ½Êý¾ÝÌî³äʱ,Ë÷ÒýÒ³Ìî³äÒò×Ó.
ÔÚÖؽ¨Ë÷Òýʱ»¹Òª¸ù¾ÝÇ°Ò»½×¶ÎµÄ¼àÊÓÖØÐÂÉ趨Ìî³äÒò×Ó.Ò»°ãµÄÇé¿öÊÇ70%-80%,ÎÒ×îµÍʹÓùý65%µÄÌî³äÒò×Ó.
Ïà¹ØÎĵµ£º
SQLServerÖеÄÑ»·Åú´¦Àí
GOÃüÁîºóÃæ¼ÓÒ»¸ö³£Á¿¾Í¿ÉÒÔÁË
ÏÂÃæ·½·¨¿ÉÒÔÓÃÀ´¿ìËÙÉú³ÉÒ»ÅúÊý¾Ý
if (object_id ('t' ) is not null ) drop table t
go
create table t (id int identity (1 , 1 ), name varchar (40 ))
go
insert into t (name ) select newid ()
go 10
select * from t
/*
1 &nbs ......
ÔÚ
SQLServer2005
ÖжÔ
XML
µÄ´¦Àí¹¦ÄÜÏÔÈ»ÔöÇ¿Á˺ܶ࣬ÌṩÁË
query(),value(),exist(),modify(),nodes()
µÈº¯Êý¡£
¹ØÓÚ
xml
£¬ÄÑÒÔÀí½âµÄ²»ÊÇ
SQLServer
ÌṩµÄº¯Êý£¬¶øÊǶÔ
xml
±¾ÉíµÄÀí½â£¬¿´Ëƺܼòµ¥µÄÎļþ¸ñʽ£¬´¦ÀíÆðÀ´È´ÊǷdz£À§Äѵġ£±¾ÎÄÖ»Êdzõ̽һ϶øÒÑ¡£
Ïê¼û
SQLServer
Áª»ú°ïÖú£º
Ö÷Ìâ
˵ ......
¸ÅÊö£º
ÅäÖà Web ͬ²½
url: http://technet.microsoft.com/zh-cn/library/ms151810(SQL.90).aspx
ÈôÒª¶Ô¸´ÖÆʹÓà Web ͬ²½£¬ÇëÖ´ÐÐÏÂÁв½Ö裺
ÅäÖ÷¢²¼£¬ÒÔÔÊÐíʹÓà Web ͬ²½¡£
ÅäÖÃÔËÐÐ Microsoft Internet ÐÅÏ¢·þÎñ (IIS) µÄ¼ÆËã»úÒÔͬ²½¶©ÔÄ¡£Ö§³Ö IIS 5.0 ºÍ 6.0 °æ¡£
ÅäÖÃÒ»¸ö»ò¶à¸ö¶©ÔÄÒÔʹÓà Web ͬ²½¡£
......
ÈçºÎΪ Web ͬ²½ÅäÖà IIS
¸üÐÂÈÕÆÚ£º 2006 Äê 12 Ô 12 ÈÕ
±¾Ö÷ÌâÖеĹý³ÌÊÇΪºÏ²¢¸´ÖÆÅäÖà Web ͬ²½µÄµÚ¶þ¸ö²½Öè¡£Ó¦ÔÚΪ Web ͬ²½ÆôÓ÷¢²¼ºóÖ´Ðд˲½Öè¡£ÓйØÅäÖùý³ÌµÄ¸ÅÊö£¬Çë²ÎÔÄ ÅäÖà Web ͬ²½¡£Íê³É±¾Ö÷ÌâÖеĹý³Ìºó£¬Çë¼ÌÐøÖ´ÐеÚÈý¸ö²½Öè“ÅäÖö©ÔÄÒÔʹÓà Web ͬ²½”¡£ÏÂÁÐÖ÷ÌâÖн«½éÉܵÚÈý¸ö²½Öè£ ......
using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Data.SqlClient; ......