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

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µ×²ãÎÊÌâ - MS-SQL Server / ÒÉÄÑÎÊÌâ

ÇëÎÊһϣ¬ÍâÍøÁ½Ì¨SQLSERVERʵÀýÊý¾Ý´«Ê䣬ÓÐûÓвÉÓÃÊý¾ÝѹËõºÍ¼ÓÃÜ¡£Ñ¹Ëõ±ÈÊǶàÉÙ£¬¼ÓÃÜÊÇʲô¼ÓÃÜËã·¨£¿Ïà¹ØÎĵµÄÄÀï¿ÉÒÔÕÒµ½£¿Ð»Ð»


ÎÒÒ²ÏëÖªµÀ£¡¹Ø×¢´ËÌù£¡

¹Ø×¢¡«¡«

Êý¾Ý¿â´óÅ£¶¼ÄÄÈ¥Á˰¡£¿
......

ÇóÒ»»îÔ¾µÄsqlserverµÄqqȺ

ֻΪ¶úå¦Ä¿È¾£¬ÓÐËù½ø²½£¡
ßµ°Ý£¡
..

ÕâÀï¾ÍÊÇ

ÕâÀï±ÈQQȺÀïÈÈÄÖ

ÎÒÒ²ÏëÕÒÕâô¸öȺ

.

SQL code:
¡£¡£¡£¡£¡£

¡£

ºÇºÇ

ÒýÓÃ
ÕâÀï±ÈQQȺÀïÈÈÄÖ


ͬÒâ

發錯° ......

sqlserver Êý¾Ý¿âËÀËøºó¶à³¤Ê±¼ä½âËø£¿

¸÷λ´óÏÀ£¬sqlserver Êý¾Ý¿âËÀËøºó£¬»á²»»á×Ô¶¯½âËøÄØ£¿¶à³¤Ê±¼äÄÜ×Ô¶¯½âËøÄØ£¿Ð»Ð»£¡
SQL code:
use master
go
create procedure sp_who_lock
as
begin
declare @spid int,@bl int,
@intTransactionCountO ......

sqlserverÖУ¬Óô洢¹ý³Ì·ÖÒ³

´ó¼ÒÓÐûÓÐ ´æ´¢¹ý³Ì·ÖÒ³µÄÀý×Ó£¬¹²Ïíһϣ¬Ð»Ð»£¡£¡£¡
http://wyf.javaeye.com/blog/462396

SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO


/*--ʵÏÖ·ÖÒ³µÄͨÓô洢¹ý³Ì

  ......

sqlserverÖеÄÌæ»»ÎÊÌâ

ÎÒµÄÊý¾Ý¿âÖÐÓÐÒ»¸öÎı¾ºÜ¶àµÄ×Ö¶Înews£¬ÆäÖб»Ä¾ÂíÖ²ÈëºÜ¶à <script src=XXXXX> </script>  µÄ×Ö·û¡£¿ªÊ¼ÎÒÒ»Ö±ÓÃupdateÓï¾äÌæ»»£¬µ«ÊǺÜÂé·³£¬Ìæ»»ÁËû¼¸Ìì¾ÍÓÖ±»×¢ÈëÁË¡£
XXX²¿·Öÿ´Î¶¼²»Ò» ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ