SQL SERVER200´íÎó´¦Àí ·þÎñÆ÷
´íÎó´¦Àí
ÔÚSQL Server2000ÖгöÏֵĴíÎó¾ßÓÐÒÔϼ¸¸öÌص㣺
´íÎóºÅ£ºÃ¿¸ö´íÎó״̬¶¼¶ÔӦΨһµÄ´íÎóºÅ¡£
´íÎóÐÅÏ¢×Ö·û´®£º´íÎóÐÅÏ¢ÌṩÁËÓйشíÎóÔÒòµÄÕï¶ÏÐÅÏ¢¡£Ðí¶à´íÎóÐÅÏ¢¶¼ÓÐÌæ»»±äÁ¿£¬ÆäÖаüº¬Ò»Ð©ÐÅÏ¢£¬Èç²úÉú´íÎóµÄ¶ÔÏóÃû³Æ¡£Ã¿¸ö´íÎóºÅ¶¼¶ÔӦΨһµÄ´íÎóÐÅÏ¢¡£
ÑÏÖضȣºÑÏÖضȱíʾ´íÎóµÄÑÏÖس̶ȡ£ÑÏÖضȽϵ͵ĴíÎó£¬Èç1¼¶»ò2¼¶£¬ÎªÐÅÏ¢ÐÔÏûÏ¢»òµÍ¼¶¾¯¸æ¡£ÑÏÖضȽϸߵĴíÎó±íÃ÷ÎÊÌâÐèÒª¾¡¿ì½â¾ö¡£
״̬´úÂ룺һЩ´íÎó´úÂë¿ÉÄÜÔÚSQL ServerÔ´´úÂëÖжദ³öÏÖ¡£È磬¼¸ÖÖ²»Í¬Çé¿ö϶¼¿ÉÄÜ·¢Éú1105´íÎó¡£³öÏÖ´íÎó´úÂëµÄÿһ´¦¶¼Ö¸ÅÉÁËΨһµÄ״̬´úÂë¡£¿ÉÒÔʹÓôíÎóµÄ״̬´úÂëÔÚÔ´´úÂëÖвéÕÒ´íÎó´úÂëµÄλÖã¬Õâ¿ÉÒÔΪÎÊÌâµÄÕï¶ÏÌṩ²Î¿¼¡£
¹ý³ÌÃû£ºÈç¹ûÔÚ´æ´¢¹ý³ÌÖз¢Éú´íÎó£¬Ôò¸Ã´æ´¢¹ý³ÌµÄÃû³ÆÒ²Ðí¿ÉÓá£
ÐкţºÐкÅÖ¸³ö´æ´¢¹ý³ÌÖвúÉú´íÎóµÄÓï¾ä¡£
ϵͳµÄËùÓдíÎ󶼴洢ÔÚϵͳ±ímaster.dbo.sysmessagesÖС£Óû§¶¨ÒåµÄÏûÏ¢Ò²¿ÉÒÔ´æ´¢ÔÚ´Ëϵͳ±íÖС£Èç¹ûÐèÒª£¬¿ÉÒÔʹÓÃRAISERRORÓï¾ä½«ÕâЩÓû§¶¨ÒåµÄ´íÎ󷵻ص½Ò»¸öÓ¦ÓóÌÐò¡£
ËùÓеÄÊý¾Ý¿âAPI£¬ÈçADO¡¢OLE DB¡¢ODBC¡¢DB-LibraryºÍǶÈëʽSQL£¬¾ù±¨¸æ»ù±¾µÄ´íÎóÊôÐÔ£º´íÎóºÅºÍÏûÏ¢×Ö·û´®¡£È»¶ø£¬Ã¿¸öÊý¾Ý¿âËùÄܱ¨¸æµÄÆäËû´íÎóÌØÐÔµÄÊýÁ¿ÊDz»Í¬µÄ¡£
a.ʹÓÃ@@ERRORÈ«¾Ö±äÁ¿´¦Àí´íÎó
@@ERRORÈ«¾Ö±äÁ¿·µ»Ø×îºóÖ´ÐеÄT-SQLÓï¾äµÄ´íÎó´úÂë¡£µ±SQL ServerÍê³ÉT-SQLÓï¾äµÄÖ´ÐÐʱ£¬Èç¹ûÓï¾äÖ´Ðгɹ¦£¬Ôò@@ERRORÉèÖÃΪ0¡£Èô³öÏÖÒ»¸ö´íÎó£¬Ôò·µ»ØÒ»Ìõ´íÎóÐÅÏ¢¡£@@ERROR·µ»Ø´Ë´íÎóÐÅÏ¢´úÂ룬ֱµ½ÁíÒ»ÌõT-SQLÓï¾ä±»Ö´ÐС£
ÓÉÓÚ@@ERRORÔÚÿһÌõÓï¾äÖ´Ðкó±»Çå³ý²¢ÇÒÖØÖã¬ËùÒÔÓ¦ÔÚÓï¾äÑéÖ¤ºóÁ¢¼´¼ì²éËü£¬»ò½«Æä±£´æµ½Ò»¸ö¾Ö²¿±äÁ¿ÖÐÒÔ±¸Êºó²é¿´¡£
ÔÚSQL ServerÖУ¬¿ÉÒÔʹÓÃÏÂÃæÁ½ÖÖ·½·¨¶Ô@@ERROR½øÐд¦Àí£º
ÔÚT-SQLÓï¾äºó£¬ÂíÉϼì²â»òʹÓÃ@@ERROR
ÔÚT-SQLÓï¾äÍê³Éºó£¬ÂíÉÏ°Ñ@@ERROR´æ´¢µ½Ò»¸öÕûÐαäÁ¿ÖÐ
Àý£º
USE bookdb
GO
SELECT * from book
GO
IF @@ERROR=0
PRINT 'Ö´Ðгɹ¦£¡'
ELSE
PRINT '²éѯ³ö´í£¡'
GO
Ö´ÐÐÉÏÃæÓï¾ä£¬ÔòÔÚ"ÍøÂç"´°¿ÚÖÐÏÔʾ²éѯ½á¹û£¬¶øÔÚ"ÏûÏ¢"´°¿ÚÖÐÏÔʾ"Ö´Ðгɹ¦"µÄ×ÖÑù¡£
b.ʹÓÃRAISERROR
ÔÚÉÏÃæµÄ²Ù×÷ÖУ¬Ê¹ÓÃPRINT¿ÉÒÔÏÔʾһЩÌáʾÐÅÏ¢¡£ÓëPRINTÏà±È£¬RAISERRORÔÚ°ÑÏûÏ¢·µ»Ø¸øÓ¦ÓóÌÐò·½ÃæµÄ¹¦ÄܸüÇ¿´ó¡£RAISERRORÄÜÒÔÏÂÁз½Ê½ÖеÄÈÎÒâÒ»ÖÖ·µ»ØÏûÏ¢£º
ÒÑͨ¹ýsp_addmessageϵͳ´æ´¢
Ïà¹ØÎĵµ£º
1£©²»Öª´ó¼ÒÊÇ·ñϲ»¶Ê¹ÓÑNOT IN’ÕâÑùµÄ²Ù×÷£¬Èç¹ûÊÇ£¬ÄǾ¡Á¿Ê¹ÓÃ(NOT) EXISTS Ìæ´ú
2£©ÔÚº£Á¿²éѯʱ¾¡Á¿ÉÙÓøñʽת»»¡£
3£©²éѯº£Á¿Êý¾ÝÊÇ£¬¿ÉÒÔʹÓÃoptimizer['ɔptimaizə] hints£¬ÀýÈç/*+ORDERED */
¾¡Á¿ÉÙÓÃIN²Ù×÷·û£¬»ù±¾ÉÏËùÓеÄIN²Ù×÷·û¶¼¿ÉÒÔÓÃEXISTS´úÌæ¡£
²»ÓÃNOT IN²Ù×÷·û£¬¿ÉÒÔ ......
select upper(name) from syscolumns
where id =any
(
select Id from sysobjects where name='tb_city'
)
lower
select row_number() over(order by firmid) from dbo.tb_BuildingMaterial
Éú³É ×ÔÔö 123
select rank() over(order by firmid) from dbo.tb_BuildingMaterial
Éú³É×ÔÔö123 ¸ù¾ÝÅ ......
1. ³ÌÐòÈçÏ£º
string str = "Create Database " + "DBname";
string con = "Data Source=10.0.0.249\\sql2005;Initial Catalog=master;Persist Security Info=True;User ID=sa;Password=sa";
&n ......
JavaÊý¾ÝÀàÐÍ
HibernateÊý¾ÝÀàÐÍ
±ê×¼SQLÊý¾ÝÀàÐÍ
(PS:¶ÔÓÚ²»Í¬µÄDB¿ÉÄÜÓÐËù²îÒì)
byte¡¢java.lang.Byte
byte
TINYINT
short¡¢java.lang.Short
short
SMALLINT
int¡¢java.lang.Integer
integer
INGEGER
long¡¢java.lang.Long
long
BIGINT
float¡¢java.lang.Float
float
FLOAT
double¡¢java.lang.Doubl ......