·¢²¼Ê±¼ä : ÐÇÆÚÒ» ÎÄÕÂÊý¾Ý¿â ʵÑé9 Êý¾Ý¿ØÖÆ(ÍêÕûÐÔ)¸üÐÂÍê±Ï¿ªÊ¼ÔĶÁ6e67a66131b765ce0508148b
£¨3£© Á·Ï°²åÈëÎ¥·´U2Ô¼ÊøµÄÀý×Ó£¬U2¹æ¶¨Ôª×éµÄsageÊôÐÔµÄÖµ±ØÐë<=28¡£ INSERT WORKERS
VALUES('1','NAMEUSE1','M',29,'IM') GO SELECT * FROM WORKERS
£¨4£©È¥³ýU2Ô¼Êø¡£ alter table workers drop u2
£¨5£©ÖØвåÈ루3£©ÖÐÏëÒª²åÈëµÄÊý¾Ý£¬¹Û²ì½á¹û£¬·ÖÎöÔÒò¡£ INSERT WORKERS
VALUES('1','NAMEUSE1','M',29,'IM') GO SELECT * FROM WORKERS
£¨6£©´´½¨¹æÔòrule_sex£¬¹æ¶¨²åÈë»ò¸üеÄÖµÖ»ÄÜÊÇM»òF£¬²¢°ó¶¨µ½workerµÄsex×ֶΡ£
CREATE RULE RULE_SEX AS @VALUE IN ('F','M') GO
EXEC SP_BINDRULE RULE_SEX, 'WORKERS.[SEX]';
£¨7£©Á·Ï°Î¥·´¹æÔòrule_sexµÄ²åÈë²Ù×÷¡£ INSERT WORKERS
VALUES(¡®1¡¯,¡¯NAMEUSER2¡¯,¡¯W¡¯,18,¡¯IM¡¯)
£¨8£©¼ÓÈëÔ¼ÊøU3£¬ÁîsageµÄÖµ>=0¡£
ALTER TABLE Workers ADD CONSTRAINT U3 CHECK (Sage>=0)
£¨9£©¼ÓÈë¹æÔòR2£¬È·±£²åÈëµÄ¼Ç¼µÄsageÖµÔÚ1µ½100Ö®¼ä£¬²¢°ó¶¨µ½sageÊôÐÔÉÏ¡£
Create rule R2 AS @SAGE BEWTEEN 1 AND 100 GO
SP_BINDRULE R2,¡¯WORKERS.[SAGE]¡¯