如何对多个表及其参数使用单个插入，更新，删除，更新方法 [英] How can use single insert,update,delete,update method for many tables with their parameters

问题描述

Hi Friends
现在，我正在编写代码，以便对所有插入操作使用每种插入方法.像这样我正在写删除，更新，搜索.每次操作都需要花费大量代码.但是我想对不同的表及其参数使用单一插入方法，以及更新，删除，搜索方法.请根据需要提供任何示例代码.
谢谢

Hi Friends
now i am writing code for using each insert method for all insert operation. like this i am writing for delete,update,search. this take lot of code for every operation. but I would like to use single insert method for different table with their parameters and also for update,delete,search method.please give me any sample code for my requirement.
Thank you

推荐答案

最简单的方法是编写一个存储过程来完成工作-它启动事务，执行插入(或更新或删除)并提交如果一切正常.

The easiest way is to write a stored procedure which does the job - it starts a transaction, does the inserts (or updates, or deletes) and commits if it all works.

CREATE PROCEDURE sp_InsertMultiple
    (
    @Text1 varchar(255),
    @Text2 varchar(255)
    )
AS
BEGIN
    BEGIN TRAN
    INSERT INTO Table1 (Column1) VALUES (@Text1)
    INSERT INTO Table2 (Column2) VALUES (@Text2)
    COMMIT TRAN
END

这篇关于如何对多个表及其参数使用单个插入，更新，删除，更新方法的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！