BCP directives for SQL Server

Sometimes you need to allow BCP directives

--Allow advanced options to be configured
EXEC sp_configure ' show advanced options ', 1
GO
--Reconfigure
RECONFIGURE
GO
--Enable xp_cmdshell
EXEC sp_configure ' xp_cmdshell ', 1
GO
--Reconfigure
RECONFIGURE
GO

1. Export File:

EXEC (' EXEC master. xp_cmdshell ' bcp ' select * FROM [dbname]. [Dbo].tablename where xx= ' ' xx ' "

Queryout "D:\sql\.txt"-c-s "QCLOUD-VM"-u "username"-P "pwd" "

2. import File:

　　EXEC master. xp_cmdshell ' bcp [dbname]. [Dbo].tablename in D:\sql\sql.txt-c-T '

BCP directives for SQL Server