如何在头表中插入一条记录，在明细表中插入多条记录 [英] how to insert one record in header table and multiple record in detail table

问题描述

大家晚上好，


我在插入记录标题表和明细表时遇到问题.
我的标题表在下面给出

good evening everyone,


I have problem inserting record Header Table and Detail Table.
my Header Table Is given Below

CREATE TABLE [dbo].[TransactionHeader](
    [TransactionKey] [int] IDENTITY(1,1) NOT NULL,
    [TransactionType] [int] NULL,
    [IntExternalFlag] [int] NULL,
    [TransactionDate] [datetime] NULL,
 CONSTRAINT [PK_TransactionHeader] PRIMARY KEY CLUSTERED
(
    [TransactionKey] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

和详细信息表在下面给出.

and Detail Table is Given Below.

CREATE TABLE [dbo].[TransactionDetail](
    [DetailKey] [int] IDENTITY(1,1) NOT NULL,
    [TransactionKey] [int] NOT NULL,
    [AssetID] [int] NULL,
    [LocationID] [int] NULL,
    [EmployeeID] [int] NULL,
    [SupplierID] [int] NULL,
    [IssuedReceivedDate] [datetime] NULL,
    [TransactionDate] [datetime] NULL,
 CONSTRAINT [PK_TransactionDetail] PRIMARY KEY CLUSTERED
(
    [DetailKey] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[TransactionDetail]  WITH CHECK ADD  CONSTRAINT [FK_TransactionDetail_TransactionHeader] FOREIGN KEY([TransactionKey])
REFERENCES [dbo].[TransactionHeader] ([TransactionKey])
GO

我想创建一个存储过程，该过程将一个记录插入到页眉中，并将多个记录插入到明细表中.
我的transactionKey由表的身份规范属性自动生成.

所以请帮我如何创建程序....................
请给我任何例子.

谢谢

I want To Create one Stored procedure which is insert the one Record into Header and Multiple Record In Details Table.
My transactionKey is automatically generated by identity specification property of table.

so please help me how can i create procedure ....................
please give me any example.

Thanks

推荐答案

很多方法....

选择其中的几个

使用 OPENXML [ XQuery [ ^ ]或 SQLXML [ ^ ]

使用OpenXML将数据插入SQL 2000中. ADO.NET [^ ]

Many ways....

Pick couple of them

Use OPENXML[^] or XQuery[^] or SQLXML[^]

Insert Data into SQL 2000 Using OpenXML & ADO.NET[^]

这篇关于如何在头表中插入一条记录，在明细表中插入多条记录的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！