CREATE PROCEDURE PCO_CustSatisfyadd
(
@num varchar(4) = null,
@target1 varchar(2) = null,
@target2 varchar(2) = null,
@target3 varchar(2) = null,
@target4 varchar(2) = null,
@is_call varchar(1) = null
)
AS
BEGIN TRAN --ADD
UPDATE PCO_Satisfy SET
target1 =@target1,
target2 =@target2,
target3 =@target3,
target4 =@target4,
is_call =@is_call
WHERE seqno= ''+@num+''
select * from PCO_Satisfy
COMMIT TRAN --ADD
(
@num varchar(4) = null,
@target1 varchar(2) = null,
@target2 varchar(2) = null,
@target3 varchar(2) = null,
@target4 varchar(2) = null,
@is_call varchar(1) = null
)
AS
BEGIN TRAN --ADD
UPDATE PCO_Satisfy SET
target1 =@target1,
target2 =@target2,
target3 =@target3,
target4 =@target4,
is_call =@is_call
WHERE seqno= ''+@num+''
select * from PCO_Satisfy
COMMIT TRAN --ADD
解决方案 »
- win7(64位系统) 下安装sql2008数据库,安装配置完毕后,输入创建的用户无法登陆
- delphi SQL数据库 连接时"对象打开时 不允许操作"
- 提问:关于修改数据库!
- 知道了被鎖進程的ID號﹐怎么用SQL語句查出被鎖的是哪些表﹑存儲過程等﹖
- Report Service 发送邮件订阅问题,求教高手解决,在线等!
- SQL怎样将两行合并为一行
- 哪里有SQL Sever2000的书籍下载!
- 问问题!!!!
- 我在不知道肯定被草尤鱼!!?????
- 关于修改SQLSERVER端口的疑问
- sqlserver数据库远程连接不上.
- 哪位老大知道的救救我啊~,数据库索引页出错,100分了在线,十万火急。。
(
@num varchar(4) = null,
@target1 varchar(2) = null,
@target2 varchar(2) = null,
@target3 varchar(2) = null,
@target4 varchar(2) = null,
@is_call varchar(1) = null
)
AS
UPDATE PCO_Satisfy SET
target1 =@target1,
target2 =@target2,
target3 =@target3,
target4 =@target4,
is_call =@is_call
if @@error<>0
begin
raiserror('系统出错',16,1) -----------------------打印错误
end
WHERE seqno= ''+@num+''
select * from PCO_SatisfyGO