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

ѧϰ


Ïà¹ØÎÊ´ð£º

jsp jdbcÁ¬½Ósqlserver 2000 ³öÏÖÎÊÌâ

´úÂ룺

try{
    Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver"); 
con= DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost: ......

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

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

Çó½Ì ²é¿´SqlServerÖ´ÐйýµÄ´æ´¢¹ý³Ì״̬

ÔÚSqlServerÖÐÈçºÎ²é¿´ÀúÊ·ÉÏÖ´ÐеĴ洢¹ý³ÌµÄÐÅÏ¢ÄØ£¬È磺´«Èë²ÎÊý£¬Ö´ÐÐʱ¼äµÈµÈ¡£Èç¹û²»Äܲ鿴ÀúÊ·¼Ç¼£¬ÊÇ·ñ¿ÉÒÔ×Ô¼ºÐ´´¥·¢Æ÷Ö®ÀàµÄ£¬È˹¤¿ØÖÆÄØ£¬ÔÚOracleÀïÃæÓж¯Ì¬ÊÓͼ¿ÉÒÔËæÊ±²é¿´ÀúÊ·Ö´ÐеÄsqlÓï¾ä£¬SqlSer ......

sqlserver 1433¶Ë¿ÚµÄÎÊÌâ(ÕûÁËÒ»ÌìÎÞ¹û,¶¥Ò²ÓзÖ)

xp(sp3)ϵͳ°²×°ÁËsqlserver2000£¬sp3£¬sp4²¹¶¡¶¼´òÁË¡£¶øÇÒ±¾»úÒ²ÄÜÁ¬½Ó·ÃÎÊ¡£
ÎÊÌâÊÇ£º
±¾»útelnet ip 1433 ×ÜÊÇÌáʾÁ¬½Óʧ°Ü£¬
¶øÇÒnetstat -naʱ£¬¿´²»µ½1433¶Ë¿Ú±»Õ¼ÓÃ
(¿Ï¶¨µÄÊÇ£º¶Ë¿ÚÊÇ1433£¬¿ªÆ ......

vfpÈçºÎ¶ÁÈ¡SQLServer×Ö¶ÎÖеÄͼƬ£¿

ÔõôÔÚvfpµÄ±íµ¥ÖÐÏÔÏÖ´ÓsqlserverÖÐ×¥¹ýÀ´µÄͼƬ£¿

ÎÒÓõÄÊÇvfp6.0

Ìý˵¿ÉÒÔµ÷ÓÃÆäËûÓïÑÔдµÄdllÀ´ÊµÏÖ£¬
ÎÒ¿ÉÒÔÓÃdelphiдdll³öÀ´£¬
µ«ÊÇÎÒ²»»áÓÃʹÓÃvfpÀ´µ÷ÓÃdll°¡

Õâ¶Î´úÂëÊÇ´ÓSQLSEREVR¡¡I ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ