调用包含更新语句的StoreProcedute [英] Calling StoreProcedute which contain update statement

问题描述

我编写了存储过程，在其中使用了Update语句.
我想调用存储过程.对于插入并选择我已经完成，但无法进行更新.
我正在使用SQL Server 2000和Visual Studio2005.
有人可以帮我吗?
在此先感谢您.

I have written stored procedure in which i used Update Statement.
I want to call stored procedure. For insert and select i have done but it''s not working for update.
I am using sql server 2000 and visual studio 2005.
Can any one help me?
Thanks in advance.

推荐答案

您调用的更新存储过程与任何其他存储过程完全相同，只需确保您传入所需的参数即可.没有区别.如果您使用的控件直接设置了Update语句，那么这些事情将毫无用处，只需编写一个适当的数据层并对其进行处理即可.

You call an update stored proc exactly the same as any other stored proc, just making sure you pass in the required parameters. There is no difference. If you''re using a control that has you set up Update statements directly, those things are useless, just write a proper data layer and be done with it.

假设您有一个名为作为T1
列:Id，名称，地址

1d名称地址
1萨吉德454545
2参数565656

Suppose you have table named as T1
Columns:Id,Name,Address

1d Name Address
1 Sajid 454545
2 Param 565656

create proc UpdateName(@Name varchar(30),@Id int)
as
Update T1 set Name=@Name where Id=@Id

如何调用存储过程

How to call the Stored Procedure

exec UpdateName 'Sajid Shahsroha',1;

这篇关于调用包含更新语句的StoreProcedute的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！