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

Microsoft SQL Server 2005µÄÅÅÐò¹æÔò³åÍ»½â¾ö(ת)

ÏÖÏó£º
        ÔÚʹÓÃMicrosoft SQL Server 2005ʱ£¬Òª´´½¨Ò»¸öµÇ¼Ãû£¬²¢Îª¸ÃµÇ¼Ãû¹ØÁªÁËÒ»¸öÊý¾Ý¿â£¬µ«ÊÇÔÚÑ¡Ôñ“°²È«¶ÔÏó”Ñ¡Ïîʱ£¬È´³öÏÖÁËÈçÌâËùʾµÄ´íÎó¡£ÆäËûÐÅÏ¢ÏÔʾΪ£ºÖ´ÐÐTransact-SQLÓï¾ä»òÅú´¦Àíʱ·¢ÉúÁËÒì³£(Microsoft.SqlServer.ConnectionInfo)¡£ÎÞ·¨½â¾öUNION²Ù×÷ÖГSQL_Latin1_General_CP1_CI_AS”ºÍ“Chinese_PRC_CI_AS”Ö®¼äµÄÅÅÐò¹æÔò³åÍ»¡££¨Microsoft SQL Server£¬´íÎó£º468£©
½â¾ö°ì·¨£º
·½·¨1£º
    1¡¢²åÈëmssql server µÄ°²×°ÅÌ£¬
2¡¢ÔËÐÐ-->CMD -->»Ø³µ
3¡¢ÔÚDOS ״̬ϽøÈëmssql server µÄsetupĿ¼£¬Ö®ºóÊäÈëÒÔÏ´úÂ룬»Ø³µºóÉÔµÈÊ®Êý·ÖÖÓ¼´¿É²¢¸ü¸Ä·þÎñÆ÷ÅÅÐò¹æÔò£¨Îñ±Ø×¢Òâ´óСд±ØÐëÒ»Ö£¬ÁíÍâSAPWD Ö¸Êý¾Ý¿â·þÎñÆ÷saÓû§µÄ·ÃÎÊÃÜÂ룩
start /wait setup.exe /qb INSTANCENAME=MSSQLSERVER REINSTALL=SQL_Engine REBUILDDATABASE=1 SAPWD=test SQLCOLLATION=Chinese_PRC_CI_AS
Windows / SQL Server 2005 µÄÅÅÐò¹æÔò
Èç Chinese_PRC_Stroke_CS_AI_WS£¬ÅÅÐò¹æÔòÃû³ÆÓÉÁ½²¿·Ý¹¹³É£»
Ç°°ë²¿·ÝÊÇÖ¸±¾ÅÅÐò¹æÔòËùÖ§³ÖµÄ×Ö·û¼¯¡£
Chinese_PRC Ö¸Õë¶Ô´ó½¼òÌå×ÖUNICODEµÄÅÅÐò¹æÔò¡£
ºó°ë²¿·Ý¼´ºó׺µÄº¬ÒåΪ£º
_BIN        Ö¸¶¨Ê¹ÓÃÏòºó¼æÈݵĶþ½øÖÆÅÅÐò˳Ðò¡£
_BIN2      Ö¸¶¨Ê¹Óà SQL Server 2005 ÖÐÒýÈëµÄÂëλ±È½ÏÓïÒåµÄ¶þ½øÖÆÅÅÐò˳Ðò¡£
_Stroke   °´±Ê»®ÅÅÐò
_CI(CS) ÊÇ·ñÇø·Ö´óСд£¬CI²»Çø·Ö£¬CSÇø·Ö
_AI(AS)    ÊÇ·ñÇø·ÖÖØÒô£¬AI²»Çø·Ö£¬ASÇø·Ö
_KI(KS)   ÊÇ·ñÇø·Ö¼ÙÃûÀàÐÍ£¬KI²»Çø·Ö£¬KSÇø·Ö
_WI(WS) ÊÇ·ñÇø·ÖÈ«°ë½Ç£¬WI²»Çø·Ö£¬WSÇø·Ö
¶þ½øÖÆ£º    ¶þ½øÖÆÅÅÐò˳Ðò¼ÈÇø·Ö´óСд£¬Ò²Çø·ÖÖØÒô¡£Èç¹ûδѡÔñ´ËÑ¡ÏÔò SQL Server ½«×ñÑ­×ÖµäÖж¨ÒåµÄÏà¹ØÓïÑÔ»ò×Öĸ±íµÄÅÅÐòºÍ±È½Ï¹æÔò¡£
¶þ½øÖÆÂëλ£ºÒÔUnicode Âëλ¶ÔÊý¾Ý½øÐбȽϻòÅÅÐò¡£¶ÔÓÚ·Ç Unicode Êý¾ÝÔòʹÓöþ½øÖÆÅÅÐòÏàͬµÄ±È½Ï·½Ê½¶ÔÒÑÅÅÐòµÄ SQL Server Êý¾Ý½øÐбȽϵÄÓ¦ÓóÌÐò²»±ØÖØжÔÊý¾Ý½øÐÐÅÅÐò¡£//Ìá¸ßÐÔÄÜ¡£
Çø·Ö´óСд£ºÈç¹ûδѡÔñ´ËÑ¡ÏÔò SQL Server ÈÏΪ×ÖĸµÄ´óСдÐÎʽ¶ÔÓÚÅÅÐòÄ¿µÄ¶øÑÔÊÇÏàͬµÄ¡£
Çø·ÖÖØÒô£º Èç¹ûδѡÔñ´ËÏÔÚÅÅÐòʱ£¬SQL Server ½«°Ñ×ÖĸµÄÖØÒôÐÎʽºÍ·ÇÖØÒôÐÎʽÊÓΪÏàͬ¡£
Çø·


Ïà¹ØÎĵµ£º

sql»ñÈ¡ÈÕÆÚ

declare
 @aa varchar(20)
set @aa= CONVERT(varchar(100), GETDATE(), 23)
--//ÈÕ
print @aa+' 0:00:00.000'
print @aa+' 23:59:59.999'
--//ÖÜ
print CONVERT(varchar(100), DATEADD(wk, DATEDIFF(wk,0,getdate()), 0), 23)+' 0:00:00.000'
print CONVERT(varchar(100), DATEADD(wk, DATEDIFF(wk,0,getdate( ......

ÍâÁ¬½ÓsqlµÄÒ»¸öÎÊÌâ

µ±ÔÚÄÚÁ¬½Ó²éѯÖмÓÈëÌõ¼þʱ£¬ÎÞÂÛÊǽ«Ëü¼ÓÈëµ½join×Ӿ䣬»¹ÊǼÓÈëµ½where×Ӿ䣬ÆäЧ¹ûÊÇÍêÈ«Ò»ÑùµÄ£¬µ«¶ÔÓÚÍâÁ¬½ÓÇé¿ö¾Í²»Í¬ÁË¡£µ±°ÑÌõ¼þ¼ÓÈëµ½ join×Ó¾äʱ£¬»á·µ»ØÍâÁ¬½Ó±íµÄÈ«²¿ÐУ¬È»ºóʹÓÃÖ¸¶¨µÄÌõ¼þ·µ»ØµÚ¶þ¸ö±íµÄÐС£Èç¹û½«Ìõ¼þ·Åµ½where×Ó¾äÖУ¬½«»áÊ×ÏȽøÐÐÁ¬½Ó²Ù×÷£¬È»ºóʹÓÃwhere×Ó¾ä¶ÔÁ¬½ÓºóµÄÐнøÐÐɸѡ¡ ......

sql »ù±¾²éѯÓï¾ä

SQL·ÖÀࣺ
DDL—Êý¾Ý¶¨ÒåÓïÑÔ(CREATE£¬ALTER£¬DROP£¬DECLARE)
DML—Êý¾Ý²Ù×ÝÓïÑÔ(SELECT£¬DELETE£¬UPDATE£¬INSERT)
DCL—Êý¾Ý¿ØÖÆÓïÑÔ(GRANT£¬REVOKE£¬COMMIT£¬ROLLBACK)
Ê×ÏÈ,¼òÒª½éÉÜ»ù´¡Óï¾ä£º
1¡¢ËµÃ÷£º´´½¨Êý¾Ý¿â
CREATE DATABASE database-name
2¡¢ËµÃ÷£ºÉ¾³ýÊý¾Ý¿â
drop database dbname ......

ÈçºÎ´ÓEXPDPµ¼³öµÄÎļþÀï»ñµÃÓû§ÊÚȨµÄSQLÓï¾ä


ÈçºÎ´ÓEXPDPµ¼³öµÄÎļþÀï»ñµÃÓû§ÊÚȨµÄSQLÓï¾ä 
 
´òËãǨÒÆһϵͳ£¬ÓÉÓÚÊÇ¿çƽ̨µÄǨÒÆ£¬RMANÊDz»ÄÜÓÃÁË£¬¿¼ÂÇʹÓÃEXPDP/IMPDPÀ´½øÐе¼Èëµ¼³ö£¬µ¼Èë¹ý³Ì·¢ÏÖN¶àÓû§µÄȨÏÞ¸ã³öÁË£¬Âé·³Öص¼ÊÇ¿ÉÒÔ»¨Ê±¼äÌ«³¤£¬Ñо¿ÁËһϣ¬Éú³ÉÁËÈ«²¿µÄSQLµÄ½Å±¾¡£
impdp system/manager schemas=user DIRECTORY=DUMP_FILES ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ