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

SQL, sql server 2000 ,±í¼äÊý¾Ý ,¼¶Áª¸üÐÂɾ³ý

Èç¹û£¬ÏÖÔÚÓÐÁ½ÕűíA(id,xx.xx...),C(id,Cid,xx,xx...)£¬Ô¤ÊµÏÖCÖеÄidÓëA ÖÐid¼¶ÁªÉ¾³ý¡¢¼¶Áª¸üÐÂ/Êý¾Ýͬ²½£¬¿ÉÓÐÁ½ÖÖʵÏÖ·½Ê½£º
Ò».
ÀûÓÃsql server×Ô´øµÄ¼¶ÁªÉ¾³ý¡¢¼¶Áª¸üй¦ÄÜ£¬¼´ÆäÍâ¼üÔ¼ÊøÍ¾¾¶
 
 
alter table dbo.C
add constraint FK_C_A_AID
foreign key(AID) references dbo.A(AID)
on delete cascade
on update casade
go
 
 
alter table dbo.C
add constraint FK_C_B_BID
foreign key(BID) references dbo.B(BID)
on delete cascade
on update casade
go
 
 
 
 
 
¼¶Áª¸üкͼ¶ÁªÉ¾³ý·½Ê½£º
Alter TABLE [dbo].[T_USERGROUP] ADD
        CONSTRAINT [FK_T_USERGROUP_T_ACCTTEMPLATE] FOREIGN KEY
        (
                [ATNAME]
        ) REFERENCES [dbo].[T_ACCTTEMPLATE] (
                [ATNAME]
        ) ON Update CASCADE ON Delete CASCADE
 
 
¶þ¡¢ÁíÍ⣬ÎÒÃÇÒ²ÍêÈ«¿ÉÒÔ×ÔÒÑдһ¸ö´¥·¢Æ÷À´ÊµÏִ˹¦ÄÜ
 
    
    
     A:
 
     int id
     varchar(20) name
    
     C:
     int id
     int Cid
     varchar(100) info
 
     ¼ÙÉè±íA¡¢CµÄ×Ö¶ÎÈçÉÏ£º
 
     ÈçÒÔ¼¶ÁªÉ¾³ý±íA¡¢C¼Ç¼ΪÀý£¬ÊµÏÖÓï¾äÈçÏ£º
     (Èç¹ûɾ³ý±íAÖеļǼ£¬Ôò×Ô¶¯É¾³ý±íCÖÐÓë±íAÖÐidÏàͬµÄ¼Ç¼)
 
    CREATE   TRIGGER trg_a
ON A
FOR INSERT,UPDATE,DELETE
AS
BEGIN
              DECLARE @nInsRows   INT   --ÓÃÓÚ²åÈë¼Ç¼ÌõÊýͳ¼Æ
    &n


Ïà¹ØÎĵµ£º

д³ö¸ßÐÔÄÜSQLÓï¾äµÄ35Ìõ·½·¨·ÖÎö

¡¡¡¡(1)ÕûºÏ¼òµ¥,ÎÞ¹ØÁªµÄÊý¾Ý¿â·ÃÎÊ£º
¡¡¡¡Èç¹ûÄãÓм¸¸ö¼òµ¥µÄÊý¾Ý¿â²éѯÓï¾ä,Äã¿ÉÒÔ°ÑËüÃÇÕûºÏµ½Ò»¸ö²éѯÖÐ(¼´Ê¹ËüÃÇÖ®¼äûÓйØÏµ)
¡¡¡¡(2)ɾ³ýÖØ¸´¼Ç¼£º
¡¡¡¡×î¸ßЧµÄɾ³ýÖØ¸´¼Ç¼·½·¨ ( ÒòΪʹÓÃÁËROWID)Àý×Ó£º
¡¡¡¡DELETE from EMP E WHERE E.ROWID > (SELECT MIN(X. ......

SQL SERVERÐÔÄÜÓÅ»¯×ÛÊö

SQL SERVERÐÔÄÜÓÅ»¯×ÛÊö
--Ô­Öø:Haiwer
 
½üÆÚÒò¹¤×÷ÐèÒª£¬Ï£Íû±È½ÏÈ«ÃæµÄ×ܽáÏÂSQL SERVERÊý¾Ý¿âÐÔÄÜÓÅ»¯Ïà¹ØµÄ×¢ÒâÊÂÏÔÚÍøÉÏËÑË÷ÁËÒ»ÏÂ,·¢ÏֺܶàÎÄÕÂ,ÓеͼÁгöÁËÉϰÙÌõ,µ«ÊÇ×Ðϸ¿´·¢ÏÖ£¬ÓкܶàËÆÊǶø·Ç»òÕß¹ýʱ(¿ÉÄܶÔSQL SERVER6.5ÒÔǰµÄ°æ±¾»òÕßORACLEÊÇÊÊÓõÄ)µÄÐÅÏ¢£¬Ö»ºÃ×Ô¼º¸ù¾ÝÒÔǰµÄ¾­ÑéºÍ²âÊÔ½á¹û½ ......

Oracle PL/SQLÖÐÈçºÎʹÓÃ%TYPEºÍ%ROWTYPE

¡¡
¡¡¡¡1. ʹÓÃ%TYPE
¡¡¡¡ÔÚÐí¶àÇé¿öÏ£¬PL/SQL±äÁ¿¿ÉÒÔÓÃÀ´´æ´¢ÔÚÊý¾Ý¿â±íÖеÄÊý¾Ý¡£ÔÚÕâÖÖÇé¿öÏ£¬±äÁ¿Ó¦¸ÃÓµÓÐÓë±íÁÐÏàͬµÄÀàÐÍ¡£ÀýÈ磬students±íµÄfirst_nameÁеÄÀàÐÍΪVARCHAR2(20),ÎÒÃÇ¿ÉÒÔ°´ÕÕÏÂÊö·½Ê½ÉùÃ÷Ò»¸ö±äÁ¿£º
¡¡¡¡DECLARE
¡¡¡¡ v_FirstName VARCHAR2(20);
¡¡
¡¡µ«ÊÇÈç¹ûfirst_nameÁе͍Òå¸Ä±äÁ ......

mysql+phpÎÞ·¨Á¬½Ósql£¨Òѽâ¾ö£©

¸ãÁ˺ܾᣡ£ÖÕÓÚ·¢ÏÖÔ­À´ÊÇȨÏÞÎÊÌâ¡£¡£
2ÐÐÃüÁî¸ã¶¨
grant all privileges on rogue.* to admin@localhost identified by 'admin' with grant option
grant all privileges on rogue.* to admin@'%' identified by 'admin' with grant option
¾­µäÁË¡£¡£¡£
ħÁ¦Ë½·þÍøÒ³¶Ë¸ã¶¨¿©~~ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ