SQL Server 2000ÖеĴ¥·¢Æ÷ʹÓÃ
¿ÉÒÔ¶¨ÒåÒ»¸öÎÞÂÛºÎʱÓÃINSERTÓï¾äÏò±íÖвåÈëÊý¾Ýʱ¶¼»áÖ´ÐеĴ¥·¢Æ÷¡£
¡¡¡¡µ±´¥·¢INSERT´¥·¢Æ÷ʱ£¬ÐµÄÊý¾ÝÐоͻᱻ²åÈëµ½´¥·¢Æ÷±íºÍinserted±íÖС£inserted±íÊÇÒ»¸öÂß¼±í£¬Ëü°üº¬ÁËÒѾ²åÈëµÄÊý¾ÝÐеÄÒ»¸ö¸±±¾¡£inserted±í°üº¬ÁËINSERTÓï¾äÖÐÒѼǼµÄ²åÈ붯×÷¡£inserted±í»¹ÔÊÐíÒýÓÃÓɳõʼ»¯INSERTÓï¾ä¶ø²úÉúµÄÈÕÖ¾Êý¾Ý¡£´¥·¢Æ÷ͨ¹ý¼ì²éinserted±íÀ´È·¶¨ÊÇ·ñÖ´Ðд¥·¢Æ÷¶¯×÷»òÈçºÎÖ´ÐÐËü¡£inserted±íÖеÄÐÐ×ÜÊÇ´¥·¢Æ÷±íÖÐÒ»Ðлò¶àÐеĸ±±¾¡£
¡¡¡¡ÈÕÖ¾¼Ç¼ÁËËùÓÐÐÞ¸ÄÊý¾ÝµÄ¶¯×÷(INSERT¡¢UPDATEºÍDELETEÓï¾ä)£¬µ«ÔÚÊÂÎñÈÕÖ¾ÖеÄÐÅÏ¢ÊDz»¿É¶ÁµÄ¡£È»¶ø£¬inserted±íÔÊÐíÄãÒýÓÃÓÉINSERTÓï¾äÒýÆðµÄÈÕÖ¾±ä»¯£¬ÕâÑù¾Í¿ÉÒÔ½«²åÈëÊý¾ÝÓë·¢ÉúµÄ±ä»¯½øÐбȽϣ¬À´ÑéÖ¤ËüÃÇ»ò²ÉÈ¡½øÒ»²½µÄ¶¯×÷¡£Ò²¿ÉÒÔÖ±½ÓÒýÓòåÈëµÄÊý¾Ý£¬¶ø²»±Ø½«ËüÃÇ´æ´¢µ½±äÁ¿ÖС£
¡¡¡¡Ê¾Àý
¡¡¡¡ÔÚ±¾ÀýÖУ¬½«´´½¨Ò»¸ö´¥·¢Æ÷¡£ÎÞÂÛºÎʱ¶©¹º²úÆ·£¨ÎÞÂÛºÎʱÏòOrder Details±íÖвåÈëÒ»Ìõ¼Ç¼£©£¬Õâ¸ö´¥·¢Æ÷¶¼½«¸üÐÂProducts±íÖеÄÒ»ÁÐ(UnitsInStock)¡£ÓÃÔÀ´µÄÖµ¼õÈ¥¶©¹ºµÄÊýÁ¿Öµ¼´ÎªÐÂÖµ¡£
USE Northwind
CREATE TRIGGER OrdDet_Insert
ON [Order Details]
FOR INSERT
AS
UPDATE P SET
UnitsInStock = P.UnitsInStock – I.Quantity
from Products AS P INNER JOIN Inserted AS I
ON P.ProductID = I.ProductID
DELETE´¥·¢Æ÷µÄ¹¤×÷¹ý³Ì
¡¡¡¡µ±´¥·¢DELETE´¥·¢Æ÷ºó£¬´ÓÊÜÓ°ÏìµÄ±íÖÐɾ³ýµÄÐн«±»·ÅÖõ½Ò»¸öÌØÊâµÄdeleted±íÖС£deleted±íÊÇÒ»¸öÂß¼±í£¬Ëü±£ÁôÒѱ»É¾³ýÊý¾ÝÐеÄÒ»¸ö¸±±¾¡£deleted±í»¹ÔÊÐíÒýÓÃÓɳõʼ»¯DELETEÓï¾ä²úÉúµÄÈÕÖ¾Êý¾Ý¡£
¡¡¡¡Ê¹ÓÃDELETE´¥·¢Æ÷ʱ£¬ÐèÒª¿¼ÂÇÒÔϵÄÊÂÏîºÍÔÔò£º
¡¡¡¡·µ±Ä³Ðб»Ìí¼Óµ½deleted±íÖÐʱ£¬Ëü¾Í²»ÔÙ´æÔÚÓÚÊý¾Ý¿â±íÖУ»Òò´Ë£¬deleted±íºÍÊý¾Ý¿â±íûÓÐÏàͬµÄÐС£
¡¡¡¡·´´½¨deleted±íʱ£¬¿Õ¼äÊÇ´ÓÄÚ´æÖзÖÅäµÄ¡£deleted±í×ÜÊDZ»´æ´¢ÔÚ¸ßËÙ»º´æÖС£
¡¡¡¡·ÎªDELETE¶¯×÷¶¨ÒåµÄ´¥·¢Æ÷²¢²»Ö´ÐÐTRUNCATE TABLEÓï¾ä£¬ÔÒòÔÚÓÚÈÕÖ¾²»¼Ç¼TRUNCATE TABLEÓï¾ä¡£
¡¡¡¡Ê¾Àý
¡¡¡¡ÔÚ±¾ÀýÖУ¬½«´´½¨Ò»¸ö´¥·¢Æ÷£¬ÎÞÂÛºÎʱɾ³ýÒ»¸ö²úÆ·Àà±ð£¨¼´´ÓCategories±íÖÐɾ³ýÒ»Ìõ¼Ç¼£©£¬¸Ã´¥·¢Æ÷¶¼»á¸üÐÂProducts±íÖеÄDiscontinuedÁС£ËùÓÐÊÜÓ°ÏìµÄ²úÆ·¶¼±ê¼ÇΪ1£¬±êʾ²»ÔÙʹÓÃÕâЩ²úÆ·ÁË¡£
USE Northwind
Ïà¹ØÎĵµ£º
SQLÊý¾Ý¿âÖÐÓÃimageÀ´´æ´¢Îļþ,µ«SQLûÓÐÌṩֱ½ÓµÄ´æÈ¡ÎļþµÄÃüÁî.
/*--bcp ʵÏÖ¶þ½øÖÆÎļþµÄµ¼Èëµ¼³ö
Ö§³Öimage,text,ntext×ֶεĵ¼Èë/µ¼³ö
imageÊʺÏÓÚ¶þ½øÖÆÎļþ,°üÀ¨:WordÎĵµ,ExcelÎĵµ,ͼƬ,ÒôÀÖµÈ
text,ntextÊʺÏÓÚÎı¾Êý¾ÝÎļþ
×¢Òâ:µ¼Èëʱ,½«¸²¸ÇÂú×ãÌõ¼þµÄËùÓÐÐÐ
µ¼³öʱ,½ ......
簡體數據庫轉·±體數據庫µÄ問題 °ÝÍÐÁË
ALTER DATABASE DatabaseName SET SINGLE_USER WITH ROLLBACK IMMEDIATE
ALTER DATABASE DatabaseName COLLATE Chinese_Taiwan_Stroke_CI_AS
ALTER DATABASE DatabaseName SET MULTI_USER WITH ROLLBACK ......
ÔÚ2005ÖÐÓÐͬÒå´ÊÓë¸´ÖÆµÄ¸ÅÄî
ͬÒå´ÊµÄÖ÷Òª×÷ÓÃÊÇ£º
Ò»£ºË޶̶ÔÏóµÄÃû³Æ£¬¼õÉÙ¹¤×÷ÈËÔ±ÊéдµÄʱ¼ä£¬Ìá¸ßЧÂÊ¡£ÎÒÃÇÖªµÀ·ÃÎÊÊý¾Ý¿âÒ»¸ö¶ÔÏóµÄͨ³£×îÈ«µÄ¶ÔÏóÃû³ÆÊÇ£º·þÎñÆ÷Ãû³Æ¡£Êý¾Ý¿âÃû³Æ¡£¼Ü¹¹Ãû³Æ¡£¶ÔÏóÃû³Æ
¶þ£ºÍ¬²½Êý¾Ý¡£ ......
4£®Êý¾ÝÀàÐÍת»»º¯Êý
¡ñÒþʽת»»
¸³ÖµÊ±¿É½øÐеÄÒþʽת»»ÓÐ
VARCHAR2»òCHAR —¡µNUMBER
VARCHAR2»òCHAR —¡µDATE
NUMBER —¡µVARCHAR ......