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.Çó1..10żÊýÖ®ºÍ
select sum(level) from dual
where mod(level,2)=0
connect by level
2.½«update¸Ä»»³ÉÓÃrowidÀ´ÊµÏÖ¡£
£¨1£©ÐµÄд·¨£º
merge into SNAPSHOT120_2010_572 t1
using (select a.rowid rid, b.vip_level, b.manager_name
from xyf_vip_info_new b, snapsho ......
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.×Ö·û´®º¯Êý
³¤¶ÈÓë·ÖÎöÓÃ
datalength(Char_expr) ·µ»Ø×Ö·û´®°üº¬×Ö·ûÊý,µ«²»°üº¬ºóÃæµÄ¿Õ¸ñ
substring(expression,start,length) ²»¶à˵ÁË,È¡×Ó´®
right(char_expr,int_expr) ·µ»Ø×Ö·û´®ÓÒ±ßint_expr¸ö×Ö·û
×Ö·û²Ù×÷Àà
upper(char_expr) תΪ´óÐ ......
²»Åç¿ÚË®!Ö±½ÓÉÏͼ
1.Êý¾Ý¿â¶ÔÏó¼ìË÷¹¦ÄÜ
2.T-SQLÓï·¨°ïÖú
3.³£Óú¯Êý°ïÖú(²»¶®ÄñÓï?13×Ô¼ºÁ·Á·°É!)
Download Now
°²×°Á÷³Ì:
1.ÏÈ°ÑÍøÂçßDzæÁË(¶ÏÍø - -!!)
2.°ÑËùÓеÄSQL Server,VS¶¼¹ØÁË,ÔËÐÐSQLPrompt 4.0.exe°²×°
3.°²×°Íê±Ïºó,Í˳öRedGate.SQLPrompt.TrayApp ......