sql下三种批量插入数据的方法

建库语句及代码实现

```sql

-- 创建数据库

USE master

GO

IF EXISTS (SELECT FROM master.sys.databases WHERE name = N'BulkDB')

DROP DATABASE BulkDB

CREATE DATABASE BulkDB;

GO

-- 创建表

USE BulkDB

GO

IF OBJECT_ID('dbo.BulkTable', 'U') IS NOT NULL

DROP TABLE dbo.BulkTable

CREATE TABLE BulkTable (Id INT PRIMARY KEY, UserName NVARCHAR(32), Pwd VARCHAR(16))

GO

-- 创建表值参数类型

USE BulkDB

GO

IF EXISTS (TYPE T FROM sys.types st JOIN sys.schemas ss ON st.schema_id = ss.schema_id WHERE st.name = N'BulkType' AND ss.name = N'dbo')

DROP TYPE dbo.[BulkType]

CREATE TYPE dbo.[BulkType] AS TABLE (Id INT, UserName NVARCHAR(32), Pwd VARCHAR(16))

GO

```

```csharp

public static void InsertDataByLoop()

{

Stopwatch sw = new Stopwatch();

DataTable dt = GetTable(); // 获取数据表