Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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 ·Ö²¼Ê½ÊÂÎñ¹ÜÀí

   µ±Êý¾Ý·þÎñÆ÷ºÍWeb·þÎñÆ÷²¿ÊðÔÚ²»Í¬µÄ·þÎñÆ÷ÉÏʱ£¬»áÓõ½·Ö²¼Ê½ÊÂÎñ£¬ÐèÒª¶ÔÁ½¸ö·þÎñÆ÷µÄMSDTC½øÐÐÅäÖá£
    ´ò¿ª“¹ÜÀí¹¤¾ß¨D¨D×é¼þ·þÎñ”£¬ÒÔ´Ë´ò¿ª“×é¼þ·þÎñ¨D¨D¼ÆËã»ú”£¬ÔÚ“ÎҵĵçÄÔ”Éϵã»÷ÓÒ¼ü¡£ÔÚMSDTCÑ¡ÏÖУ¬µã»÷“°²È«ÅäÖÔ°´Å¥¡£ ......

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

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

MSSQLÌí¼Ó×Ö¶Î˵Ã÷

--×Ö¶ÎÌí¼Ó˵Ã÷
EXEC sp_addextendedproperty 'MS_Description', 'ÒªÌí¼ÓµÄ˵Ã÷', 'user', dbo, 'table', ±íÃû, 'column', ÁÐÃû
--ɾ³ý×Ö¶Î˵Ã÷
EXEC sp_dropextendedproperty 'MS_Description', 'user', dbo, 'table', ±íÃû, 'column', ×Ö¶ÎÃû
--²é¿´×Ö¶Î˵Ã÷
SELECT
    [Table Name] = i_s.TAB ......

.batÆô¶¯Êý¾Ý¿â·þÎñ(MSSQL,Oracle)

 @echo off
:dosmenu
REM Ñ¡Ôñ²Ëµ¥
echo  Windows ·þÎñÆô¶¯»ò¹Ø±Õ By hope 2008Äê2ÔÂ7ÈÕ     
echo.
echo [1]Æô¶¯Sql Server2005   [2]¹Ø±ÕSql Server2005
echo [3]Æô¶¯Oracle9i         [4]¹Ø±ÕOracle9i
echo.
echo  ......

php µ÷ÓÃmssql´æ´¢¹ý³ÌʵÀýÓ¦ÓÃ

php½Ì³Ì µ÷ÓÃmssql´æ´¢¹ý³ÌʵÀýÓ¦ÓÃ
ÓÃmssql_initÓï¾äÓÃÓÚ³õʼ»¯´æ´¢¹ý³Ì£¬¶øºóµ÷ÓÃmssql_bindÓï¾äÖ¸¶¨´æ´¢¹ý³Ì²ÎÊý£¬×îºóµ÷ÓÃmssql_executeÖ´Ðд洢¹ý³Ì¡£
*/
//Á¬½ÓmssqlÊý¾Ý¿â½Ì³Ì·þÎñÆ÷
 $link = mssql_connect("127.0.0.1", "sa", "sa") or die("Can't connect sql server");
    mssql_sele ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ