简单问题，在线等待！！！！

[TracyDang]

表Products 里有如下字段：ID int pk,Name varchar(40),Price Money,Description
varchar(256) = '',Available bit = 1
请问高手如何建立2个存储过程DeleteProduct(从表中删除一条记录)\UpdateProduct（更新表）?谢谢！！！

[pengdali]

create proc DeleteProduct
@id int
as
delete Products where id=@id
go

create proc UpdateProduct
@id int,@name varchar(40),@price money,@Description varchar(256),@Available bit
as
update Products set [name]=@name,price=@price,[Description]=@Description,Available=@Available where id=@id
go

[aierong]

CREATE PROC DeleteProduct
@id int
AS
delete from Products
where ID =@id







CREATE PROC UpdateProduct
@id int,@name varchar(40)
AS
update Products
set Name=@name
where id=@id



不太明白你的意思,先简单的写了2个过程

[txlicenhe]

create proc DeleteProduct @id int
as
delete Products where id=@id
go

create proc UpdateProduct
@id int,@name varchar(40),@price money,@Description varchar(256),@Available bit
as
update Products set [name]=@name,price=@price,[Description]=@Description,Available=@Available where id=@id
go

[yujohny]

--删除
CREATE PROC DeleteProduct(@ID INT)
AS
DELETE Products WHERE ID=@ID

--更新
CREATE PROC UpdateProduct(@ID INT)
AS
UPDATE Products
SET Name=……,Price=……,Description=……,Available=……
WHERE ID=@ID