使用asp.net在SQL 2008中使用多个条件从多个表更新数据表 [英] update datatable from multiple tables with multiple conditions in sql 2008 using asp.net

问题描述

我在sql server数据库中有一些数据表.我想使用ather表和某些条件中的值更新表中的多个值.我写了更新查询，但是太长了.我正在使用的前端是asp.net.我可以在存储过程中使用此查询吗?我不知道如何使用存储过程.有人请帮助我...

谢谢您.

Hi,

I''m having some datatables in sql server database. I want to update multiple values in a table using values from ather tables and some conditions. I wrote the update query but it is too long. front end I''m using is asp.net. Can I use this query in stored procedure? I dont know how to use stored procedures. Anyone please help me...

Thank you

推荐答案

是的，您可以在存储过程中使用该查询.将整个更新查询放入具有输入参数的存储过程中，该输入参数定义将要更新哪些表的哪些字段.以下文章将帮助您做到这一点:

Sql Server-如何在SQL服务器 [ http://msdn.microsoft.com/en-us/library/ms345415.aspx [ ^ ]
creating-and-managing-stored-procedure-in-sql-server-2008/> creating-and-managing-stored-procedure -in-sql-server-2008 [ http://www.c-sharpcorner .com/UploadFile/rohatash/select-insert-update-delete-using-stored-procedure-in-sql/ [

Yes you can use that query in a stored procedure. Put your whole update query in a stored procedure with input parameters defining which fields of what tables will be getting updated. Following articles will help you do so:

Sql Server - How to write a Stored procedure in Sql server[^]
http://msdn.microsoft.com/en-us/library/ms345415.aspx[^]
creating-and-managing-stored-procedure-in-sql-server-2008[^]
http://www.c-sharpcorner.com/UploadFile/rohatash/select-insert-update-delete-using-stored-procedure-in-sql/[^]

这篇关于使用asp.net在SQL 2008中使用多个条件从多个表更新数据表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！