sqlserver使用table类型

最新推荐文章于 2024-04-17 21:48:48 发布

翘着二郎腿的程序猿

最新推荐文章于 2024-04-17 21:48:48 发布

阅读量603

点赞数

分类专栏： Sqlserver

本文链接：https://blog.csdn.net/qq_36248777/article/details/117664632

版权

Sqlserver 专栏收录该内容

18 篇文章 0 订阅

订阅专栏

USE [HISMZ]
GO

/****** Object: UserDefinedTableType [dbo].[tyfrksl] Script Date: 2021/6/7 15:55:23 ******/
CREATE TYPE [dbo].[tyfrksl] AS TABLE(
   [YPID] [int] NULL,
   [BZSL] [int] NULL,
   [MZJL] [int] NULL,
   [BFJL] [int] NULL,
   [YLXMMC] [varchar](50) NULL,
   [YPLB] [varchar](2) NOT NULL,
   [YPBM] [varchar](8) NOT NULL,
   [ID] [int] NOT NULL,
   [XMMC] [varchar](60) NULL,
   [MZGG] [varchar](30) NULL,
   [MZBZ] [varchar](4) NULL,
   [DJ] [float] NULL,
   [SL] [float] NULL,
   [SFSL] [float] NULL,
   [JE] [float] NULL,
   [CD] [varchar](60) NULL,
   [KCSL] [int] NOT NULL,
   [TJZT] [varchar](6) NOT NULL
)
GO

create PROCEDURE [dbo].[proc_Inputmessage] (@tyfrksl tyfrksl READONLY)
AS
BEGIN
SELECT * INTO hismz..temp20210 FROM @tyfrksl
SELECT * FROM temp20210
END

System.Data.SqlClient.SqlParameter[] parameters = new System.Data.SqlClient.SqlParameter[]
{
new System.Data.SqlClient.SqlParameter() { SqlDbType=SqlDbType.Structured, ParameterName = "@tyfrksl", TypeName="tyfrksl",Value = dt }
}
;