Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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 ¹Ø¼ü×Ö´´½¨µÄ¡£

ѧϰ


Ïà¹ØÎÊ´ð£º

ÔÚ64λϵͳÉÏÓÃCÓïÑÔ²Ù×÷sqlserverÊý¾Ý¿âµÄÎÊÌâ

дÁËÒ»¸öÓÃCÓïÑÔ²Ù×÷sqlserverÊý¾Ý¿âµÄ³ÌÐò£¬ÔÚÎÒ×Ô¼ºµÄ¼ÆËã»úÉÏÔËÐÐûÎÊÌâ¡£µ«µ½Áíһ̨»úÆ÷ÉÏÔËÐÐʱ£¬SQLConnectº¯ÊýÁ¬½ÓÊý¾Ý¿âʧ°Ü£¬×Ðϸ¼ì²éÉèÖö¼Ã»Óз¢ÏÖÎÊÌ⣬µ«¸Ã»úÆ÷µÄ²Ù×÷ϵͳÊÇWindows Server 2003 Enterp ......

sqlserver count,order by ²éѯÂý

±íÖÐÊý¾Ý 700ÍòÌõ×óÓÒ£¬29¸ö×ֶΣ¬×Ô¶¯Ôö³¤ÁÐÉèΪÖ÷¼ü£¬ ʹÓÃcount£¨1£© ²éѯ×ÜÌõÊýÐèÒª1·ÖÖÓ£¬
select top 1000 ×Ö¶ÎÃû  from ±í order by ʱ¼ä(¸Ã×Ö¶ÎÓÐÖØ¸´ÖµºÍnullÖµ)  ÕâÑùµÄÓï¾ä²éѯ¸üÊÇÂýµÃ»ù± ......

ÓÃsqlserver 2000 agent µ÷ÓôòÓ¡»úÎÊÌâ

ÓÃsqlserver 2000 agent Éú³ÉÒ»¸öjob£¬¸ÄjobÀïÃæÓе÷ÓÃÒ»¸öÓ¦ÓóÌÐò£¬¸ÃÓ¦ÓóÌÐò»áÈ¥µ÷´òÓ¡»ú´òÓ¡
µ¥¶ÀÅÜÕâ¸öÓ¦ÓóÌÐòµ÷´òÓ¡»úÊÇÕýÈ·µÄ£¬    È»ºóÓÃsqlserver 2005ÀïµÄagentÈ¥µ÷Ò²ÊÇ¿ÉÒÔÕý³£´òÓ¡µÄ¡£¡£ ......

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

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

SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO


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

  ......

jdbcÓëSQLserverÁ¬½Ó

package com.tongying.www.until;

public class Resource {
// MySQlÊý¾Ý¿âµÄ×ÊÔ´
/* public static final String DRIVER="com.mysql.jdbc.Driver";
public static final String URL=&qu ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ