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 ServerµÄÄ£°åÀ´Ð´¹æ·¶µÄSQLÓï¾äÁË£º
SQL³õѧÕß¡£
¾³£Íü¼Ç³£ÓõÄDML»òÊÇDDL SQL Óï¾ä¡£
ÔÚ¶àÈË¿ª·¢Î¬»¤µÄSQLÖУ¬Ã¿¸öÈ˶¼ÓÐ×Ô¼ºµÄSQLϰ¹ß£¬Ã»ÓÐÒ»Ì×ͳһµÄ¹æ·¶¡£
ÔÚSQL Server Management StudioÖУ¬ÒѾ¸ø´ó¼ÒÌṩÁ˺ܶೣÓõÄÏÖ³ÉSQL¹æ·¶Ä£°å¡£
SQL Server Management ......
CURSOR
==================================
l SQL ÓαêCURSORµÄʹÓÃ
ʹÓÃÆðÀ´ºÜ¼òµ¥£¬Ïȶ¨Ò壬Ȼºó¸³¸öÖµ£¬´ò¿ª£¬Í¨¹ýWhile Loop Ò»¸öÒ»¸ö¶ÁÏÂÈ¥£¬×îºó¹Ø±Õ£¬ÊÍ·ÅÄÚ´æ¡£»ù±¾Ì×·ÈçÏ£º
DECLARE MyCursor cursor /* ÉùÃ÷Óα꣬ĬÈÏΪµ¥´¿ÏòǰµÄÓαꡣÈç¹ûÏëҪǰºóÌøÀ´ÌøÈ¥µÄ£¬Ð´³ÉScroll Cursor¼ ......
Ö±½Órestore»ò¸½¼ÓÓ¦¸ÃÊDz»ÐеÄ, Óýű¾+µ¼Êý¾Ý¿Ï¶¨Ã»ÓÐÎÊÌâ¡£
2005תµ½2000µÄ²½Öè
1. Éú³Éfor 2000°æ±¾µÄÊý¾Ý¿â½Å±¾
2005 µÄmanger studio
-- ´ò¿ª"¶ÔÏó×ÊÔ´¹ÜÀíÆ÷"(ûÓеϰ°´F8), Á¬½Óµ½ÄãµÄʵÀý
-- ÓÒ¼üҪתµ½2000µÄ¿â
-- ÈÎÎñ
-- Éú³É½Å±¾
-- ÔÚ"½Å±¾Ïòµ¼"µÄ"Ñ¡ÔñÊý¾Ý¿â"ÖÐ, ......
//È¡³öÔ´Êý¾Ý
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=' ......