declare @re int
declare @filename varchar(10)
set @filename='x:\备份文件名'
exec master..xp_fileexist @filename,@re out
if @re=1
begin
print @filename+'已经存在'
exec master..xp_cmdshell 'del @filename'
end
...全文
1453打赏收藏
系统存储过程返回值如何得到??我怎么老不成功呢??
declare @re int declare @filename varchar(10) set @filename='x:\备份文件名' exec master..xp_fileexist @filename,@re out if @re=1 begin print @filename+'已经存在' exec master..xp_cmdshell 'del @filename' end
declare @filename varchar(10)
set @filename='x:\备份文件名'
exec @re=master..xp_fileexist @filename,@re out
print @re
if @re=1
begin
print @filename+'已经存在'
exec ('master..xp_cmdshell''del '+@filename+''',no_output')
end
declare @re int
declare @filename varchar(10)
set @filename='x:\备份文件名'
exec master..xp_fileexist @filename,@re out
print @re
if @re=1
begin
print @filename+'已经存在'
exec ('master..xp_cmdshell''del '+@filename+''',no_output')
end
楼主,你的方法是正确的,我测试过的。
declare @re int
declare @filename varchar(10)
set @filename='c:\cmd.txt'
exec master..xp_fileexist @filename,@re out
print @re
if @re=1
begin
print @filename+'已经存在'
exec master..xp_cmdshell 'del @filename'
end