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

SQLÊÂÎñ´¦ÀíÓï¾ä×ܽá

 
´æ´¢¹ý³ÌÖг£Óõ½µÄSQLÊÂÎñ´¦ÀíÓï¾ä¸ñʽ¿ÉÄÜ»áÓÐÈçϼ¸ÖÖ:
µÚÒ»ÖÖ:
set   xact_abort   on 
begin   tran 
        insert   ... 
        update   ... 
        delete   ... 
commit   tran
µÚ¶þÖÖ:
set   xact_abort   on 
begin   tran 
        insert   ... 
        if @@error<>0 rollback tran
        update   ... 
        if @@error<>0 rollback tran
        delete   ... 
        if @@error<>0 rollback tran
commit   tran
µÚÈýÖÖ:
set   xact_abort   on 
begin   tran 
        insert   ... 
        update   ... 
        delete   ... 
if @@error<>0 
rollback  tran
else
commit   tran
µÚËÄÖÖ:
set   xact_abort   on 
begin   tran 
declare @ErrorSave int
        insert   ... 
        if @@error<>0  set  @ErrorSave=1
        update   ...  
      if @@error<>0  set  @ErrorSave=1
        delete   ... 
      if @@error<>0  set  @ErrorSave=1
if @ErrorSave>0 
rollback  tran
else
commit   tran
ʹÓÃÊÂÎñµÄȱÏÝ:ʹÓöàÁËÊÂÎñ´¦Àí,¾­³£»á²úÉúËÀËøÏÖÏó,ÌØ±ð


Ïà¹ØÎĵµ£º

sql 2005 ´æ´¢¹ý³Ì·ÖÒ³ java ´úÂë

 create PROCEDURE pagelist
@tablename nvarchar(50),
@fieldname nvarchar(50)='*',         
@pagesize int output,--ÿҳÏÔʾ¼Ç¼ÌõÊý
@currentpage int output,--µÚ¼¸Ò³
@orderid nvarchar(50),--Ö÷¼üÅÅÐò
@sort int,--ÅÅÐò·½Ê½£¬1±íʾÉýÐò£¬0±íʾ½µÐòÅÅÁÐ ......

SQLÓï¾ä²éѯÊý¾Ý¿âÖÐÖØ¸´¼Ç¼µÄ¸öÊý

Ò»¸ösqlÓï¾ä£ºÒ»¸ö±ítestÓÐËĸö×Ö¶Îid,a,b,c,Èç¹û±íÖеļǼÓÐÈý¸ö×Ö¶Îa,b,c¶¼ÏàµÈ£¬Ôò˵Ã÷ÕâÌõ¼Ç¼ÊÇÏàͬµÄ£¬ÇóÏàͬµÄ¼Ç¼µÄ¸öÊý ¡£
select a,b,c,count(*) from (select c.a,c.b,c.c from test c) having count(*) >= 2 group by a,b,c
»òÕß
select zdbh,tdzl,zdmj,count(*) from ecaadmin.zdsx group by zdbh ......

SQLÓïÑÔµÄCASEʹÓÃ×ܽá

 ×ª×Ôhttp://lavasoft.blog.51cto.com/62575/23373
SQLÓïÑÔµÄCASEÓï¾ä±¸Íü
 
¸ÅÊö£º
SQLÓï¾äÖеÄCASEÓï¾äÓë¸ß¼¶ÓïÑÔÖеÄswitchÓï¾ä£¬ÊDZê×¼SQLµÄÓï·¨£¬ÊÊÓÃÓëÒ»¸öÌõ¼þÅжÏÓжàÖÖÖµµÄÇé¿öÏ·ֱðÖ´Ðв»Í¬µÄ²Ù×÷¡£Áé»îÓ¦ÓÃCASEÓï¾ä¿ÉÒÔʹSQLÓï¾ä±äµÃ¼ò½àÒ×¶Á£¬ÏÂÃæÔÚDB2»·¾³ÏÂͨ¹ýÒ»¸ö¼òµ¥µÄ²éѯÀ´Õ¹Ê¾SQL CASEÓ ......

¹ÜÀí SQL Server µÄÊÂÎñÈÕÖ¾

ÎÄÕÂÀ´Ô´£ºHttp://www.simple-talk.com
Ô­ÎĵØÖ·£ºhttp://www.simple-talk.com/sql/learn-sql-server/managing-transaction-logs-in-sql-server/
Ô­×÷ÕߣºRobert Sheldon
·­Ò룺Èý½úÒ»Ö¦»¨
ÒëÎÄÔ­µØÖ·£ºhttp://prj.souty.cn/Admin/Knowledges/ShowKnowledge.aspx?id=44dbde74-d2c5-41a5-a8e9-375ba7103025
ÔÚ SQL Serv ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ