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

SQL´æ´¢¹ý³Ì²âÊÔ£¨5£©——´ÓT

ÎÊÌâ
      ÈçºÎÈÃT-SQL²âÊÔÌ×¼þ°Ñ²âÊÔÓÃÀý½á¹ûÖ±½ÓдÈëÎı¾Îļþ
Éè¼Æ
      ʹÓÃActiveX¼¼ÊõʵÀý»¯Ò»¸öFileSystemObject¶ÔÏó£¬È»ºóͨ¹ýOpenTextFile()ºÍWriteLine()·½·¨Ö±½Ó°Ñ²âÊÔ½á¹ûдÈëÎļþ¡£
·½°¸
declare @fsoHandle int,@fileID int
exec sp_OACreate 'Scripting.FileSystemObject',@fsoHandle out
exec sp_OAMethod @fsohandle,'OpenTextFile',@fileID out,
    'C:\pathToResults\Results.txt',8,1
——Ö÷²âÊÔÑ­»·
if(@result = @expected)
    exec sp_OAMethod @fileID,'WriteLine',null,'Pass'
else
    exec sp_OAMethod @fileID,'WriteLine',null,'FAIL'
——Ö÷²âÊÔÑ­»·½áÊø
exec sp_OADestroy @fileID
exec sp_OADestroy @fsoHandle
      ÎÒÃÇÐèÒªÓÐÒ»¸öÎļþ¾ä±úºÍÒ»¸öÎļþID£¬ËüÃǵÄÀàÐͶ¼ÊÇInt£¬SQL ServerÓÐÒ»¸ö×÷sp_OACreate()µÄ´æ´¢¹ý³Ì¿ÉÒÔʵÀý»¯ActiveX¶ÔÏó¡£sp_OACreate()½ÓÊÜÒ»¸ö×Ö·û´®×÷Ϊ´«ÈëµÄ²ÎÊý£¬Õâ¸ö×Ö·û´®¾ÍÊÇÒª´´½¨µÄActiveX¶ÔÏóµÄÃû×Ö£¬²¢ÇÒÒÔout²ÎÊýµÄÐÎʽ·µ»ØÒ»¸öÒÑ´´½¨¶ÔÏóµÄÒýÓã¬Õâ¸öÒýÓõÄÀàÐÍÊÇint¡£¶ÔÓÚScripting.FileSystemObjectµÄÇé¿öÀ´Ëµ£¬·µ»ØÖµÊǹØÓÚÎļþ¾ä±úµÄÒ»¸öÒýÓ᣽ÓÏÂÀ´£¬¿ÉÒÔͨ¹ýµ÷ÓÃsp_OAMethod()·½·¨´ò¿ªÎļþ¡£ÔÚ±¾ÀýÖУ¬µÚÒ»¸ö²ÎÊýÊÇsp_OACreate()°Ñ´´½¨µÄ¾ä±ú£¬µÚ¶þ¸ö²ÎÊýÊÇÎÒÃÇÏëҪʹÓõķ½·¨µÄÃû³Æ£¬µÚÈý¸ö²ÎÊýÊÇÓÃÓÚ±£´æ·µ»ØµÄÎļþ¾ä±úµÄ±äÁ¿£¬µÚËĸö²ÎÊýÖ¸¶¨ÎļþµÄÎïÀíÃû³Æ£¬µÚÎå¸ö²ÎÊýÊÇ¿ÉÑ¡µÄ£¬ËüÖ¸¶¨Ê¹ÓõÄIOģʽ¡£
      1£ºÒÔÖ»¶Á·½Ê½´ò¿ªÎļþ£¨Ä¬ÈÏ£©¡£
      2£ºÒÔд·½Ê½´ò¿ªÎļþ¡£
      3£ºÒÔ×·¼Ó·½Ê½´ò¿ªÎļþ
      µÚÁù¸ö²ÎÊýÊÇ¿ÉÑ¡µÄ£¬ËüÊÇÒ»¸ö´´½¨±êʶ£¬ÓÃÀ´Ö¸¶¨µ±¸ø¶¨Îļþ²»´æÔÚµÄʱºòÊÇ·ñ´´½¨Ò»¸öеÄÎļþ¡£
      0£º²»´´½¨ÐÂÎļþ£¨Ä¬ÈÏ£©¡£
      1£º´´½¨Ò»¸öÐÂÎļþ¡£
      µÚ°Ë¸öº¦ÊýÒ²ÊÇ¿ÉÑ¡µÄ£¬ËüÊÇÒ»¸ö¸ñʽ±êʶ£¬ÓÃÀ´Ö¸¶¨×Ö·ûµÄ±àÂ뷽ʽ¡£
      0£ºÒÔASCII·½Ê½´ò¿ªÎļþ£¨Ä¬ÈÏ£©¡£
      1£ºÒÔUnicode·½Ê½´ò¿ªÎļþ¡£
   


Ïà¹ØÎĵµ£º

SQLÊý¾Ý¿â

 CURSOR
==================================
l  SQL ÓαêCURSORµÄʹÓÃ
 
ʹÓÃÆðÀ´ºÜ¼òµ¥£¬Ïȶ¨Ò壬Ȼºó¸³¸öÖµ£¬´ò¿ª£¬Í¨¹ýWhile Loop Ò»¸öÒ»¸ö¶ÁÏÂÈ¥£¬×îºó¹Ø±Õ£¬ÊÍ·ÅÄÚ´æ¡£»ù±¾Ì×·ÈçÏ£º
DECLARE MyCursor cursor /* ÉùÃ÷Óα꣬ĬÈÏΪµ¥´¿ÏòǰµÄÓαꡣÈç¹ûÏëҪǰºóÌøÀ´ÌøÈ¥µÄ£¬Ð´³ÉScroll Cursor¼ ......

SQL ×Ö·û´®Óë16½øÖÆ»¥»»

ÔÚÍøÉÏ¿´µ½SQL×Ö·û´®×ª16½øÖƵÄÓï¾ä£¬¾­¹ýССÌí¼Ó£¬ÏÖ½«SQL×Ö·û´®Óë16½øÖÆ»¥»»µÄ·½·¨¼Ç¼£¬ÒÔ¹©ÒÔºó²é¿´¡£ 
--SQL char->HEX code
DECLARE @str VARCHAR(4000)
SET @str='SELECT * from dbo.TaskHistory' --Your sql char
DECLARE @i INT,@Asi INT,@ModS INT,@res VARCHAR(800),@Len INT,@Cres VARCHAR(4),@te ......

SQL ServerÖÐÔ¼ÊøµÄ½éÉÜ

ÕªÒª
¶ÔÓÚSQL ServerÖеÄÔ¼Êø£¬Ïë±Ø´ó¼Ò²¢²»ÊǺÜİÉú¡£µ«ÊÇÔ¼ÊøÖÐÕæÕýµÄÄÚº­ÊÇʲô£¬²¢²»ÊǺܶàÈ˶¼ºÜÇå³þµÄ¡£±¾ÎÄÒÔÏêϸµÄÎÄ×ÖÀ´½éÉÜÁËʲôÊÇÔ¼Êø£¬ÒÔ¼°ÈçºÎÔÚÊý¾Ý¿â±à³ÌÖÐÓ¦ÓúÍʹÓÃÕâÐ©Ô¼Êø£¬À´´ïµ½¸üºÃµÄ±à³ÌЧ¹û¡££¨±¾ÎIJ¿·ÖÄÚÈݲο¼ÁËSQL ServerÁª»úÊֲᣩ
ÄÚÈÝ
 
Êý¾ÝÍêÕûÐÔ·ÖÀà
 
ʵÌåÍêÕûÐÔ
&nb ......

sql´óÈ«


. SQL ÃüÁî
Õⲿ·Ö°üº¬ÄÇЩ PostgreSQL Ö§³ÖµÄ SQL ÃüÁîµÄÐÅÏ¢£®ÕâÀïµÄ "SQL" ¾ÍÊǸÃÓïÑÔͨ³£µÄº¬Ò壻 ÿÌõÃüÁîµÄÓë±ê×¼ÓйصļæÈÝÐÔµÄÐÅÏ¢¿ÉÒÔÔÚÏà¹ØµÄ²Î¿¼Ò³ÖÐÕÒµ½£®
Table of Contents
ABORT --  Í˳öµ±Ç°ÊÂÎñ
ALTER GROUP --  Ïò×éÖÐÔö¼ÓÓû§»ò´Ó×éÖÐɾ³ýÓû§ 
ALTER USER --  ¸Ä±äÊý¾Ý¿â ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ