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
Ïà¹ØÎĵµ£º
-- To allow advanced options to be changed.
EXEC sp_configure 'show advanced options', 1
GO
-- To update the currently configured value for advanced options.
RECONFIGURE
GO
-- To enable the feature.
EXEC sp_configure 'CLR', 0
GO
-- To update the currently configured value for this feature.
......
¡¡¡¡(1)ÕûºÏ¼òµ¥,ÎÞ¹ØÁªµÄÊý¾Ý¿â·ÃÎÊ£º
¡¡¡¡Èç¹ûÄãÓм¸¸ö¼òµ¥µÄÊý¾Ý¿â²éѯÓï¾ä,Äã¿ÉÒÔ°ÑËüÃÇÕûºÏµ½Ò»¸ö²éѯÖÐ(¼´Ê¹ËüÃÇÖ®¼äûÓйØÏµ)
¡¡¡¡(2)ɾ³ýÖØ¸´¼Ç¼£º
¡¡¡¡×î¸ßЧµÄɾ³ýÖØ¸´¼Ç¼·½·¨ ( ÒòΪʹÓÃÁËROWID)Àý×Ó£º
¡¡¡¡DELETE from EMP E WHERE E.ROWID > (SELECT MIN(X. ......
ÏÂÎçÏòÊý¾Ý¿âSQL SERVERÖÐÓöµ½Ìí¼ÓͼƬÀàÐÍÊý¾ÝµÄÎÊÌ⣬±¾ÒÔΪÔÚ½çÃæ¹ÜÀíÆ÷ÖпÉÒÔÖ±½Ó£¨Í¨¹ýÖ¸¶¨Â·¾¶°ÑͼƬµÄÊý¾Ý±£´æÆðÀ´£©Ìí¼ÓͼƬȴ²»È»¡£ÍøÉÏËÑÁËÏÂÕÒµ½ÁËÏà¹ØµÄ½ÏרҵµÄ×ÊÁÏ£¬ÕûºÏ½â¶Áһϣº Á½ÖÖ·½·¨£º µÚÒ»¾ÍÊÇÔÚÊý¾Ý¿âÖд洢ͼƬµÄ·¾¶£¬È»ºóÔÚ³ÌÐòÖиù¾Ý¶ÁÈ¡µÄ·¾¶¶ÁȡͼƬ£»ÕâÖ ......
ACCESSÊý¾Ý¿â
1:CodeSmithÑ¡ÖÐÁ´½ÓÀàÐÍÊÇ£ºADOXSchema
2:ÎÞÃÜÂëµÄAccessÁ´½ÓΪ£º
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\hh\db.mdb;
3:ÓÐÃÜÂëµÄAccessÁ´½Ó£º
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\hh\db.mdb;
Jet OLEDB:Database Password=1111
SqlÊý¾Ý¿â
server=192.1.1.14;User ID=test; ......
ʲôÊÇ´æ´¢¹ý³ÌÄØ£¿
¡¡¡¡¶¨Ò壺
¡¡¡¡½«³£ÓõĻòºÜ¸´ÔӵŤ×÷£¬Ô¤ÏÈÓÃSQLÓï¾äдºÃ²¢ÓÃÒ»¸öÖ¸¶¨µÄÃû³Æ´æ´¢ÆðÀ´, ÄÇôÒÔºóÒª½ÐÊý¾Ý¿âÌṩÓëÒѶ¨ÒåºÃµÄ´æ´¢¹ý³ÌµÄ¹¦ÄÜÏàͬµÄ·þÎñʱ,Ö»Ðèµ÷ÓÃexecute,¼´¿É×Ô¶¯Íê³ÉÃüÁî¡£
¡¡¡¡½²µ½ÕâÀï,¿ÉÄÜÓÐÈËÒªÎÊ£ºÕâô˵´æ´¢¹ý³Ì¾ÍÊÇÒ»¶ÑSQLÓï¾ä¶øÒѰ¡£¿
¡¡¡¡Microsoft¹«Ë¾ÎªÊ²Ã´»¹ÒªÌí¼ÓÕ ......