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

SqlServer ÓαêÀý×Ó

 
Declare @Id int
Declare @Name varchar(20)
Declare Cur Cursor For Select Id,Name from T_User  
Open Cur
Fetch next from Cur Into @Id,@Name
While @@fetch_status=0    
Begin
    Update T_User Set [Name]=@Name,Id=@Id
    Fetch Next from Cur Into @Id,@Name
End  
Close Cur   
Deallocate Cur


Ïà¹ØÎĵµ£º

SQLServerÊý¾Ý¿âά¶È±íºÍÊÂʵ±í¸ÅÊö

¡¡¡¡ÊÂʵ±í
¡¡¡¡Ã¿¸öÊý¾Ý²Ö¿â¶¼°üº¬Ò»¸ö»òÕ߶à¸öÊÂʵÊý¾Ý±í¡£ÊÂʵÊý¾Ý±í¿ÉÄÜ°üº¬ÒµÎñÏúÊÛÊý¾Ý£¬ÈçÏÖ½ðµÇ¼ÇÊÂÎñ
¡¡¡¡Ëù²úÉúµÄÊý¾Ý£¬ÊÂʵÊý¾Ý±íͨ³£°üº¬´óÁ¿µÄÐС£ÊÂʵÊý¾Ý±íµÄÖ÷ÒªÌصãÊÇ°üº¬Êý×ÖÊý¾Ý(ÊÂʵ)£¬²¢ÇÒÕâЩÊý×ÖÐÅÏ¢¿ÉÒÔ»ã×Ü£¬ÒÔÌṩÓйص¥Î»×÷ΪÀúÊ·µÄÊý¾Ý£¬Ã¿¸öÊÂʵÊý¾Ý±í°üº¬Ò»¸öÓɶà¸ö²¿·Ö×é³ÉµÄË÷Òý£¬¸ÃË÷Òý ......

SqlServer ʵÏÖÈÕÆÚ²»Í¬¸ñʽµÄת»»£¡£¡

select
convert(char(4),auth,120)+'Äê'+
substring(convert(char(10),auth,120),6,2)+'ÔÂ'+
substring(convert(char(10),auth,120),9,2)+'ÈÕ',
convert(char(4),appr,120)+'Äê'+
substring(convert(char(10),appr,120),6,2)+'ÔÂ'+
substring(convert(char(10),appr,120),9,2)+'ÈÕ'
from a

ÒÔÉÏ´úÂëʵÏֵĹ¦Ä ......

¶ÁÈ¡sqlserverͼƬimageÊý¾ÝÉú³ÉͼƬÎļþ

//test.java
import java.io.BufferedOutputStream;
import java.io.DataOutputStream;
import java.io.FileOutputStream;
import java.io.IOException;
import java.io.InputStream;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
imp ......

sqlserver»ñÈ¡µÚnÐÐÊý¾Ý

ÈçºÎÔÚÒ»¸öûÓÐÖ÷¼üµÄ±íÖлñÈ¡µÚnÐÐÊý¾Ý£¬ÔÚsql2005ÖпÉÒÔÓÃrow_number£¬µ«ÊDZØÐëÖ¸¶¨ÅÅÐòÁУ¬·ñÔòÄã¾Í²»µÃ²»ÓÃselect intoÀ´¹ý¶Éµ½ÁÙʱ±í²¢Ôö¼ÓÒ»¸öÅÅÐò×ֶΡ£
ÓÃÓαêµÄfetch  absoluteÓï¾ä¿ÉÒÔ»ñÈ¡¾ø¶ÔÐÐÊýϵÄijÐÐÊý¾Ý,²âÊÔ´úÂëÈçÏÂ:
set nocount on
--½¨Á¢²âÊÔ»·¾³²¢²åÈëÊý¾Ý£¬²¢ÇÒ±íûÓÐÖ÷¼ü
create table t ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ