如何从单个查询插入两个表 [英] how to insert into two tables from single query

问题描述

朋友，如何从单个sql查询中插入两个表中?
我想将tbl1值a，b，c以及tbl2值d，e，f插入，但我想使用单个查询如何实现呢?请提供代码帮助...
关于bishnu karki

Hi friends, how can i insert into two tables from single sql query ...
i want to insert into tbl1 values a,b,c and into tbl2 the values d,e,f but i want to use single query how can i achieve this please help with the code...
with regards bishnu karki

推荐答案

开始

您不能在一个查询中执行，但可以执行一个事务:)

据我所知，您允许每个SQL语句插入或更新一个表.另一方面，您可以在一个查询中包含多个语句，并用分号(;)分隔该语句.

或可以帮助您的摘要:

You can not do in a one query but you can do it one transaction :)

As far as I know you are allowed to INSERT into or UPDATE one table per SQL statement. On the other hand, you can have multiple statements in a single query and separate the statement with a semi-colon ( ; ).

Or a snipplet that can help you:

BEGIN TRANSACTION; 
DECLARE @DataID int; 
INSERT INTO DataTable (Column1 ...) VALUES (....); 
SELECT @DataID = scope_identity(); 
INSERT INTO LinkTable VALUES (@ObjectID, @DataID); 
COMMIT; 

您需要两个单独的INSERT语句，但这听起来像是您想从第一次插入中获得 IDENTITY 并在第二种情况下使用它，在这种情况下，您可能需要查看 OUTPUT 或 OUTPUT INTO :
REF:输出子句(Transact-SQL)

通过使用ODBC .NET提供程序和Visual C#.NET，您可以使用 SQL参数化存储过程轻松地做到这一点

将数据插入多个表C#

You need two separate INSERT statements, but it sounds like you want to get the IDENTITY from the first insert and use it in the second, in which case, you might want to look into OUTPUT or OUTPUT INTO:
REF: OUTPUT Clause (Transact-SQL)

Bur you can easily do that using SQL Parameterized Stored Procedures by Using the ODBC .NET Provider and Visual C# .NET

Another solution for Inserting data in multiple tables C#

的另一种解决方案

这篇关于如何从单个查询插入两个表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！