sql问题

[yimi_love]

alter PROCEDURE [dbo].[pro_sep]
(
@sep nvarchar(50)
)
AS
BEGIN
EXEC master..xp_cmdshell 'bcp "test.dbo.sep1" in "c:\Sep1.txt" -c -SPACSSERVER -Usa -Psa'
end

我想把 EXEC master..xp_cmdshell 'bcp "test.dbo.sep1" in "c:\Sep1.txt" -c -SPACSSERVER -Usa -Psa' 中的"c:\Sep1.txt"换成变量 @sep 怎么写啊？？？？

[-狙击手-]

alter PROCEDURE [dbo].[pro_sep] 
( 
  @sep nvarchar(50) 
) 
AS 
BEGIN 
EXEC  master..xp_cmdshell 'bcp  "test.dbo.sep1"  in  "'+@sep+'" -c  -SPACSSERVER  -Usa  -Psa'  
end 

[hyqwan11112]

alter PROCEDURE [dbo].[pro_sep] 
( 
  @sep nvarchar(50) 
) 
AS 
BEGIN 
EXEC  master..xp_cmdshell 'bcp  "test.dbo.sep1"  in  "'+@sep+'" -c  -SPACSSERVER  -Usa  -Psa'  
end 

[yimi_love]

显示有语法错误啊！

消息 102，级别 15，状态 1，过程 pro_sep，第 18 行
'+' 附近有语法错误。

[火星求索]

declare @sql varchar(1000),@str varchar(50)
--master..xp_cmdshell执行类型是varchar
set @str ='c:\Sep1.txt'
set @sql='bcp  "test.dbo.sep1"  in  "'+@str+'" -c  -SPACSSERVER  -Usa  -Psa' 
EXEC  master..xp_cmdshell @sql