SET @zx='master..xp_cmdshell ''bcp "select column_name from zhangqi.INFORMATION_SCHEMA.COLUMNS where TABLE_NAME=''test2'' " queryout d:\a'+@cc+'.txt -f d:\new\test2.fmt -U"sa" -P"sa"'''
PRINT @zx
EXEC (@zx)
输出:
master..xp_cmdshell 'bcp zhangqi.dbo.test2 format nul -T -c -f d:\new\test2.fmt -U"sa" -P"sa"'
(1 行受影响)
master..xp_cmdshell 'bcp "select column_name from zhangqi.INFORMATION_SCHEMA.COLUMNS where TABLE_NAME='test' " queryout d:\a1.txt -f d:\new\test2.fmt -U"sa" -P"sa"'
消息 102,级别 15,状态 1,第 1 行
“test2”附近有语法错误。
求指正,哪里出错了