Declare @wenjianjia varchar(20)
Declare @wenjianjia1 Varchar(20)
set @wenjianjia='cardid'set @wenjianjia1='d:\files\'+@wenjianjia
Create table #t(a int,b int,c int)
insert #t exec master..xp_fileexist @wenjianjia1
if exists(select * from #t where b=1) --文件不存在,建立'
begin
set @wenjianjia1='md '+@wenjianjia1
exec master..xp_cmdshell @wenjianjia1
end
drop table #t
Declare @wenjianjia1 Varchar(20)
set @wenjianjia='cardid'set @wenjianjia1='d:\files\'+@wenjianjia
Create table #t(a int,b int,c int)
insert #t exec master..xp_fileexist @wenjianjia1
if exists(select * from #t where b=1) --文件不存在,建立'
begin
set @wenjianjia1='md '+@wenjianjia1
exec master..xp_cmdshell @wenjianjia1
end
drop table #t
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货