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

ÈçºÎÀûÓÃSQLSERVER2000µÄDTS µ¼ÈëÊý¾Ýµ½Oracle£¿

¾ßÌå²½Öè¾Í²»¶à˵ÁË £¬Òªµ¼³öµÄSQLSERVER±í½Ð LDJCUS£¬Ö÷¼ü Uid (int   ×Ô¶¯Ôö³¤ÁÐ)£¬µ¼Èëµ½Oracle×ܱ¨´í£º¶ÔÏóÃûÎÞЧ £¬È¥µôÖ÷¼üÁоͿÉÒÔ£¬²»ÖªµÀΪʲô£¿ÄѵÀ×Ô¶¯Ôö³¤µÄÖ÷¼üÁоͲ»Äܵ¼Èëµ½OracleÖУ¿£¿£¿Òɻ󡣡£¡£¡£


Ïà¹ØÎĵµ£º

ÍüÁËOracleµÄsysÓû§ºÍMySQLµÄrootÓû§ÃÜÂ룬½â¾ö·½·¨

ÍüÁËOracleµÄsysÓû§ºÍMySQLµÄrootÓû§ÃÜÂ룬½â¾ö·½·¨
2007Äê03ÔÂ16ÈÕ ÐÇÆÚÎå 09:44
×÷Õߣºhexiong¡¡
°æÈ¨ÉùÃ÷£º¿ÉÒÔÈÎÒâ×ªÔØ£¬×ªÔØÊ±ÇëÎñ±ØÒÔ³¬Á´½ÓÐÎʽ±êÃ÷ÎÄÕÂԭʼ³ö´¦ºÍ×÷ÕßÐÅÏ¢¼°±¾ÉùÃ÷¡£
http://hi.baidu.com/hexiong/blog/item/b4acd72a85272d2cd42af1b1.html
¾­³£Åöµ½ÓÐÈËÔÚÂÛ̳ÉÏÎÊÕâ¸öÎÊÌ⣬¸É´àÔÚÕâÀï×ܽáÒ ......

SqlServerÈ«¾Ö±äÁ¿±¸Íü


È«¾Ö±äÁ¿ÊÇSQL ServerϵͳÄÚ²¿ÊÂÏȶ¨ÒåºÃµÄ±äÁ¿£¬²»ÓÃÓû§²ÎÓ붨Ò壬¶ÔÓû§¶øÑÔ£¬Æä×÷Ó÷¶Î§²¢²»¾ÖÏÞÓÚijһ³ÌÐò£¬¶øÊÇÈκγÌÐò¾ù¿ÉËæÊ±µ÷Óá£È«¾Ö±äÁ¿Í¨³£ÓÃÓڴ洢һЩSQL ServerµÄÅäÖÃÉ趨ֵºÍЧÄÜͳ¼ÆÊý¾Ý¡£
SQL ServerÒ»¹²ÌṩÁË30¶à¸öÈ«¾Ö±äÁ¿£¬±¾½ÚÖ»¶ÔһЩ³£ÓñäÁ¿µÄ¹¦ÄܺÍʹÓ÷½·¨½øÐнéÉÜ¡£È«¾Ö±äÁ¿µÄÃû³Æ¶¼ÊÇÒÔ ......

¼òµ¥Èý²½×ß¶ÂËÀSQLServer×¢Èë©¶´

SQL×¢ÈëÊÇʲô?
¡¡¡¡Ðí¶àÍøÕ¾³ÌÐòÔÚ±àдʱ£¬Ã»ÓжÔÓû§ÊäÈëÊý¾ÝµÄºÏ·¨ÐÔ½øÐÐÅжϣ¬Ê¹Ó¦ÓóÌÐò´æÔÚ°²È«Òþ»¼¡£Óû§¿ÉÒÔÌá½»Ò»¶ÎÊý¾Ý¿â²éѯ´úÂë(Ò»°ãÊÇÔÚä¯ÀÀÆ÷µØÖ·À¸½øÐÐ,ͨ¹ýÕý³£µÄwww¶Ë¿Ú·ÃÎÊ)£¬¸ù¾Ý³ÌÐò·µ»ØµÄ½á¹û£¬»ñµÃijЩÏëµÃÖªµÄÊý¾Ý£¬Õâ¾ÍÊÇËùνµÄSQL Injection£¬¼´SQL×¢Èë¡£
¡¡¡¡ÍøÕ¾µÄ¶ñÃΗ—SQL×¢Èë ......

oracle merge into µÄÓ÷¨Ïê½â


×÷Óãºmerge into ½â¾öÓÃB±í¸úÐÂA±íÊý¾Ý£¬Èç¹ûA±íÖÐûÓУ¬Ôò°ÑB±íµÄÊý¾Ý²åÈëA±í£»
Óï·¨£º
MERGE INTO [your table-name] [rename your table here]
USING ( [write your query here] )[rename your query-sql and using just like a table]
ON ([conditional expression here] AND [...]...)
WHEN MATHED THEN [here ......

µ¼ÈëOracleʵÀý

--´´½¨Óû§
create user iagent identified by ia
--profile default 
default  tablespace users
temporary tablespace temp;
--account unlock;
 
--ɾ³ýÓû§
drop user iagent cascade;
--ÐÞ¸ÄÓû§ÃÜÂë
  alter  user  iagent  identified   by ia;
--¸ø´´½¨µ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ