一、批量更新
1、创建表
USE [test] GO /****** Object: Table [dbo].[test] Script Date: 07/20/2017 00:43:53 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[test]( [ID] [int] IDENTITY(1,1) NOT NULL, [mycode] [nvarchar](50) NULL, [myname] [nvarchar](50) NULL, [mydes] [nvarchar](50) NULL ) ON [PRIMARY] GO
2、创建用户定义表类型3、创建批量插入存储过程USE [test] GO /****** Object: UserDefinedTableType [dbo].[testtable] Script Date: 07/20/2017 00:44:15 ******/ CREATE TYPE [dbo].[testtable] AS TABLE( [ID] [int] NULL, [testcode] [nvarchar](50) NULL, [testname] [nvarchar](50) NULL, [testdes] [nvarchar](50) NULL ) GO
USE [test] GO /****** Object: StoredProcedure [dbo].[test_proc] Script Date: 07/20/2017 00:44:32 ******/ SET ANSI_NULLS ON