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

MSSQL ÓαêʹÓÃ

 ×ªÔØ http://www.jb51.net/article/17875.htm
      MS-SQLÓαêµÄʹÓü°Àí½â windows»òDOSµÄ“¹â±ê”²»Í¬£¬MS-SQLµÄÓαêÊÇÒ»ÖÖÁÙʱµÄÊý¾Ý¿â¶ÔÏ󣬼ȶԿÉÓÃÀ´Ðýת´¢´æÔÚϵͳÓÀ¾Ã±íÖеÄÊý¾ÝÐеĸ±±¾£¬Ò²¿ÉÒÔÖ¸Ïò´¢´æÔÚϵͳÓÀ¾Ã±íÖеÄÊý¾ÝÐÐ
ÓαêΪÄúÌṩÁËÔÚÖðÐеĻù´¡É϶ø²»ÊÇÒ»´Î´¦ÀíÕû¸ö½á¹û¼¯Îª»ù´¡µÄ²Ù×÷±íÖÐÊý¾ÝµÄ·½·¨¡£
1£®ÈçºÎʹÓÃÓαê
1£©¶¨ÒåÓαêÓï¾ä Declare <ÓαêÃû> Cursor For
2£©´´½¨ÓαêÓï¾ä Open <ÓαêÃû>
3£©ÌáÈ¡ÓαêÁÐÖµ¡¢Òƶ¯¼Ç¼ָÕë Fetch <ÁÐÃûÁбí> from <ÓαêÃû> [Into <±äÁ¿Áбí>]
4£©Ê¹ÓÃ@@Fetch_StatusÀûÓÃWhileÑ­»·´¦ÀíÓαêÖеÄÐÐ
5£©É¾³ýÓα겢ÊÍ·ÅÓï¾ä Close <ÓαêÃû>/Deallocate <ÓαêÃû>
6£©ÓαêÓ¦ÓÃʵÀý
--¶¨ÒåÓαê
Declare cur_Depart Cursor
For Select cDeptID,cDeptName from Department into @DeptID,@DeptName
--´´½¨Óαê
Open cur_Depart
--Òƶ¯»òÌáÈ¡ÁÐÖµ
Fetch from cur_Depart into @DeptID,@DeptName
--ÀûÓÃÑ­»·´¦ÀíÓαêÖеÄÁÐÖµ
While @@Fetch_Status=0
Begin
Print @DeptID,@DeptName
Fetch from cur_Depart into @DeptID,@DeptName
End
--¹Ø±Õ/ÊÍ·ÅÓαê
Close cur_Depart
Deallocate cur_Depart
2£®Óï¾äµÄÏêϸ¼°×¢Òâ
1£©¶¨ÒåÓαêÓï¾ä
Declare <ÓαêÃû> [Insensitive] [Scroll] Cursor
For <Select Óï¾ä> [FOR {Read Only | Update [ OF <ÁÐÃûÁбí>]}]
Insensitive DBMS´´½¨²éѯ½á¹û¼¯Êý¾ÝµÄÁÙʱ¸±±¾£¨¶ø²»ÊÇʹÓÃÖ±½ÓÒýÓÃÊý¾Ý¿â±íÖеÄÕæʵÊý¾ÝÐÐÖеÄÁУ©¡£ÓαêÊÇRead Only£¬Ò²¾ÍÊÇ˵²»ÄÜÐÞ¸ÄÆäÄÚÈÝ»òµ×²ã±íµÄÄÚÈÝ£»
Scroll Ö¸¶¨ÓαêÖ§³Öͨ¹ýʹÓÃÈÎÒâFetch Ñ¡ÏFirst Last Prior Next Relative Absolute£©Ñ¡È¡ËüµÄÈÎÒâÐÐ×÷Ϊµ±Ç°ÐС£Èç¹û´ËÏîÊ¡ÂÔ£¬ÔòÓα꽫ֻ֧³ÖÏòÏÂÒƶ¯µ¥ÐУ¨¼´Ö»Ö§³ÖÓαêµÄFetch Next£©£»
SelectÓï¾ä ¶¨ÒåÓαê½á¹û¼¯µÄ±ê×¼ SELECT Óï¾ä¡£ÔÚÓαêÉùÃ÷µÄ <SelectÓï¾ä>ÄÚ²»ÔÊÐíʹÓùؼü×Ö COMPUTE¡¢COMPUTE BY¡¢FOR BROWSE ºÍ INTO£»
Read Only ·ÀֹʹÓÃÓαêµÄÓû§Í¨¹ý¸üÐÂÊý¾Ý»òɾ³ýÐиıäÓαêµÄÄÚÈÝ£»
Update ´´½¨¿É¸üÐÂÓαêÇÒÁгöÖµÄܱ»¸üеÄÓαêÁС£Èç¹û×Ó¾äÖÐÁÐÈëÁËÈÎÒâÁУ¬ÔòÖ»Óб»ÁÐÈëµÄÁвÅÄܱ»¸üС£Èç¹ûDeclare CursorÓï¾äÖÐÖ»Ö¸¶¨µÄUPDATE£¨Ã»ÓÐÁÐÃûÁÐ±í£©£¬ÔòÓα꽫ÔÊÐí¸üÐÂËüµÄÈκλòË


Ïà¹ØÎĵµ£º

MSSQLµÄ¶à²ãǶÌײéѯ

½ñÌìÔÚÁÄÌìϵͳÖÐÐèҪϵͳִÐÐÒ»¸ö¶à²ãǶÌײéѯ¡£
Ò»¿ªÊ¼Óï¾äÈçÏÂ×ܳöÏÖ´íÎó£ºÔ­À´ÊÇÔÚ]='123') ºóÎÒ¶à¼ÓÁËÒ»¸ö as tb1
¸ÄΪÈçϺó£¬ÕýÈ·ÔËÐС£
select * from ( select top(10)  * from ( select top(100)  * from (select  [chatcontent].[senderid],[chatcontent].[id] ,[chatcontent].[toid] ,[chatc ......

MsSQL,MySQL,Oracle,Êý¾Ý¿âÁ¬½Ó×Ö¶Î

Ms sql 2000
drivername=com.microsoft.jdbc.sqlserver.SQLServerDriver
url=jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=books
username=sa
password=sa
MySQL
drivername=com.mysql.jdbc.Driver
url=jdbc:mysql://localhost/books
username=root
password=root
Oracle
drivername=orac ......

MSSQLÊý¾ÝÀàÐͼ°³¤¶ÈÏÞÖÆÏêϸ˵Ã÷

SQL Server ÌṩϵͳÊý¾ÝÀàÐͼ¯£¬¶¨ÒåÁË¿ÉÓë SQL Server Ò»ÆðʹÓõÄËùÓÐÊý¾ÝÀàÐÍ¡£ÏÂÃæÁгöϵͳÌṩµÄÊý¾ÝÀàÐͼ¯¡£
¿ÉÒÔ¶¨ÒåÓû§¶¨ÒåµÄÊý¾ÝÀàÐÍ£¬ÆäÊÇϵͳÌṩµÄÊý¾ÝÀàÐ͵ıðÃû¡£ÓйØÓû§¶¨ÒåµÄÊý¾ÝÀàÐ͵ĸü¶àÐÅÏ¢£¬Çë²Î¼û sp_addtype ºÍ´´½¨Óû§¶¨ÒåµÄÊý¾ÝÀàÐÍ¡£
µ±Á½¸ö¾ßÓв»Í¬Êý¾ÝÀàÐÍ¡¢ÅÅÐò¹æÔò¡¢¾«¶È¡¢Ð¡ÊýλÊý»ò³ ......

²âÊÔMSSQLÖÐSQLÓï¾äÖ´Ðл¨·ÑµÄʱ¼ä

selectÓï¾äÇ°¼Ó£º
declare @d datetime
set @d=getdate()
²¢ÔÚselectÓï¾äºó¼Ó£º
select [Óï¾äÖ´Ðл¨·Ñʱ¼ä(ºÁÃë)]=datediff(ms,@d,getdate())
ת×Ô£º¶¯Ì¬ÍøÖÆ×÷Ö¸ÄÏ www.knowsky.com
ÕâÊǼòÒ׵IJ鿴ִÐÐʱ¼äµÄ·½·¨¡£
===========================================£¨Ò»ÏÂÄÚÈÝת×Ô£º£Ã£Ó£Ä£Î£©
MSSQL ServerÖÐͨ¹ý²é ......

MSSQLÊý¾Ý¿â±¸·Ý

1
¡¢
MSSQL
Êý¾Ý¿âµÄ¶¨ÆÚ×Ô¶¯±¸·Ý¼Æ»®
 
ͨ¹ýÆóÒµ¹ÜÀíÆ÷
ÉèÖÃÊý¾Ý¿âµÄ¶¨ÆÚ×Ô¶¯±¸·Ý¼Æ»®¡£
1
¡¢´ò¿ªÆóÒµ¹Ü
ÀíÆ÷£¬Ë«»÷´ò¿ªÄãµÄ·þÎñÆ÷
2
¡¢È»ºóµãÉÏÃæ
²Ëµ¥ÖеŤ¾ß
-->
Ñ¡ÔñÊý¾Ý¿âά»¤¼Æ»®Æ÷
3
¡¢ÏÂÒ»²½Ñ¡ÔñÒª½øÐÐ×Ô¶¯±¸·ÝµÄÊý¾Ý
-->
ÏÂÒ»²½¸üÐÂÊý¾ÝÓÅ»¯ÐÅÏ¢£¬ÕâÀïÒ»°ã²»ÓÃ×öÑ¡Ôñ
-->
ÏÂÒ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ