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

SQL Server:½«ÁиüдÓÒ»¸ö±í´«µÝµ½ÁíÒ»¸ö±í

ÎÊ£ºÔõÑùÔÚÒ»¸öUPDATEÓï¾äÖÐʹÓñíBµÄÈý¸öÁиüбíAÖеÄÈý¸öÁУ¿
¡¡¡¡´ð£º¶ÔÕâ¸öÎÊÌ⣬Äú¿ÉÒÔʹÓÃÇ¿´óµÄ¹ØÏµ´úÊý¡£±¾Ò³ÖеĴúÂë˵Ã÷ÁËÈçºÎ×éºÏʹÓÃfrom×Ó¾äºÍJOIN²Ù×÷£¬ÒÔ´ïµ½ÓÃÆäËû±íÖÐÊý¾Ý¸üÐÂÖ¸¶¨ÁеÄÄ¿µÄ¡£ÔÚÉè¼Æ¹ØÏµ±í´ïʽʱ£¬ÄúÐèÒª¾ö¶¨ÊÇ·ñÐèÒªµ¥Ò»ÐÐÆ¥Åä¶à¸öÐУ¨Ò»¶Ô¶à¹ØÏµ£©£¬»òÕßÐèÒª¶à¸öÐÐÆ¥Åä±»Áª½Ó±íÖеĵ¥Ò»ÐÐÒÔ¸üÐÂËùÓÐÐУ¨¶à¶ÔÒ»¹ØÏµ£©¡£
¡¡¡¡ÔÚÒ»¶Ô¶à¹ØÏµÖУ¬SQL ServerʼÖÕʹÓÃËüÕÒµ½µÄ×îºóÒ»ÐиüÐÂÊý¾Ý¡£µ«ÊÇ£¬ÄúÎÞ·¨¿ØÖÆ×îºóÒ»ÐÐËùÔÚµÄλÖá£ÔÚ¶à´¦ÀíÆ÷µÄ¼ÆËã»úÉÏ£¬²éѯ¿ÉÄÜÊÇͬ²½½øÐеģ¬ÏàͬµÄ²éѯ×îºóÒ»ÐеÄλÖÿÉÄܻ᲻ͬ¡£Òò´Ë£¬Microsoft½¨Ò龡Á¿²»ÒªÊ¹ÓÃÒ»¶Ô¶à¹ØÏµ¡£
¡¡¡¡Èç¹û´ý¸üеıíÓëfrom×Ó¾äÖеıíÏàͬ£¬²¢ÇÒfrom×Ó¾äÖ»°üº¬¶Ô¸Ã±íµÄÒ»¸öÒýÓ㬱ðÃû¿ÉÄÜδ±»Ö¸¶¨¡£Èç¹û´ý¸üеıíÔÚfrom×Ó¾äÖгöÏÖÁ˶à´Î£¬Ö»ÓиñíµÄÒ»¸öÒýÓÿÉÒÔÊ¡ÂÔ±íµÄ±ðÃû£¬¶Ô¸Ã±íµÄËùÓÐÆäËûÒýÓñØÐë°üº¬Ò»¸ö±í±ðÃû¡£
USE tempdb
GO
CREATE TABLE #t1 (c1 int NOT NULL, c2 char(5), c3 char(5),
 c4 char(5))
GO
CREATE TABLE #t2 (c1 int NOT NULL, c2 char(5), c3 char(5),
 c4 char(5))
GO
--Êý¾Ý¸³Öµ
INSERT #t1 values (1,'hello','there','fred')
INSERT #t2 values (1,'how','are','you?')
--¸üÐÂÊý¾Ý
UPDATE #t1 SET #t1.c2 = #t2.c2, #t1.c3 = #t2.c3,
 #t1.c4 = #t2.c4
from #t2
WHERE #t1.c1 = #t2.c1
--¼ì²é½á¹û
SELECT * from #t1


Ïà¹ØÎĵµ£º

SQL Server ²éѯÓÅ»¯£¨3£©_Ë÷ÒýµÄÉè¼ÆÓëʹÓÃ

Ò»¡¢Ë÷ÒýµÄ×÷ÓÃ
1¡¢°ïÖú¼ìË÷Êý¾Ý£»
2¡¢Ìá¸ßÁª½ÓЧÂÊ£»
3¡¢½ÚÊ¡ORDER BY¡¢GROUP BYµÄʱ¼ä£»
4¡¢±£Ö¤Êý¾ÝΨһÐÔ£¨½öÏÞÓÚΨһË÷Òý£©¡£
 
¶þ¡¢Ë÷ÒýµÄÉè¼Æ
ÔÚÈ·¶¨Òª½¨Á¢Ò»¸öË÷Òýʱ£¬Ê×ÏÈÎÒÃÇҪȷ¶¨ËüÊǾۼ¯»¹ÊǷǾۼ¯¡¢µ¥Áл¹ÊǶàÁС¢Î¨Ò»»¹ÊÇ·ÇΨһ¡¢ÁÐÊÇÉýÐò»¹ÊǽµÐò¡¢ËüµÄ´æ´¢ÊÇÈçºÎµÄ£¬±ÈÈ磺·ÖÇø¡¢Ìî³äÒò×ӵȡ£ ......

SQL Server connection strings

SQL ODBC connection strings
Standard Security:< br> "Driver={SQLServer};Server=Your_Server_Name;Database=Your_Database_Name;Uid=Your_Username;Pwd=Your_Password;"
Trusted connection:< br> "Driver={SQLServer};Server=Your_Server_Name;Database=Your_Database_Name;Trusted_Connection=yes;" ......

SQL Óë ORACLE µÄ±È½Ï (ת)


01¡¢SQLÓëORACLEµÄÄÚ´æ·ÖÅä
ORACLEµÄÄÚ´æ·ÖÅä´ó²¿·ÖÊÇÓÉINIT.ORAÀ´¾ö¶¨µÄ£¬Ò»¸öÊý¾Ý¿âʵÀý¿ÉÒÔÓÐNÖÖ·ÖÅä·½°¸£¬²»Í¬µÄÓ¦Óã¨OLTP¡¢OLAP£©ËüµÄÅäÖÃÊÇÓвàÖØµÄ¡£ SQL¸ÅÀ¨ÆðÀ´Ëµ£¬Ö»ÓÐÁ½ÖÖÄÚ´æ·ÖÅ䷽ʽ£º¶¯Ì¬ÄÚ´æ·ÖÅäÓ뾲̬ÄÚ´æ·ÖÅ䣬¶¯Ì¬ÄÚ´æ·ÖÅä³äÐíSQL×Ô¼ºµ÷ÕûÐèÒªµÄÄڴ棬¾²Ì¬ÄÚ´æ·ÖÅäÏÞÖÆÁËSQL¶ÔÄÚ´æµÄʹ Óá£
002¡¢SQ ......

sqlÖеÄDBO

DBOÊÇÿ¸öÊý¾Ý¿âµÄĬÈÏÓû§£¬¾ßÓÐËùÓÐÕßȨÏÞ£¬¼´DbOwner
ͨ¹ýÓÃDBO×÷ΪËùÓÐÕßÀ´¶¨Òå¶ÔÏó£¬Äܹ»Ê¹Êý¾Ý¿âÖеÄÈκÎÓû§ÒýÓöø²»±ØÌṩËùÓÐÕßÃû³Æ¡£
±ÈÈ磺ÄãÒÔUser1µÇ¼½øÈ¥²¢½¨±íTable£¬¶øÎ´Ö¸¶¨DBO£¬
µ±Óû§User2µÇ½øÈ¥Ïë·ÃÎÊTableʱ¾ÍµÃÖªµÀÕâ¸öTableÊÇÄãUser1½¨Á¢µÄ£¬ÒªÐ´ÉÏUser1.Table£¬Èç¹ûËû²»ÖªµÀÊÇÄ㽨µÄ£¬Ôò·ÃÎÊ» ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ