create proc DeleteProduct
@id int
as
delete Products where id=@id
gocreate 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
@id int
as
delete Products where id=@id
gocreate 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
解决方案 »
- between and 在不同数据库的区别?
- sql全文检索 增量填充速度太慢了 50万条数据 填充超过24小时
- 触发器能实现此功能吗 在线
- 关于数据库联接???
- 要从datetime字段中找出每天8:00-9:00的数据,能用到索引吗?
- 后缀名为“ .dat”的SQL SERVER备份该如何使用
- 重装系统以后,数据库能继续使用吗(SQL2000不在C盘)
- sql服务器名到问题,大家帮我
- 高手请进,动态执行SQL语句问题以及sp_executesql的用法
- 我想得到某个ms sql server 2000数据表的建表语句(create table),如何编程?
- 数据库根据条件批量更新问题,在线等待
- 高分征求数据库设计方案!
@id int
AS
delete from Products
where ID =@idCREATE PROC UpdateProduct
@id int,@name varchar(40)
AS
update Products
set Name=@name
where id=@id不太明白你的意思,先简单的写了2个过程
as
delete Products where id=@id
gocreate 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
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