±¾Õ¾ÄÚÈÝËÑË÷£º
   ÄúµÄλÖãºËزÄÖйú>>½Ì³Ì >>Êý¾Ý¿â >>MS SQL >>SQLÑ­Ðò½¥½ø(8)ɾ³ý¼Ç¼ Ìá½»´íÎ󱨸æ
SQLÑ­Ðò½¥½ø(8)ɾ³ý¼Ç¼
[ À´Ô´£ºËزÄÖйú | ×÷Õߣº²É¼¯Ð¡×é| ʱ¼ä£º2006-04-07 15:31:22 | ä¯ÀÀ£ºÈË´Î ]

 
  ɾ³ý¼Ç¼

DeleteÓï¾äÊÇÓÃÀ´´Ó±íÖÐɾ³ý¼Ç¼»òÕßÐУ¬ÆäÓï¾ä¸ñʽΪ£º

delete from "tablename"

where "columnname" OPERATOR "value" [and
 
 
       
   ÄúµÄλÖãºËزÄÖйú>>½Ì³Ì >>Êý¾Ý¿â >>MS SQL >>SQLÑ­Ðò½¥½ø(8)ɾ³ý¼Ç¼
 µã´ËÔÚ°Ù¶ÈËÑË÷¹Ø¼ü×Ö"SQLÑ­Ðò½¥½ø(8)ɾ³ý¼Ç¼"  µã´ËÔÚGOOGLEËÑË÷¹Ø¼ü×Ö"SQLÑ­Ðò½¥½ø(8)ɾ³ý¼Ç¼"
ÈÈÃÅÎÄÕ£º
  ¡¤¶þ½øÖÆ×ªÊ®½øÖƵÄSQLº¯Êý   ¡¤SQL2005 SSIS
  ¡¤¶ÔÊý¾Ý¿â×Ö¶ÎʹÓÃĬÈÏÖµ   ¡¤exp/impµ¼³öµ¼È빤¾ßµÄʹÓÃ
  ¡¤¾­³£Óõ½µÄ½»²æ±íÎÊÌâ,Ò»°ãÓö¯Ì¬SQLÄÜÉú³É¶¯Ì¬ÁÐ   ¡¤¾«»ªÈ«Ãæ½Ó´¥SQLÓï·¨
  ¡¤ÔÚ´æ´¢¹ý³ÌÖÐÁ¬½ÓÔ¶³ÌÊý¾Ý¿â²¢½øÐвÙ×÷   ¡¤SqlServerµÄ¸üÐÂËø(UPDLOCK)
  ¡¤¼¸ÖÖ·ÖÒ³Ëã·¨¡£·­Ò³±Ø±¸   ¡¤¹ØÓÚSQL Server SQLÓï¾ä²éѯ·ÖÒ³Êý¾ÝµÄ½â¾ö·½°¸

  Ê×Ò³  ËزÄͼƬ  ¸ß¾«Í¼¿â  Ê¸Á¿Í¼¿â  ÍøÒ³ËزĠ ÍøÒ³Ä£°å  ±ÚÖ½  Ã÷ÐÇ  ÏÂÔØ  ½Ì³Ì  ×ÖÌå  Ïã³µÃÀÅ®  QQרÌâ  ÂÛ̳

ÍøÕ¾½éÉÜ | ¹ã¸æÒµÎñ | Éè¼ÆÒµÎñ | ÃâÔðÉùÃ÷ | °æÈ¨ÉùÃ÷ | ÁªÏµÎÒÃÇ|Ìá½»´íÎ󱨸æ
ËØ²ÄÖйú°æÈ¨ËùÓÐ