我想通过一个Sp将数据插入两个表中 [英] I Want To Insert Data In Two Tables Through an Single Sp
问题描述
我有一个关于存储过程的查询,我有两个表Parent和Child,
父级-主键表,
子-外键表.
父表结构
Parent_Id-int,
FName-varchar,
LName-varchar,
年龄诠释
子表结构
Child_Id-int,
地址-varchar,
状态-varchar,
国家-varchar.
我想通过一个Sp在这两个表中插入数据.
你们每个人都能知道吗,请回应它对我来说很重要...
请帮助我...
^ ]应该可以为您提供帮助.各自的有效参数.
我认为您应该在这里尝试而不是提出问题.反正...
CREATE PROCEDURE XYZ<br /> @Name VARCHAR(50),<br /> @Parameter2 INT,<br /> ........<br /> .....<br /> AS<br /> BEGIN<br /> <br /> Insert INTO tbl_ABC(List of columns in which value to be inserted..) VALUES(Parameters..)<br /> <br /> ....... Insert query 2 .............<br /> <br /> END
Hi,
I Have a query Regarding Stored Procedure, I am Having Two Tables Parent and Child,
Parent - Primary Key Table,
Child - Foreign Key Table.
Parent Table Structure
Parent_Id - int,
FName - varchar,
LName - varchar,
Age int.
Child Table Structure
Child_Id - int,
Address - varchar,
State - varchar,
Country - varchar.
I Want To Insert Data In These Two Tables through One Sp.......
Can Anyone of u Can Know It Please Response it it''s Very Important For Me...
Please Help Me ...
This thread[^] should help you out.
Write queries in sp one by one with their respective valid parameter.
I think you should give a try than meke question here. Anyways...
CREATE PROCEDURE XYZ<br /> @Name VARCHAR(50),<br /> @Parameter2 INT,<br /> ........<br /> .....<br /> AS<br /> BEGIN<br /> <br /> Insert INTO tbl_ABC(List of columns in which value to be inserted..) VALUES(Parameters..)<br /> <br /> ....... Insert query 2 .............<br /> <br /> END
这篇关于我想通过一个Sp将数据插入两个表中的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!