SQLServer ×î³£ÓõÄË÷Òý×Ö¶Î(ͨÓÃË÷Òý×Ö¶Î)
Ò»¡¢SQLServer ͨÓÃË÷Òý×Ö¶Î
1¡¢Primary Key's Ö÷¼ü
2¡¢Foreign Key's Íâ¼ü
3¡¢Ö§³ÖSELECT¡¢INSERT¡¢UPDATEºÍDELETEÃüÁîµÄ×Ö¶Î :
(1)¡¢INNER JOIN
(£²)¡¢RIGHT | LEFT OUTER JOIN
(£³)¡¢WHERE
(£´)¡¢ORDER BY
(£µ)¡¢GROUP BY
(£¶)¡¢HAVING
¶þ¡¢´´½¨Ë÷ÒýµÄÆäËûÒòËØ(Ö÷ÒªÒòËØ¶¼ÒòΪË÷ÒýÊÇÊý¾Ý±íÍⲿ¶ÀÁ¢µÄ×éÖ¯,µ±±íÖеÄÊý¾Ý·¢Éú±ä»¯Ê±,Ë÷ÒýÒ²ÐèҪͬ²½Î¬»¤,Õ⽫ӰÏìÊý¾Ý±íµÄ¸üвÙ×÷µÄЧÂÊ):
1¡¢Êý¾ÝÁ¿——Èç¹û¼Ç¼ÐÐÊýºÜÉÙ,²»±Ø½¨Á¢Ë÷Òý¾ÍÄÜ¿ìËÙ·ÃÎÊ
2¡¢Êý¾Ý±ä¶¯ÆµÂÊ——Èç¹û±íÖеÄÊý¾Ý±ä¶¯Æµ·±(INSERT¡¢UPDATEºÍDELETE²Ù×÷)ÿ´Î±ä¶¯,Ë÷Òý¶¼ÒªÔö¼Óά»¤µÄ¿ªÏú,ÎÒÃǽ¨Á¢Ë÷ÒýÓ¦¸Ã¿¼Âǵ½Êý¾Ý±ä¶¯µÄÇ÷ÊÆ,ÀýÈç:bbsÖеķ¢Ìû,ÕâÕűíµÄÐÂÊý¾ÝÊǰ´ÕÕ´´½¨Ê±¼äÅÅÁеÄ,ËùÒÔ°´ÕÕ´´½¨Ê±¼ä½¨Á¢µÄË÷Òý,ÔÚÌí¼ÓÐÂÊý¾Ýʱ,ά»¤Ë÷ÒýµÄ¿ªÏúÊÇ×îµÍµÄ
3¡¢¾¡Á¿´´½¨ÊÝË÷Òý——Èç¹ûÄã²»ÄÜÈ·¶¨Ë÷ÒýÊýÁ¿,ÄÇô¾Íÿ¸öË÷ÒýÓÃÒ»¸ö×ֶξͺÃÁË,³ý·ÇƵ·±µÄ¶Ôijһ×é×ֶνøÐвéѯ,·ñÔòûÓбØÒª½¨Á¢ÅÖË÷Òý
Ïà¹ØÎĵµ£º
±¾ÎÄÀ´×ÔCSDN²©¿Í£ºhttp://blog.csdn.net/jinjazz/archive/2008/07/14/2650506.aspx
½«oledb¶ÁÈ¡µÄexcelÊý¾Ý¿ìËÙ²åÈëµÄsqlserverÖУ¬ºÜ¶àÈËͨ¹ýÑ»·À´Æ´½Ósql£¬ÕâÑù×ö²»µ«ÈÝÒ׳ö´í¶øÇÒЧÂʵÍÏ£¬×îºÃµÄ°ì·¨ÊÇʹÓÃbcp£¬Ò²¾ÍÊÇSystem.Data.SqlClient.SqlBulkCopy ÀàÀ´ÊµÏÖ¡£²»µ«Ëٶȿ죬¶øÇÒ´úÂë¼òµ¥£¬ÏÂÃæ²âÊÔ´úÂëµ¼ÈëÒ»¸ö6 ......
SQLServer2005ͨ¹ýintersect,union,exceptºÍÈý¸ö¹Ø¼ü×Ö¶ÔÓ¦½»¡¢²¢¡¢²îÈýÖÖ¼¯ºÏÔËËã¡£
ËûÃǵĶÔÓ¦¹ØÏµ¿ÉÒԲο¼ÏÂÃæÍ¼Ê¾
Ïà¹Ø²âÊÔʵÀýÈçÏ£º
use tempdb
go
if (object_id ('t1' ) is not null ) drop table t1
if (object_id ('t2' ) is not null ) drop table t2
go ......
ÔÚ
SQLServer2005
ÖжÔ
XML
µÄ´¦Àí¹¦ÄÜÏÔÈ»ÔöÇ¿Á˺ܶ࣬ÌṩÁË
query(),value(),exist(),modify(),nodes()
µÈº¯Êý¡£
¹ØÓÚ
xml
£¬ÄÑÒÔÀí½âµÄ²»ÊÇ
SQLServer
ÌṩµÄº¯Êý£¬¶øÊǶÔ
xml
±¾ÉíµÄÀí½â£¬¿´Ëƺܼòµ¥µÄÎļþ¸ñʽ£¬´¦ÀíÆðÀ´È´ÊǷdz£À§Äѵġ£±¾ÎÄÖ»Êdzõ̽һ϶øÒÑ¡£
Ïê¼û
SQLServer
Áª»ú°ïÖú£º
Ö÷Ìâ
˵ ......
SQL-Structured Query Language
--(¿ªÆôSQL·þÎñ£ºnet start mssqlserver)
--(ÔÚÃüÁîÐÐÖÐÊäÈë'sqlwb'ÃüÁî¿É´ò¿ªSQL¹ÜÀíÆ÷ )
--(Èç¹ûÒªÖ´ÐжàÌõÃüÁîÖеÄÒ»Ìõ,Êó±êÑ¡¶¨ºóÔÙ°´F5Ö´ÐÐ)
create database sales --´´½¨Ò»¸öÃûΪsalesµÄÊý¾Ý¿â
on
(
name='sales_dat ......
ÈçºÎÅäÖö©ÔÄÒÔʹÓà Web ͬ²½ (SQL Server Management Studio)
±¾Ö÷ÌâµÄ¹ý³ÌÊÇΪºÏ²¢¸´ÖÆÅäÖà Web ͬ²½µÄµÚÈý¸ö²½Öè¡£Ó¦ÔÚÆôÓ÷¢²¼²¢ÅäÖà Microsoft Internet ÐÅÏ¢·þÎñ (IIS) ºóÖ´Ðд˲½Öè¡£ÓйØÅäÖùý³ÌµÄ¸ÅÊö£¬Çë²ÎÔÄ ÈçºÎΪºÏ²¢¸´ÖÆÅäÖà Web ͬ²½ (SQL Server Management Studio)¡£ÔÚÍê³É±¾Ö÷ÌâÖеĹý³Ìºó£¬Çëͬ²½´´½ ......