CodeSmithÁ¬½ÓAccess,Sql,Oracle,mysql
ACCESSÊý¾Ý¿â
1:CodeSmithÑ¡ÖÐÁ´½ÓÀàÐÍÊÇ£ºADOXSchema
2:ÎÞÃÜÂëµÄAccessÁ´½ÓΪ£º
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\hh\db.mdb;
3:ÓÐÃÜÂëµÄAccessÁ´½Ó£º
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\hh\db.mdb;
Jet OLEDB:Database Password=1111
SqlÊý¾Ý¿â
server=192.1.1.14;User ID=test;Password=test;database=test;
Pooling=TRUE;Max Pool Size=1000;Connection Reset=FALSE
OracleÊý¾Ý¿â
1:ÏÂÔØÌṩµÄORACAL Çý¶¯
2:Data Source=192.1.1.14;Data Source=test;Password=test;User ID=test
MySqlÊý¾Ý¿â
server=127.0.0.1;User ID=root;Password=......;database=myProject;
Ïà¹ØÎĵµ£º
SQL Server ÓÅ»¯ÐÔÄܵö·½Ãæ
(Ò»).Êý¾Ý¿âµÄÉè¼Æ
¿ÉÒԲο´×î½üÂÛ̳ÉϳöÏÖÒ»¸ö¾«»ªÌûhttp://topic.csdn.net/u/20100415/10/a377d835-acbd-4815-8bcb-b367f88ac8b5.html?92227
Êý¾Ý¿âÉè¼Æ°üº¬ÎïÀíÉè ......
SQL SERVERÐÔÄÜÓÅ»¯×ÛÊö
--ÔÖø:Haiwer
½üÆÚÒò¹¤×÷ÐèÒª£¬Ï£Íû±È½ÏÈ«ÃæµÄ×ܽáÏÂSQL SERVERÊý¾Ý¿âÐÔÄÜÓÅ»¯Ïà¹ØµÄ×¢ÒâÊÂÏÔÚÍøÉÏËÑË÷ÁËÒ»ÏÂ,·¢ÏֺܶàÎÄÕÂ,ÓеͼÁгöÁËÉϰÙÌõ,µ«ÊÇ×Ðϸ¿´·¢ÏÖ£¬ÓкܶàËÆÊǶø·Ç»òÕß¹ýʱ(¿ÉÄܶÔSQL SERVER6.5ÒÔǰµÄ°æ±¾»òÕßORACLEÊÇÊÊÓõÄ)µÄÐÅÏ¢£¬Ö»ºÃ×Ô¼º¸ù¾ÝÒÔǰµÄ¾ÑéºÍ²âÊÔ½á¹û½ ......
--ÈÕÆÚת»»²ÎÊý,ÖµµÃÊÕ²Ø
select CONVERT(varchar, getdate(), 120)
2004-09-12 11:06:08
select convert(varchar(10),getdate() ,120)
----------
2009-04-09
select replace(replace(replace(CONVERT(varchar, getdate(), 120 ),'-',''),' ',''),':','')
20040912110608
select CONVERT(varchar(12) , get ......
×î½üÔÚÒ»¸öÂÛ̳ÖкÍÈËÌÖÂÛÁËһͨ¹ØÓÚORACLEѧϰµÄÎÊÌ⣬½áºÏÎÒÒ²ËãÓÐ10ÄêµÄORALCE ʹÓÃѧϰµÄ¾Àú¸ø´ó¼ÒÒ»µã½¨Òé°É¡£
1¡¢ORACLEÊý¾Ý¿âÊÇÒ»¸ö·Ç³£ÅӴ󣬷dz£¾«ÉîµÄϵͳ£¬ÒªÓг¤ÆÚ¿¹Õ½µÄ×¼±¸£¬ÄãÖ¸ÍûÄÜÔÚÒ»¸öÔÂÄÚѧ»áÈëÃÅÄÇÊÇ¿ÉÒԵ쬵«ÊÇÄãÒªÂò±¾24Ì쾫ͨORACLEÊý¾Ý¿âÕâÑù²»¸ºÔðÔðÈεÄÊ飬²¢Ïëͨ¹ýËûÀ´ÕÆÎÕORACLE£¬Ö»ÄÜÊÇ³Õ ......