如何在sqlserver的定时任务中得到批处理执行后的返回值? 1、写文件2、写表3、发邮件 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 create table tab1 (f1 varchar(512))insert into tab1 exec master.dbo.xp_cmdshell 'd:\\dd.bat'select * from tab1drop table tab1------------------------(所影响的行数为 2342 行)f1 ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- NULLC:\WINNT\system32>dir *.* 驱动器 C 中的卷没有标签。 卷的序列号是 64BF-59E9NULL C:\WINNT\system32 的目录NULL2008-05-04 09:39 <DIR> .2008-05-04 09:39 <DIR> ..2008-02-21 13:47 352 $winnt$.inf1998-04-24 00:00 2,320 12500852.CPX1998-04-24 00:00 2,318 12510866.CPX2004-01-17 11:07 2,151 12520437.cpx2004-01-17 11:07 2,233 12520850.cpx1998-04-24 00:00 2,167 12520860.CPX1998-04-24 00:00 2,162 12520861.CPX1998-04-24 00:00 2,173 12520863.CPX1998-04-24 00:00 2,147 12520865.CPX2008-04-03 11:31 <DIR> 20522000-01-10 20:00 32,016 aaaamon.dll2000-01-10 20:00 67,344 access.cpl2002-08-29 09:25 64,512 acctres.dll2003-06-19 12:05 150,800 accwiz.exe2000-01-10 20:00 61,952 acelpdec.ax2000-01-10 20:00 131,856 acledit.dll2003-06-19 12:05 78,096 aclui.dll2000-01-10 20:00 4,368 acsetupc.dll2000-01-10 20:00 17,168 acsetups.exe2000-01-10 20:00 11,536 acsmib.dll2003-06-19 12:05 268,048 acssnap.dll2000-01-10 20:00 51,200 acssnap.msc2003-06-19 12:05 182,032 activeds.dll2003-06-19 12:05 107,520 activeds.tlb2000-01-10 20:00 26,384 actmovie.exe2002-08-29 09:32 98,816 actxprxy.dll2003-06-19 12:05 15,770,624 adminpak.msi2000-01-10 20:00 39,184 admparse.dll2000-01-10 20:00 32,528 admwprox.dll2000-01-10 20:00 6,928 admxprox.dll1998-05-07 00:00 113 ADODC.SRG1998-07-07 00:00 14,336 ADODCCHS.DLL2000-01-10 20:00 27,408 adptif.dll2005-06-03 22:18 248,080 adsiis.dll2003-06-20 07:44 6,416 adsiisex.dll2005-06-03 22:18 130,832 adsldp.dll2005-06-03 22:18 134,928 adsldpc.dll2005-06-03 22:18 63,760 adsmsext.dll2003-06-19 12:05 164,112 adsnds.dll2003-06-19 12:05 201,488 adsnt.dll2003-06-19 12:05 112,400 adsnw.dll2005-06-03 22:18 401,168 ADVAPI32.DLL2002-08-29 09:32 91,136 advpack.dll2000-01-10 20:00 18,192 alrsvc.dll2005-09-20 00:00 299,008 ALSNDMGR.CPL2008-02-21 13:56 16,832 amcompat.tlb2002-12-12 00:14 64,512 amstream.dll2000-01-10 20:00 9,143 ansi.sys2000-01-10 20:00 107,792 apcups.dll2000-01-10 20:00 12,498 append.exe2003-06-19 12:05 120,592 appmgmts.dll2003-06-19 12:05 224,016 appmgr.dll2003-06-19 12:05 301,328 appwiz.cpl2000-01-10 20:00 19,728 arp.exe2002-08-29 09:32 89,600 asctrls.ocx 那位好心人帮我解决一下吧!非常感谢! 再发“菜鸟求助一条SQL” 简单的查询语句与删除 行转列的SQL 语句,帮忙看一下为什么这样子写 如何在聚合语句中 使用列出所有聚合项的id 如表 数据库文件的逻辑文件名有什么用呀? 字段加1的问题。 小问题 请赐教,那里有关于SQL SERVER2000数据库管理员方面的书籍下载。 关于ORACLE的简单问题,谁能帮我??? 向前辈请教跨数据库修改!!!!!!!!! 请高手赐教!这两句sql的逻辑有什么不同?
create table tab1 (f1 varchar(512))
insert into tab1 exec master.dbo.xp_cmdshell 'd:\\dd.bat'
select * from tab1
drop table tab1------------------------
(所影响的行数为 2342 行)f1
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
NULL
C:\WINNT\system32>dir *.*
驱动器 C 中的卷没有标签。
卷的序列号是 64BF-59E9
NULL
C:\WINNT\system32 的目录
NULL
2008-05-04 09:39 <DIR> .
2008-05-04 09:39 <DIR> ..
2008-02-21 13:47 352 $winnt$.inf
1998-04-24 00:00 2,320 12500852.CPX
1998-04-24 00:00 2,318 12510866.CPX
2004-01-17 11:07 2,151 12520437.cpx
2004-01-17 11:07 2,233 12520850.cpx
1998-04-24 00:00 2,167 12520860.CPX
1998-04-24 00:00 2,162 12520861.CPX
1998-04-24 00:00 2,173 12520863.CPX
1998-04-24 00:00 2,147 12520865.CPX
2008-04-03 11:31 <DIR> 2052
2000-01-10 20:00 32,016 aaaamon.dll
2000-01-10 20:00 67,344 access.cpl
2002-08-29 09:25 64,512 acctres.dll
2003-06-19 12:05 150,800 accwiz.exe
2000-01-10 20:00 61,952 acelpdec.ax
2000-01-10 20:00 131,856 acledit.dll
2003-06-19 12:05 78,096 aclui.dll
2000-01-10 20:00 4,368 acsetupc.dll
2000-01-10 20:00 17,168 acsetups.exe
2000-01-10 20:00 11,536 acsmib.dll
2003-06-19 12:05 268,048 acssnap.dll
2000-01-10 20:00 51,200 acssnap.msc
2003-06-19 12:05 182,032 activeds.dll
2003-06-19 12:05 107,520 activeds.tlb
2000-01-10 20:00 26,384 actmovie.exe
2002-08-29 09:32 98,816 actxprxy.dll
2003-06-19 12:05 15,770,624 adminpak.msi
2000-01-10 20:00 39,184 admparse.dll
2000-01-10 20:00 32,528 admwprox.dll
2000-01-10 20:00 6,928 admxprox.dll
1998-05-07 00:00 113 ADODC.SRG
1998-07-07 00:00 14,336 ADODCCHS.DLL
2000-01-10 20:00 27,408 adptif.dll
2005-06-03 22:18 248,080 adsiis.dll
2003-06-20 07:44 6,416 adsiisex.dll
2005-06-03 22:18 130,832 adsldp.dll
2005-06-03 22:18 134,928 adsldpc.dll
2005-06-03 22:18 63,760 adsmsext.dll
2003-06-19 12:05 164,112 adsnds.dll
2003-06-19 12:05 201,488 adsnt.dll
2003-06-19 12:05 112,400 adsnw.dll
2005-06-03 22:18 401,168 ADVAPI32.DLL
2002-08-29 09:32 91,136 advpack.dll
2000-01-10 20:00 18,192 alrsvc.dll
2005-09-20 00:00 299,008 ALSNDMGR.CPL
2008-02-21 13:56 16,832 amcompat.tlb
2002-12-12 00:14 64,512 amstream.dll
2000-01-10 20:00 9,143 ansi.sys
2000-01-10 20:00 107,792 apcups.dll
2000-01-10 20:00 12,498 append.exe
2003-06-19 12:05 120,592 appmgmts.dll
2003-06-19 12:05 224,016 appmgr.dll
2003-06-19 12:05 301,328 appwiz.cpl
2000-01-10 20:00 19,728 arp.exe
2002-08-29 09:32 89,600 asctrls.ocx