Sql Server 2005 ÖеÄͬÒå´ÊÓ븴ÖÆ
ÔÚ2005ÖÐÓÐͬÒå´ÊÓ븴ÖƵĸÅÄî
ͬÒå´ÊµÄÖ÷Òª×÷ÓÃÊÇ£º
Ò»£ºË޶̶ÔÏóµÄÃû³Æ£¬¼õÉÙ¹¤×÷ÈËÔ±ÊéдµÄʱ¼ä£¬Ìá¸ßЧÂÊ¡£ÎÒÃÇÖªµÀ·ÃÎÊÊý¾Ý¿âÒ»¸ö¶ÔÏóµÄͨ³£×îÈ«µÄ¶ÔÏóÃû³ÆÊÇ£º·þÎñÆ÷Ãû³Æ¡£Êý¾Ý¿âÃû³Æ¡£¼Ü¹¹Ãû³Æ¡£¶ÔÏóÃû³Æ
¶þ£ºÍ¬²½Êý¾Ý¡£¿ÉÒÔ½«ÆäËüÊý¾Ý¿âµÄ¶ÔÏóÉõÖÁÊÇÔ¶³ÌÊý¾Ý¿âÖеĶÔÏóÓ³Éäµ½µ±Ç°µÄÊý¾Ý¿â£¬´Ó¶ø´ïµ½ÁËͬ²½Êý¾ÝµÄ×÷ÓÃ
¸´ÖƵÄÖ÷Òª×÷ÓÃÊÇ£º
Ò»£ºÍ¬²½Êý¾Ý
¸´ÖÆÊÇÒ»×é¼¼Êõ£¬Ëü½«Êý¾ÝºÍÊý¾Ý¿â¶ÔÏó´ÓÒ»¸öÊý¾Ý¿â¸´Öƺͷַ¢µ½ÁíÒ»¸öÊý¾Ý¿â£¬È»ºóÔÚÊý¾Ý¿â¼ä½øÐÐͬ²½£¬ÒÔά³ÖÒ»ÖÂÐÔ¡£Ê¹Óø´ÖÆ£¬¿ÉÒÔÔÚ¾ÖÓòÍøºÍ¹ãÓòÍø¡¢²¦ºÅÁ¬½Ó¡¢ÎÞÏßÁ¬½ÓºÍ Internet ÉϽ«Êý¾Ý·Ö·¢µ½²»Í¬Î»ÖÃÒÔ¼°·Ö·¢¸øÔ¶³Ì»òÒƶ¯Óû§¡£
¼ÈȻͬÒå´ÊºÍ¸´Öƶ¼ÓÐͬ²½Êý¾ÝµÄ×÷Óã¬ÄǹؼüµÄÇø±ðµãÔÚÄÄÀïÄØ£¿¶ÔÒ»¸öͬÒå´Ê¶ÔÏóµÄ²Ù×÷ʵ¼ÊÉϾÍÊǶÔʵ¼ÊÕæÊÇ´æÔÚµÄÄǸö¶ÔÏóµÄ²Ù×÷£¬Í¬Òå´Ê¶ÔÏóÆäʵ¾ÍÖ»ÊÇÒ»¸öÕæÊǶÔÏóµÄ¿½±´£¬ÒªÏëͨ¹ýͬÒå´Ê´ïµ½¶Ô¶à¸öÊý¾Ý¿âµÄͬһ¸ö¶ÔÏó½øÐÐͬʱ¸üÐÂÊDz»¿ÉÄܵģ»¶ÔÓÚ¸´ÖƼ¼Êõ¶øÑԾͿÉÒÔ´ïµ½¸ü¸ÄÒ»¸öÊý¾Ý¿âÖеĶÔÏó¾Í¿ÉÒÔͬʱ¸ü¸ÄÈκÎÆäËüÊý¾Ý¿âÖеÄͬһ¶ÔÏóÁË
Ïà¹ØÎĵµ£º
http://www.javaeye.com/topic/366991#
×÷Ϊһ¸ö¿ª·¢ÈËÔ±£¬¿ªÊ¼ÈÏÕæϵͳѧϰ
Oracle SQLÒ²Ö»ÓÐÔÂÓ֮࣬ǰµÄ
SQLÖª
ʶ½ö½öÊÇÏîÄ¿ÀïÃæÓõ½Ê²Ã´¾ÍÈ¥¿´Ê²Ã´£¬¼òµ¥Ëµ¾ÍÊÇ
Read The Fxxking Guide¡£ÔÚϵͳѧϰ
Oracle
SQL֮ǰ£¬°³µÄÏë·¨¾ÍÊÇ“°´ÕÕÐèÇóÍê³É¹¦ÄÜ£¬Ê£ÏµĽ»¸ø
DBAÀ´´¦À픡£Õâ¸öÏë·¨´ÓÕûÌåÀ´¿´ÏÔ ......
Oracle µÄSQL*LOADER¿ÉÒÔ½«ÍⲿÊý¾Ý¼ÓÔص½Êý¾Ý¿â±íÖС£ÏÂÃæÊÇSQL*LOADERµÄ»ù±¾Ìص㣺
1£©ÄÜ×°È벻ͬÊý¾ÝÀàÐÍÎļþ¼°¶à¸öÊý¾ÝÎļþµÄÊý¾Ý
2£©¿É×°Èë¹Ì¶¨¸ñʽ£¬×ÔÓɶ¨½çÒÔ¼°¿É¶È³¤¸ñʽµÄÊý¾Ý
3£©¿ÉÒÔ×°Èë¶þ½øÖÆ£¬Ñ¹ËõÊ®½øÖÆÊý¾Ý
4£©Ò»´Î¿É¶Ô¶à¸ö±í×°ÈëÊý¾Ý
5£©Á¬½Ó¶à¸öÎïÀí¼Ç¼װµ½Ò»¸ö¼Ç¼ÖÐ
6£©¶ÔÒ»µ¥¼Ç¼·Ö½âÔÙ×°Èëµ½± ......
ÔÚËÑË÷Êý¾Ý¿âÖеÄÊý¾Ýʱ£¬SQL ͨÅä·û¿ÉÒÔÌæ´úÒ»¸ö»ò¶à¸ö×Ö·û¡£
SQL ͨÅä·û±ØÐëÓë LIKE ÔËËã·ûÒ»ÆðʹÓá£
ÔÚ SQL ÖУ¬¿ÉʹÓÃÒÔÏÂͨÅä·û£º
ͨÅä·ûÃèÊö
%
Ìæ´úÒ»¸ö»ò¶à¸ö×Ö·û
_
½öÌæ´úÒ»¸ö×Ö·û
[charlist]
×Ö·ûÁÐÖеÄÈκε¥Ò»×Ö·û
[^charlist]
»òÕß
[!charlist]
²»ÔÚ×Ö·ûÁÐÖеÄÈκε¥Ò»×Ö·û
ÔʼµÄ±í (ÓÃÔÚÀý×ÓÖ ......
±È½ÏÁ½¸öSQLµÄÖ´ÐÐʱ¼ä
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[PROC_SQL_COMP]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[PROC_SQL_COMP]
GO
/*--²âÊÔÁ½×éSQLµÄƽ¾ùʱ¼ä
ÀûÓÃosql.exeÀ´²âÊÔÁ½×é SQL Óï¾äµÄÖ´ÐÐʱ¼ä
²âÊԵĴ洢¹ý³ ......
簡體數據庫轉·±體數據庫µÄ問題 °ÝÍÐÁË
ALTER DATABASE DatabaseName SET SINGLE_USER WITH ROLLBACK IMMEDIATE
ALTER DATABASE DatabaseName COLLATE Chinese_Taiwan_Stroke_CI_AS
ALTER DATABASE DatabaseName SET MULTI_USER WITH ROLLBACK ......