使用storeprocedure将数据插入两个表 [英] Inserting data into two tables using storeprocedure

问题描述

我有两个桌子

人员

id(pk)
名
姓氏


和

订单

orderNumber
订单详情
id(fk)

我必须使用storeprocedure插入数据的名字，姓氏，订单号，订单明细.任何人都可以帮助我.

hi ,i have two tables

Persons

id(pk)
firstname
lastname


and

Orders

orderNumber
orderdetails
id(fk)

I have to inserting data firstname,lastname,ordernumber,orderdetails using storeprocedure.Anyone pls help me.

推荐答案

您的问题是什么?您的存储过程可以运行任何您喜欢的SQL.它可以执行多个语句.它可以完成多个插入.在此处阅读 [

What is your question ? Your sproc can run any sql you like. It can do more than one statement. It can do more than one insert. Read here[^] to see how to get the last identity value that you inserted, I assume that is your core issue, but you don''t say, you show no signs of having done research or thought about this, you just ask us for the answer.

您需要创建SP，其中有两个插入查询和一个选择查询.首先将数据插入表1中.发布该消息，使用创建的键(您需要获取它)插入此新记录，然后在table2中插入一个新记录.

以下几个链接将帮助您学习如何使用SP:
ADO.NET:使用存储过程 [ MSDN:创建过程(Transact-SQL) [

You need to create SP where you have two insert queries and one select query. Insert data in table 1 first. Post that, use the key created(you need to fetch it) for this new record inserted and insert a new record in table2.

Following couple of links will help you in learning on how to use SP:
ADO.NET : Using Stored Procedures[^]
MSDN: CREATE PROCEDURE (Transact-SQL)[^]

Create proc asp_insert_Persons_order
(
@FirstName varchar(100),
@LastName varchar(100),
@OrderNumber int,
@OrderDetails varchar(100)
)
AS
BEgin

Begin tran
Declare @Id int
 Insert into Persons(FirstName, LastName ) values (@FirstName,@LastName )
Select @Id=@@Identity

Insert into Orders values (@OrderNumber ,@OrderDetails ,@Id)

Commit tran
END

这篇关于使用storeprocedure将数据插入两个表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！