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

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һ×é×ֶνøÐвéѯ,·ñÔòûÓбØÒª½¨Á¢ÅÖË÷Òý


Ïà¹ØÎĵµ£º

¡¾¸Äб¹éÕý¡¿ sqlserver sql ·ÖÒ³Óï¾ä

      ÔÚGoogleÉÏʹÓÓsql ·ÖÒ³”¹Ø¼ü×Ö½øÐÐËÑË÷£¬¼¸ºõËùÓеĴ𰸶¼ÊÇÄÇÈýÌõ¡£Æä¶þЧÂÊ×î¸ß£¬ÆäÈýʹÓÃÓα꣬ЧÂÊ×î²î¡£
      ÏÂÃæÊÇÄÇÈýÖÖ·½·¨ £¨²åÈë´úÂëûÓÐsqlÑ¡Ï
·½·¨1£º
ÊÊÓÃÓÚ SQL Server 2000/2005
SELECT TOP Ò³´óС *
from table1
WHERE ......

Ëø³õ̽(sqlserver 2005)

HOLDLOCK ½«¹²ÏíËø±£Áôµ½ÊÂÎñÍê³É£¬¶ø²»ÊÇÔÚÏàÓ¦µÄ±í¡¢ÐлòÊý¾ÝÒ³²»ÔÙÐèҪʱ¾ÍÁ¢¼´ÊÍ·ÅËø¡£HOLDLOCK µÈͬÓÚ SERIALIZABLE¡£
NOLOCK ²»Òª·¢³ö¹²ÏíËø£¬²¢ÇÒ²»ÒªÌṩÅÅËüËø¡£µ±´ËÑ¡ÏîÉúЧʱ£¬¿ÉÄÜ»á¶ÁȡδÌá½»µÄÊÂÎñ»òÒ»×éÔÚ¶ÁÈ¡ÖÐ¼ä»Ø¹öµÄÒ³Ãæ¡£ÓпÉÄÜ·¢ÉúÔà¶Á¡£½öÓ¦ÓÃÓÚ SELECT Óï¾ä¡£
 PAGLOCK ÔÚͨ³£Ê¹Óõ¥¸ö±íËøµ ......

18¾ä»°ÈëÃÅSQLServer XML

18¾ä»°ÈëÃÅSQLServer XML ÊÕ²Ø
/*
sql xml ÈëÃÅ:
    --by jinjazz
    --http://blog.csdn.net/jinjazz
   
    1¡¢xml:        ÄÜÈÏÊ¶ÔªËØ¡¢ÊôÐÔºÍÖµ
   
    2¡¢xpath: ......

SQLServerºÍOracle³£Óú¯Êý¶Ô±È

SQLServerºÍOracleÊÇ´ó¼Ò¾­³£Óõ½µÄÊý¾Ý¿â£¬ÔÚ´Ë×ܽá³öÕâЩ³£Óú¯ÊýÒÔ¹©
´ó¼Ò²Î¿¼¡£
Êýѧº¯Êý
¡¡¡¡1.¾ø¶ÔÖµ
¡¡¡¡S:select abs(-1) value
¡¡¡¡O:select abs(-1) value from dual
¡¡¡¡2.È¡Õû(´ó)
¡¡¡¡S:select ceiling(-1.001) value
¡¡¡¡O:select ceil(-1.001) value from dual
¡¡¡¡3.È¡Õû£¨Ð¡£©
¡¡¡¡S:s ......

sqlserver »ù´¡ÖªÊ¶´óÕûÀí

SQL-Structured Query Language
--(¿ªÆôSQL·þÎñ£ºnet start mssqlserver)
--(ÔÚÃüÁîÐÐÖÐÊäÈë'sqlwb'ÃüÁî¿É´ò¿ªSQL¹ÜÀíÆ÷ )
--(Èç¹ûÒªÖ´ÐжàÌõÃüÁîÖеÄÒ»Ìõ,Êó±êÑ¡¶¨ºóÔÙ°´F5Ö´ÐÐ)
create database sales --´´½¨Ò»¸öÃûΪsalesµÄÊý¾Ý¿â
on
(
name='sales_dat ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ