Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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·½Ê½´ò¿ªÎļþ¡£
   


Ïà¹ØÎĵµ£º

ʹÓÃSQLServerÄ£°åÀ´Ð´¹æ·¶µÄSQLÓï¾ä

Èç¹ûÄã¾­³£Óöµ½ÏÂÃæµÄÎÊÌ⣬Äã¾ÍÒª¿¼ÂÇʹÓÃSQL ServerµÄÄ£°åÀ´Ð´¹æ·¶µÄSQLÓï¾äÁË£º
SQL³õѧÕß¡£
¾­³£Íü¼Ç³£ÓõÄDML»òÊÇDDL SQL Óï¾ä¡£
ÔÚ¶àÈË¿ª·¢Î¬»¤µÄSQLÖУ¬Ã¿¸öÈ˶¼ÓÐ×Ô¼ºµÄSQLϰ¹ß£¬Ã»ÓÐÒ»Ì×ͳһµÄ¹æ·¶¡£
ÔÚSQL Server Management StudioÖУ¬ÒѾ­¸ø´ó¼ÒÌṩÁ˺ܶೣÓõÄÏÖ³ÉSQL¹æ·¶Ä£°å¡£
SQL Server Management ......

SQLÊý¾Ý¿â

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

SQL 2005ת»»³É2000 (SQL Server)


Ö±½Órestore»ò¸½¼ÓÓ¦¸ÃÊDz»ÐеÄ, Óýű¾+µ¼Êý¾Ý¿Ï¶¨Ã»ÓÐÎÊÌâ¡£
2005תµ½2000µÄ²½Öè
1. Éú³Éfor 2000°æ±¾µÄÊý¾Ý¿â½Å±¾
2005 µÄmanger studio
-- ´ò¿ª"¶ÔÏó×ÊÔ´¹ÜÀíÆ÷"(ûÓеϰ°´F8), Á¬½Óµ½ÄãµÄʵÀý
-- ÓÒ¼üҪתµ½2000µÄ¿â
-- ÈÎÎñ
-- Éú³É½Å±¾
-- ÔÚ"½Å±¾Ïòµ¼"µÄ"Ñ¡ÔñÊý¾Ý¿â"ÖÐ, ......

sqlÖг£Óö¯Ì¬µÄÐÐתÁÐ

//È¡³öÔ´Êý¾Ý
select groupname,totalnum,inputdate,groupid into #temp from
 (select count(*)as totalnum,p.groupid,g.groupname,convert(nvarchar(10),inputdate,120) as 'inputdate'
 from person p left join admin_group g on p.groupid = g.groupid and deleteflag = '0'
 where p.inactive=' ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ