34,590
社区成员
发帖
与我相关
我的任务
分享
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
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
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