环境1:
MS SQL SERVER 2005,WINODWS XP 可以执行环境2:
MS SQL SERVER 2005,WINODWS SERVER 2003 执行报错:“The syntax of the command is incorrect.”EXEC MASTER..xp_cmdshell 'cd E:\ && IF NOT EXIST C:\%date:~0,4%%date:~5,2%%date:~8,2% (mkdir %date:~0,4%%date:~5,2%%date:~8,2%) ELSE (cd E:\%date:~0,4%%date:~5,2%%date:~8,2%)'
MS SQL SERVER 2005,WINODWS XP 可以执行环境2:
MS SQL SERVER 2005,WINODWS SERVER 2003 执行报错:“The syntax of the command is incorrect.”EXEC MASTER..xp_cmdshell 'cd E:\ && IF NOT EXIST C:\%date:~0,4%%date:~5,2%%date:~8,2% (mkdir %date:~0,4%%date:~5,2%%date:~8,2%) ELSE (cd E:\%date:~0,4%%date:~5,2%%date:~8,2%)'
前提是,你的那个批处理要能正确执行!
我现在不写批,我在在这个cmdshell里写。
cmdshell 一次只能执行在DOS命令提示符的一行上执行的语句.