SQL Server2008R2大批数据导出导入文本文件

最新推荐文章于 2022-08-26 15:09:00 发布

原创

最新推荐文章于 2022-08-26 15:09:00 发布 · 1.6k 阅读

2 ·

CC 4.0 BY-SA版权

文章标签：

#数据

USE [IPVA_Builder]
GO
/* Object: StoredProcedure [dbo].[usp_ExportOrImport_Data] Script Date: 03/04/2017 20:50:48 */
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
– =============================================
– Author: – Create date: – Description:
/* EXEC [usp_ExportOrImport_Data] ‘1’, ‘d:\111\’, ‘192.168.1.11’, ‘sa’, ‘123456’ */
– =============================================
ALTER PROCEDURE [dbo].[usp_ExportOrImport_Data]
@Type int, –1导出数据,2导入数据
@Path nvarchar(max), –导出导入路径
@Server nvarchar(100),–服务器IP
@Sa nvarchar(50), –数据库登录名
@PassWord nvarchar(50)–数据库密码
AS
BEGIN
set nocount on;
declare @n int,@count int
declare @TablerName nvarchar(100),@DataBaseName nvarchar(100)
declare @SQL varchar(max)
create table #TableNameA
(
ID INT IDENTITY(1,1),
Name nvarchar(100)
)
insert into #TableNameA
selec