更新给定存储过程的查询 [英] Update Query For the Given Stored Procedure
问题描述
Hello Sir ....
我有一个存储过程,用于在数据库中插入值,我想知道更新的过程是什么并在数据库中替换这些值。
ALTER proc [dbo]。[usp_insertCorporateUserRenw]
(
@userID int,
@Mop nchar(20),
@Bankname varchar(80),
@Ammount varchar(80),
@chddno nchar(20),
@chdddate varchar(80)
)
as
插入Paidmemberdetails(UserID,Mop,Bankname,Ammount,chddno, chdddate,utype,payactivation)
值(@ userID,@ Mop,@ Bankname,@ Ammount,@ chddno,@ chdddate,'U',0)
Hello Sir....
I have a Stored Procedure for inserting the values in in the database and i want to know that what is the procedure to update and replace these values in the database .
ALTER proc [dbo].[usp_insertCorporateUserRenw]
(
@userID int,
@Mop nchar(20),
@Bankname varchar(80),
@Ammount varchar(80),
@chddno nchar(20),
@chdddate varchar(80)
)
as
insert into Paidmemberdetails (UserID,Mop,Bankname,Ammount,chddno,chdddate,utype,payactivation)
values (@userID,@Mop,@Bankname,@Ammount,@chddno,@chdddate,'U',0)
推荐答案
ALTER proc [dbo]。[usp_insertCorporateUserRenw]
(
@userID int,
@Mop nchar(20 ),
@Bankname varchar(80),
@Ammount varchar(80),
@chddno nchar(20),>
@chdddate varchar(80)
)
as
更新Paidmemberdetails设置UserID = @ userID,Mop = @ userID,Bankname = @Bankname,Ammount = @Ammount,
chddno = @ chddno,chdddate = @ chdddate,utype ='U',payactivation ='0'其中Uniquecolumn = @ uniquecolumn
结束
ALTER proc [dbo].[usp_insertCorporateUserRenw]
(
@userID int,
@Mop nchar(20),
@Bankname varchar(80),
@Ammount varchar(80),
@chddno nchar(20),
@chdddate varchar(80)
)
as
Update Paidmemberdetails set UserID=@userID,Mop=@userID,Bankname=@Bankname,Ammount=@Ammount,
chddno=@chddno,chdddate=@chdddate,utype='U',payactivation='0'where Uniquecolumn=@uniquecolumn
End
参考:
select-insert-update-delete-using-stored-procedure-in-sql/ [ ^ ]
http:// msdn .microsoft.com / zh-cn / library / bb384469.aspx [ ^ ]
这可能会有所帮助。
Refer:
select-insert-update-delete-using-stored-procedure-in-sql/[^]
http://msdn.microsoft.com/en-us/library/bb384469.aspx[^]
This may help.
这篇关于更新给定存储过程的查询的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!