Sql Server·¢ÓʼþÅäÖÃ
¡¡Ç°Ì᣺°²×°sqlserver£¬°²×°outlook£¬outlookÒѾÕýÈ·ÅäÖá£
£¨1£©ÅäÖÃsqlserverµÄÆô¶¯Óû§ÎªÓòÓû§¡£sqlserverÆô¶¯Ä¬Èϵı¾µØÕË»§£¬±¾µØÕË»§Æô¶¯µÄ·þÎñÊÇÎÞ·¨Íê³ÉÓʼþµÄ·¢ËͽÓÊܹ¦Äܵġ£
ÅäÖÃÓòÓû§Æô¶¯£º´ò¿ª¿ØÖÆÃæ°åµÄ--¹ÜÀí¹¤¾ß--·þÎñ£¬ÕÒµ½sqlserver·þÎñ£¬²é¿´ÊôÐÔ¡£ÔÚÊôÐÔ´°¿ÚÖÐÑ¡ÔñµÇ½¡£ÔڵǽÉí·ÝÖÐÑ¡Ôñ“´ËÕË»§”£¬ÊäÈëÓòÓû§Ãû³ÆºÍÃÜÂ룬ÈçÓû§£ºwork\andrew£¬ÃÜÂ룺12345¡£
¡¡¡¡ÅäÖúúó£¬ÖØÐÂÆô¶¯·þÎñ£¬È»ºóÆô¶¯´úÀí·þÎñSQLSERVERAGENT£¬·Ö²¼Ê½·þÎñDistributed Transaction Coordinator
£¨2£©ÅäÖÃÓʼþ¡£´ò¿ª¿ØÖÆÃæ°åµÄ“Óʼþ”£¬Ñ¡Ôñ“ÏÔʾÅäÖÃÎļþ”¡£ÔÚÓʼþÊôÐÔÖУ¬Ñ¡ÔñĬÈϵÄÅäÖÃÎļþÃû³Æ£¬µã»÷“¸´ÖÆ”°´Å¥¡£¸øеÄÅäÖÃÎļþÆð¸öÃû×Ö£¬Èç“mail”.
£¨3£©´ò¿ªÆóÒµ¹ÜÀíÆ÷£¬ÔÚ“Ö§³Ö·þÎñ”ÖУ¬Ñ¡Ôñ“sqlÓʼþ”µÄÊôÐÔ¡£ÔÚÊôÐÔ´°¿ÚÖеÄÅäÖÃÎļþ¿òÖÐÊäÈë“mail”,µã»÷²âÊÔ¡£³É¹¦ºó£¬»á¸æËßÄãÒѾÆô¶¯ÁËÒ»¸ö»á»°¡£
ok£¬µ½ÕâÀһ¸ösqlserver·¢ÓʼþµÄÅäÖþÍÍê³ÉÁË
Ïà¹ØÎĵµ£º
SQLÔÚ½¨Á¢Óë·þÎñÆ÷µÄÁ¬½Óʱ³ö´íµÄ½â¾ö·½
ÔÚ½¨Á¢Óë·þÎñÆ÷µÄÁ¬½Óʱ³ö´í¡£ÔÚÁ¬½Óµ½ SQL Server 2005 ʱ£¬ÔÚĬÈϵÄÉèÖÃÏ SQL Server ²»ÔÊÐí½øÐÐÔ¶³ÌÁ¬½Ó¿ÉÄܻᵼÖ´Ëʧ°Ü¡£ (provider: ÃüÃû¹ÜµÀÌṩ³ÌÐò, error: 40 - ÎÞ·¨´ò¿ªµ½ SQL Server µÄÁ¬½Ó)
¸Õ¸Õ°²×°µÄÊý¾Ý¿âϵͳ£¬°´ÕÕÄ ......
http://blog.csdn.net/iamstillzhang/archive/2007/04/01/1548377.aspx
ÓÃmysqlÔ´Âë½øÐÐSQL½âÎö
MysqlÊÇͨ¹ýyacc½øÐÐSQLÓï¾ä½âÎöµÄ£¬ÕâÀï½éÉÜÒ»ÏÂÈçºÎʹÓÃmysqlµÄÔ´Âë½øÐÐSQLÓï¾ä½âÎö¡£ÓÉÓÚMysqlµÄÔ´´úÂë×¢ÊͱȽÏÉÙ£¬¶øÇÒȱÉÙ×ÊÁÏ£¬ËùÓÐЩµØ·½Ñо¿²»¹»ÉîÈë¡£
1 Filed½éÉÜ
MY ......
Sql Server ÖÐÒ»¸ö·Ç³£Ç¿´óµÄÈÕÆÚ¸ñʽ»¯º¯Êý
Select CONVERT(varchar(100), GETDATE(), 0): 05 16 2006 10:57AM
Select CONVERT(varchar(100), GETDATE(), 1): 05/16/06
Select CONVERT(varchar(100), GETDATE(), 2): 06.05.16
Select CONVERT(varchar(100), GETDATE(), 3): 16/05/06
Select CONVERT(varchar(100), GE ......
ÎÒÃÇʹÓÃoracleµÄÈ˶¼ÖªµÀ¿ÉÒÔͨ¹ýrownumαÁеõ½²éѯ½á¹ûÐòÁÐÇ°ÃæµÄÖ¸¶¨µÄÐУ¬ÎªÁËÏÂÃæ¸üºÃµÄ½øÐÐ˵Ã÷ÎÊÌ⣬ÎÒÃÇÏÈÀ´´´½¨Ò»¸öÊý¾Ý±ítable1£º
create table table1
(AAA integer primary key,
BBB varchar(30));
È»ºóÔÚtable1ÖвåÈë9ÌõÊý¾Ý£º
insert into table1 values (8, 'good');
insert into table1 values (7 ......
¾¹ýºÃ¼¸ÌìµÄ·ÜÕ½£¬JDBCÖÕÓڳɹ¦Á¬½ÓÁËSQL Server 2000£¬ÆÚ¼ä×ßÁ˲»ÉÙÍä·£¬ÔÚÕâÀï·ÖÏíÎÒµÄÒ»µã¾Ñé
Ò»¡¢ÎҵĻ·¾³
Windows XP+JDK6u15+Microsoft SQL Server 2000£¨SP4£©+JCreator
ÎÒÏÈÔÚÍøÉÏÏÂÔØÊý¾Ý¿âÇý¶¯³ÌÐò£¬Ä¿Â¼ÏÂÓÐÈý¸ö°ümsbase.jar mssqlserver.jar msutil.jar
1 ......