sqlserver¡¡µÄ¹æÔòruleÈçºÎÀí½â
sqlserver¡¡µÄ¹æÔòruleÈçºÎÀí½â£¬¡¡ÏÂÃæÊÇÒ»¸öʵÀý£¬Çë½áºÏ¸ÃÀý×Ó½âÊÍ£º
ΪĿ±êÊý¾Ý¿â¹ÜÀíϵͳÉè¼ÆÒµÎñ¹æÔò£º
4.2.1 ¹æÔò£º
Ø rule[Sex]
create rule [Sex] as @ in ('ÄÐ','Å®')
GO
Ø rule[TypeHaveChild]
create rule [TypeHaveChild] as @ in ('y','n')
GO
Ø rule[IsSpecial]
create rule [IsSpecial] as @ in ('y','n')
GO
Ø rule[OrderIsConfirm]
create rule [OrderIsConfirm] as @ in ('y','n')
GO
Ø rule[Actor]
create rule [Actor] as @ in('³¬¼¶¹ÜÀíÔ±','Óû§¹ÜÀíÔ±','ÂÛ̳¹ÜÀíÔ±','·þ×°
¹ÜÀíÔ±','¶©µ¥¹ÜÀíÔ±','¹«¸æ¹ÜÀíÔ±')
GO
Ø rule[OrderSendStatus]
create rule [OrderSendStatus
create rule [Sex] as @ in ('ÄÐ','Å®')
´´½¨Ò»¸ö¹æÔòSEXÖµÊÇÄлòÅ®
DZ¹æÔò
Microsoft SQL Server µÄδÀ´°æ±¾Öн«É¾³ý CREATE RULE¡£Çë±ÜÃâÔÚеĿª·¢¹¤×÷ÖÐʹÓà CREATE RULE£¬²¢¼Æ»®Ð޸ĵ±Ç°Ê¹ÓÃËüµÄÓ¦ÓóÌÐò¡£½¨ÒéÄú¸ÄÓüì²éÔ¼Êø¡£¼ì²éÔ¼ÊøÊÇʹÓà CREATE TABLE »ò ALTER TABLE µÄ CHECK ¹Ø¼ü×Ö´´½¨µÄ¡£
ѧϰ
Ïà¹ØÎÊ´ð£º
ÇëÎÊһϣ¬ÍâÍøÁ½Ì¨SQLSERVERʵÀýÊý¾Ý´«Ê䣬ÓÐûÓвÉÓÃÊý¾ÝѹËõºÍ¼ÓÃÜ¡£Ñ¹Ëõ±ÈÊǶàÉÙ£¬¼ÓÃÜÊÇʲô¼ÓÃÜËã·¨£¿Ïà¹ØÎĵµÄÄÀï¿ÉÒÔÕÒµ½£¿Ð»Ð»
ÎÒÒ²ÏëÖªµÀ£¡¹Ø×¢´ËÌù£¡
¹Ø×¢¡«¡«
Êý¾Ý¿â´óÅ£¶¼ÄÄÈ¥Á˰¡£¿
......
ֻΪ¶úå¦Ä¿È¾£¬ÓÐËù½ø²½£¡
ßµ°Ý£¡
..
ÕâÀï¾ÍÊÇ
ÕâÀï±ÈQQȺÀïÈÈÄÖ
ÎÒÒ²ÏëÕÒÕâô¸öȺ
.
SQL code:
¡£¡£¡£¡£¡£
¡£
ºÇºÇ
ÒýÓÃ
ÕâÀï±ÈQQȺÀïÈÈÄÖ
ͬÒâ
發錯° ......
¸÷λ´óÏÀ£¬sqlserver Êý¾Ý¿âËÀËøºó£¬»á²»»á×Ô¶¯½âËøÄØ£¿¶à³¤Ê±¼äÄÜ×Ô¶¯½âËøÄØ£¿Ð»Ð»£¡
SQL code:
use master
go
create procedure sp_who_lock
as
begin
declare @spid int,@bl int,
@intTransactionCountO ......
´ó¼ÒÓÐûÓÐ ´æ´¢¹ý³Ì·ÖÒ³µÄÀý×Ó£¬¹²Ïíһϣ¬Ð»Ð»£¡£¡£¡
http://wyf.javaeye.com/blog/462396
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
/*--ʵÏÖ·ÖÒ³µÄͨÓô洢¹ý³Ì
......
ÎÒµÄÊý¾Ý¿âÖÐÓÐÒ»¸öÎı¾ºÜ¶àµÄ×Ö¶Înews£¬ÆäÖб»Ä¾ÂíÖ²ÈëºÜ¶à <script src=XXXXX> </script> µÄ×Ö·û¡£¿ªÊ¼ÎÒÒ»Ö±ÓÃupdateÓï¾äÌæ»»£¬µ«ÊǺÜÂé·³£¬Ìæ»»ÁËû¼¸Ìì¾ÍÓÖ±»×¢ÈëÁË¡£
XXX²¿·Öÿ´Î¶¼²»Ò» ......