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

SQLSERVERÓû§È¨ÏÞ¹ÜÀíÊý¾Ý¿â

Óû§È¨ÏÞ¹ÜÀí
Ò»¡¢·þÎñÆ÷µÇ¼ÕʺźÍÓû§ÕʺŹÜÀí
1.SQL Server·þÎñÆ÷µÇ¼¹ÜÀí
²»¹ÜʹÓÃÄÄÖÖÈÏ֤ģʽ£¬Óû§¶¼±ØÐëÏȾ߱¸ÓÐЧµÄÓû§µÇ¼Õʺš£SQL ServerÓÐÈý¸öĬÈϵÄÓû§µÇ¼Õʺţº¼´sa¡¢Builtin\administratorsºÍguest¡£saÊÇϵͳ¹ÜÀíÔ±(system administrator)µÄ¼ò³Æ£¬ÊÇÒ»¸öÌØÊâµÄÓû§£¬ÔÚSQL ServerϵͳºÍËùÓÐÊý¾Ý¿âÖÐÓµÓÐËùÓеÄȨÏÞ¡£SQL Server»¹ÎªÃ¿Ò»¸öWindows NTϵͳ¹ÜÀíÔ±ÌṩÁËÒ»¸öĬÈϵÄÓû§ÕʺÅBuiltin\administrators¡£Õâ¸öÕʺÅÔÚϵͳºÍËùÓÐÊý¾Ý¿âÖÐÒ²ÓµÓÐËùÓеÄȨÏÞ¡£¶øguestÕʺÅΪĬÈÏ·ÃÎÊϵͳÓû§Õʺš£ÀûÓÃÆóÒµ¹ÜÀíÆ÷¿ÉÒÔ´´½¨¡¢¹ÜÀíSQL ServerµÇ¼Õʺš£Æä¾ßÌå²½ÖèÈçÏ£º
(1)´ò¿ªÆóÒµÆ÷£¬µ¥»÷·þÎñÆ÷µÄ“+”£¬Õ¹¿ª°²È«ÐÔÎļþ¼Ð£»
(2)ÓÒ»÷µÇ¼ͼ±ê£¬Ñ¡Ôñ“н¨µÇ¼”£»
(3)ÔÚ“Ãû³Æ”Îı¾¿òÖÐÊäÈëµÇ¼Ãû£¬Ñ¡Ôñн¨µÄÓû§ÕʺŵÄÈÏ֤ģʽ£»²¢Ñ¡ÔñĬÈϵÄÊý¾Ý¿âºÍÓïÑÔ¡£
(4)Ñ¡Ôñ“·þÎñÆ÷½ÇÉ«”£¬ÔÚÁгöµÄ¹Ì¶¨·þÎñÆ÷½ÇÉ«µÄ×ó¶Ë¸´Ñ¡¿òÖÐÑ¡ÔñÏàÓ¦µÄ·þÎñÆ÷½ÇÉ«£»
(5)Ñ¡Ôñ“Êý¾Ý¿â·ÃÎÊ”£¬µ¥»÷Êý¾Ý¿â×ó±ßµÄ¸´Ñ¡¿ò£¬±íʾ¸ÃÓû§¿ÉÒÔ·ÃÎÊÏàÓ¦µÄÊý¾Ý¿âÒÔ¼°¸ÃÕʺÅÔÚÊý¾Ý¿âÖеÄÓû§Ãû¡£Ï²¿µÄÁбí¿òÁгöÁËÏàÓ¦µÄÊý¾Ý¿âÖеÄÊý¾Ý¿â½ÇÉ«Çåµ¥£¬¿ÉÒÔÖ¸¶¨¸ÃÕʺÅËùÊôµÄÊý¾Ý¿â½ÇÉ«£»
(6)µ¥»÷“È·¶¨”¼´¿ÉÍê³ÉµÇ¼ÕʺŵĴ´½¨¡£
´ËÍ⣬»¹¿ÉÒÔʹÓô´½¨µÇ¼Ïòµ¼¹¤¾ß´´½¨µÇ¼Õʺš£¾ßÌå¹ý³ÌÈçÏ£º
(1)´ò¿ªÆóÒµ¹ÜÀíÆ÷£¬Ñ¡Ôñ¹¤¾ßÖеēÏòµ¼--´´½¨µÇ¼Ïòµ¼”£»
(2)Ñ¡ÔñÉí·ÝÑé֤ģʽ£»
(3)
(4)
(5)
(6)
2.Óû§ÕʺŹÜÀí
ÔÚÊý¾Ý¿âÖУ¬Ò»¸öÓû§»ò¹¤×÷×éÈ¡µÃºÏ·¨µÄµÇ¼Õʺţ¬Ö»±íÃ÷¸ÃÕʺÅͨ¹ýÁËWindows NTÈÏÖ¤»òÕßSQL ServerÈÏÖ¤£¬µ«²»ÄܱíÃ÷Æä¿ÉÒÔ¶ÔÊý¾Ý¿âÊý¾ÝºÍÊý¾Ý¿â¶ÔÏó½øÐÐijÖÖ»òÕßijЩ²Ù×÷,scsi£¬Ö»Óе±ËûͬʱӵÓÐÁËÓû§Õʺź󣬲ÅÄܹ»·ÃÎÊÊý¾Ý¿â¡£ÔÚÒ»¸öÊý¾Ý¿âÖУ¬Óû§ÕʺÅΨһ±êʶһ¸öÓû§£¬Óû§¶ÔÊý¾Ý¿âµÄ·ÃÎÊȨÏÞÒÔ¼°¶ÔÊý¾Ý¿â¶ÔÏóµÄËùÓйØÏµ¶¼ÊÇͨ¹ýÕʺÅÀ´¿ØÖƵġ£Óû§ÕʺÅ×ÜÊÇ»ùÓÚÊý¾Ý¿âµÄ£¬¼´Á½¸ö²»Í¬µÄÊý¾Ý¿â¿ÉÒÔÓÐÁ½¸öÏàͬµÄÓû§Õʺţ¬²¢ÇÒÒ»¸öµÇ¼ÕʺÅÒ²×ÜÊÇÓëÒ»¸ö»ò¶à¸öÊý¾Ý¿âÓû§ÕʺÅÏà¶ÔÓ¦µÄ¡£È磬µÇ¼ÕʺÅsa×Ô¶¯Óëÿһ¸öÊý¾Ý¿âÓû§dboÏà¹ØÁª¡£Í¨³£¶øÑÔ£¬Êý¾Ý¿âÓû§ÕʺÅ×ÜÊÇÓëijһµÇ¼ÕʺÅÏà¹ØÁª£¬µ«ÓÐÒ»¸öÀýÍ⣬ÄǾÍÊÇguestÓû§¡£ÔÚ°²×°SQL Serverϵͳʱ£¬guestÓû§±»¼ÓÈëµ½master£¬pubs£¬tempdbºÍnorthwindÊý¾Ý¿âÖУ¬¸ÃÓû§Ö÷ÒªÊÇÈÃÄÇЩûÓÐÊôÓÚ×Ô¼ºµÄÓû§ÕʺÅ


Ïà¹ØÎĵµ£º

SqlServer´¥·¢Æ÷Àí½â

´¥·¢Æ÷µÄ¶¨ÒåÓë·ÖÀà:
Ö»Òª´¥·¢Æ÷ËùÔÚ±íÉϵĶÔӦʱ¼ä·¢Éú,¾Í»á×Ô¶¯Ö´Ðиô¥·¢Æ÷µÄ´úÂë.ʵ¼ÊÉÏ,ÎÒÃDz¢²»ÄÜÖ±½Óµ÷Óô¥·¢Æ÷,ΨһµÄ·½·¨ÊÇÔÚ·ÖÅäŶ´¥·¢Æ÷µÄ±íÉÏÖ´ÐÐijÖÖÐÐΪ·½¿É¼¤»î´¥·¢Æ÷.      [´¥·¢Æ÷ÊÇÒ»ÖÖÌØÊâµÄ´æ´¢¹ý³Ì,ËûÔÚÖ´ÐÐÌØ¶¨µÄÓïÑÔʼþʱÉúЧ
 
     & ......

sqlServer,oracleÖÐcase¹Ø¼ü×ÖµÄÓ÷¨

    ÔÚдSQLʱ£¬ÓÐʱҪ¸ù¾ÝÒÑÓеÄÁÐÖµ¹¹ÔìеÄÁÐÖµ£¬Õâʱ¾ÍÒªÓõ½µÄSQLÖеÄcase¹Ø¼ü×Ö¡£ÈçÏÂËùʾ²éѯ¸ºÔðÈËÐÅÏ¢±í£¨T_MS_CustomerCrmInfoDutyPerson£©ÖеÄÊÇ·ñÊÇÖ÷Òª¸ºÔðÈË£¨isMainDuty£©×ֶΣ¬µ«ÊÇÕâ¸ö×ֶεÄÖµÊÇÒÔö¾ÙµÄ·½Ê½´æ´¢µÄ£¬´æ´¢0±íʾÊÇ·ñ£¬1±íʾÊÇ£¬·ñÔò±íʾδÅжϡ£Õâʱֱ½Ó²éѯ³öµÄÖµ²»ÊÇ ......

SQLServer ÖбíµÄ×ÔÔö³¤ÁÐ

1.½¨±í(Create table)ʱʹÓàIDENTITY (SEED,INCREMENT)
ÆäÖÐSEEDÊÇÆðʼֵ£¬INCREMENTÊÇÔöÁ¿¡£
Àý£º
CREATE TABLE mytable1
    (
      [user_id] BIGINT NOT NULL
                       IDENTITY(1, 1) , ......

Oracle´æ´¢¹ý³Ìת³ÉSqlserver´æ´¢¹ý³Ì

Oracle´æ´¢¹ý³Ìת³ÉSqlserver´æ´¢¹ý³Ì
1.ÈÕÆÚת»»
Oracle£º TO_NUMBER(TO_CHAR(SYSDATE, 'YYYYMMDD'))
SqlServer£ºCAST(CONVERT(CHAR(8),GETDATE(), 112) AS INT)
    ×¢£ºÆäÖБYYYYMMDD’¸ñʽ   ¶ÔÓ¦112
2.ROWIDת»»
Oracle£º ROWID
SqlServer: PRIMARY KEY(±íÖ÷¼ü)
3.ROWNUM ......

MyEclipseÖÐÅäÖÃSQLServer 2005Êý¾Ý¿â


1.°²×°ºÃSQLServer 2005Êý¾Ý¿âÈí¼þ£¬½Ó×Å×îÖØÒªµÄ¾ÍÊǰ²×°Êý¾Ý¿âÇý¶¯SQL Server 2005 driver for JDBC£¬¿ÉÒÔµ½:http://download.microsoft.com/download/8/B/D/8BDABAE2-B6EA-41D4-B903-7916EF3690EF/sqljdbc_1.2.2323.101_enu.exeÏÂÔØ
2.½«JDBC½âѹµ½ÈÎÒâµÄλÖã¬ÔÚ°²×°Ä¿Â¼ÀïÕÒµ½sqljdbc.jarÎļþ£¬ÒÔǰµÄÎÄÕÂÖÐÒѾ­½²¹ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ