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

sql´¥·¢Æ÷ÎÊÌâ - MS-SQL Server / »ù´¡Àà

Èç¹ûÖ´ÐвåÈë²Ù×÷À´Ö´Ðд¥·¢Æ÷£¬±ÈÈçÒ»´Î²åÈë10ÌõÓï¾ä¡£´¥·¢Æ÷µÄÖ´ÐÐÊÇÔÚ²åÈë10ÌõÓï¾äºóÖ´ÐУ¬»¹ÊÇÿ²åÈëÒ»Ìõ¾ÍÖ´ÐÐÒ»´Î´¥·¢Æ÷¡£ лл
°´ÕÕÄãµÄÃèÊö £¬Õâ¸ö´¥·¢Æ÷ÊÇÔÚÿ¸öÓï¾ä²åÈëºó¶¼Ö´ÐУ¬¹²Ö´ÐÐ 10´Î¡£

ÿ²åÈëÒ»Ìõ¾ÍÖ´ÐÐÒ»´Î´¥·¢Æ÷¡£

½¨ÒéÉÙʹÓô¥·¢Æ÷ ÈçÓöµ½rollback ·þÎñÆ÷ѹÁ¦»á¼Ó´ó

ÒýÓÃ
Èç¹ûÖ´ÐвåÈë²Ù×÷À´Ö´Ðд¥·¢Æ÷£¬±ÈÈçÒ»´Î²åÈë10ÌõÓï¾ä¡£´¥·¢Æ÷µÄÖ´ÐÐÊÇÔÚ²åÈë10ÌõÓï¾äºóÖ´ÐУ¬»¹ÊÇÿ²åÈëÒ»Ìõ¾ÍÖ´ÐÐÒ»´Î´¥·¢Æ÷¡£            лл

Ò»´Î²åÈëÒ»ÌõÊý¾Ý.
´¥·¢Æ÷µÄÖ´ÐÐÊÇÿ²åÈë,¸ü¸Ä»òɾ³ýÒ»ÌõÊý¾ÝºóÖ´Ðд¥·¢Æ÷ÖеĴúÂë.

É¢·¢Æ÷ÊÇÿִÐÐÒ»´ÎÓï¾ä,´¥·¢Ò»´Î
¶Ôinsert´¥·¢Æ÷,ÊÇÿִÐÐÒ»´Îinsert,´¥·¢Ò»´Î,²»¹Üÿ´Î²åÈë¶àÉÙÌõ¼Ç¼
Ïóinsert ...values(...)Óï¾ä,ÿ´Î²åÈëÒ»Ìõ¼Ç¼,´¥·¢Ò»´Î.
Ïóinsert ....select ...Óï¾ä,ÿ´Î¿ÉÄܲåÈë¶àÌõ¼Ç¼,´¥·¢Ò»´Î,
ÔÚд´¥·¢Æ÷ʱҪעÒâ!


·¹ý£¬Ñ§Ï°.....
¡£¡£¡£

SQL code:

Ö»ÒªÂú×ã´¥·¢Æ÷Ìõ¼þ¾Í»áÖ´ÐÐ...



²Ù×÷Ò»´Î ´¥·¢Ò»´Î
¼´Ê¹ÄãÒ»´Î²åÈë¶àÌõ Ò²Ö»´¥·¢Ò»´Î

Òª¿´ÓÃÓï¾ä´¥·¢Æ÷»¹ÊÇÔª×é¼¶´¥·¢Æ÷ÁË
========================================
¹ú²úÊý¾Ý¿â http://bbs.dameng.com
========================================


Ïà¹ØÎÊ´ð£º

Êý¾ÝÒÔxml¸ñʽ·µ»Ø - MS-SQL Server / Ó¦ÓÃʵÀý

´ÓÊý¾Ý¿âÖвéѯһÕűíµÄÊý¾Ý
select ²¿ÃÅ,ÐÕÃû from tb
ÈçºÎ²ÅÄÜÉú³ÉÏÂÃæµÄxml¸ñʽ
XML code:
<folder state="unchecked" label="È«²¿">
¡¡¡¡ <folder state="unchecked&qu ......

pl/sql - Oracle / ¿ª·¢

СµÜ£¬×î½üҪתÐÐÈ¥×öoracle¿ª·¢ÁË£¬ÓÉÓÚ´óѧ±Ïҵʱ£¬×ßÁ˸öÍä·£¬ÏÖÔÚºÜСÐÄ£¬ÎÊÏ£¬×öPL/SQLÓÐûÓÐǰ;£¿£¿£¿
µ±È»ÎÒ˵µÄÕâ¸öǰ;ÊÇÖ¸ ÒÔºóÒªÌø²Û£¬Êг¡¶ÔÕâÑùµÄÈ˲ŵÄÐèÇóÁ¿´ó²»´ó£¿£¿

3q ÄÇ¿´À´»¹Ö»ÄÜÏȽӴ ......

Ò»¸öpl/sqlÎÊÌâ - Oracle / ¿ª·¢

ÎÒÊÇÔÚtoadÖÐÊäÈë϶Îsql
  declare
  TYPE test_rec IS record(
  code varchar(10),
  name varchar(30)
  );
  v_book test_rec;
    ......

sqlÓÅ»¯ - Oracle / »ù´¡ºÍ¹ÜÀí

select count(1) from FX_RETURNBOOKCHECKLIST fxreturnbo0_ where fxreturnbo0_.BOOKID='164 ' AND fxreturnbo0_.RETURNID='00025.S0000001' 
ÉÏÃæÒ»¸ö¼òµ¥µÄSQL,Ö´ÐÐʱ¼ä2.6à ......

ÈçºÎʹÓÃMySQL - MS-SQL Server / »ù´¡Àà

¸Õ¸Õ½Ó´¥MySQL,²»ÖªµÀ¸ÃÈçºÎÈ¥²é¿´Êý¾Ý£¬²åÈëÊý¾Ý£¬´´½¨Êý¾Ý¿â¡¢±í£¬ÓÃÄÄΪǰ±²ÄÜÖ¸½ÌÒ»¶þ£¿

MySQL 5.1²Î¿¼ÊÖ²á

ÒýÓÃ
ÐÖµÜÄã»á½áÌùÂð£¿
mysql ²Î¿¼ÊÖ²á

baidu

MySQL¹Ù·½Îĵµ http://dev.mysql.com/doc ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ