一、批量更新
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
4、创建批量更新存储过程:USE [test] GO /****** Object: StoredProcedure [dbo].[test_proc] Script Date: 07/20/2017 00:44:32 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE PROCEDURE [dbo].[test_proc] ( @tt [testtable] READONLY ) AS INSERT INTO [dbo].[test] ([mycode],[myname],[mydes]) SELECT oc.[testcode],oc.[testname],oc.[testdes] FROM @tt AS oc; GO
USE [test] GO /****** Object: StoredProcedure [db