set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
goALTER PROCEDURE [dbo].[P_hebing]
@newzu int,
@oldzu int,
@newhao varchar(10),
@oldhao varchar(10),
@gong varchar(10)
AS
set nocount on
begin tranupdate bzd set zupk=@newzu where zupk=@oldzu
update btaiinfo set zupk=@newzu where zupk=@oldzu
update bjishi set zupk=@newzu where zupk=@oldzu
update bzu set yuanjia=(select sum(yuanjia) from bzd where zupk=@newzu), yinshou=(select sum(yinshou) from bzd where zupk=@newzu),shoukuan= (select sum(shoukuan) from bzd where zupk=@newzu), renshu=(select count(*) from bzd where zupk=@newzu) where zupk=@newzu
delete bzu where zupk=@oldzu
insert into boperec (zupk, act, comment, gong) values( @newzu, '合并组', @oldhao+ '组合并至'+ @newhao, @gong)commit tran
set nocount off
这个存储过程打开时注意,请问如何创建这样的出来.
解决方案 »
- 这个SQL语句应该怎么写?
- 关于sql2008数据表数据更新的问题
- 初学ASP+SQL,遇到问题,详见问题描述,望高手帮忙
- 如何把B库的1表复制到A库的1表
- 请问声明一个游标后应怎样使用?谢谢!!!
- sql2000的数据库,查询怎么临时增加一个布尔型的列
- 将SQLSER数据用DTS导入到MYSQL中遇到问题急!回答通过即给分
- 急!(在线等,分不够可另外加)
- 存储过程调试错误:Unable to communicate with debugger on MDMWEBSERVER (Error = 0x80070005). Debugging disabled for connection 59
- Timeout
- (急)有關BOM結構表設計問題(組裝類型)
- 2000中如何一次同时删除两张表
@newzu int,
@oldzu int,
@newhao varchar(10),
@oldhao varchar(10),
@gong varchar(10)
AS
set nocount on
begin tranupdate bzd set zupk=@newzu where zupk=@oldzu
update btaiinfo set zupk=@newzu where zupk=@oldzu
update bjishi set zupk=@newzu where zupk=@oldzu
update bzu set yuanjia=(select sum(yuanjia) from bzd where zupk=@newzu), yinshou=(select sum(yinshou) from bzd where zupk=@newzu),shoukuan= (select sum(shoukuan) from bzd where zupk=@newzu), renshu=(select count(*) from bzd where zupk=@newzu) where zupk=@newzu
delete bzu where zupk=@oldzu
insert into boperec (zupk, act, comment, gong) values( @newzu, '合并组', @oldhao+ '组合并至'+ @newhao, @gong)commit tran
set nocount off
。
修改才是用ALTER ..................
关键字都分不清?