create table goods
(
id varchar(10),
[name] varchar(10),
num int
)
gocreate trigger tri_goods on goods instead of insert
as
begin
declare @id as varchar(10)declare @name as varchar(10)declare @num as intselect @id=id from insertedselect @name=name from insertedselect @num=num from insertedif exists(select * from goods where id=@id and name=@name)update goods set num=num+@num where id=@id
else
insert into goods values(@id,@name,@num)
end
go这是入库时的触发器
代码是C#编写的窗体 添加代码 string sql = "insert into goods values('" + textBox1.Text + "','" + textBox2.Text + "'," + int.Parse(textBox3.Text) + ")";
哪位大侠能写个出库时的触发器 c# 的删除代码怎么写????
有2个textbox1 textbox2 是要删除的ID 和药删除的数量?????
要该怎么写?
(
id varchar(10),
[name] varchar(10),
num int
)
gocreate trigger tri_goods on goods instead of insert
as
begin
declare @id as varchar(10)declare @name as varchar(10)declare @num as intselect @id=id from insertedselect @name=name from insertedselect @num=num from insertedif exists(select * from goods where id=@id and name=@name)update goods set num=num+@num where id=@id
else
insert into goods values(@id,@name,@num)
end
go这是入库时的触发器
代码是C#编写的窗体 添加代码 string sql = "insert into goods values('" + textBox1.Text + "','" + textBox2.Text + "'," + int.Parse(textBox3.Text) + ")";
哪位大侠能写个出库时的触发器 c# 的删除代码怎么写????
有2个textbox1 textbox2 是要删除的ID 和药删除的数量?????
要该怎么写?
解决方案 »
- SQL Server 2008的更新语句
- [求教:动态语句中调用自定义函数问题]
- 请问我想把日期限定在1700-1-1到2099-12-30,用以下代码为什么实现不了
- SSIS读文件时候的sequence
- 这个函数怎么写啊,达人来看看
- SQLServer2008远程查询问题
- 服务器改名后SQLSERVER不能启动?
- 我的一个*.tab怎么把里面的数据放到SQL数据库里面啊?求高手帮忙
- 如何用两个字段联合在一起来进行group by ?
- 数据源连接失败的原因?????
- 如何仅仅复制一个数据库中的所有表 ---求救
- mysql中的左外连接在oracle中用什么表示?mysql中的数据库在oracle中对应什么?
as
BEGIN
UPDATE 库存表 SET NUM=NUM-I.NUM..
END
那哪天要查看明细。咋办?
create trigger tr_goods_update on goods for update
as
declare @id as varchar(10)
declare @name as varchar(10)
declare @num as intbegin transaction trans_goods
if exists(select * from goods where id=@id and name=@name)
BEGIN
declare cur cursor for select [id],[name] from goods
open cur
fetch next from cur Into @id,@name
while @@fetch_status=0
begin
update goods set num=num-@num where [id]=@id and [name]=@name
Fetch Next from cur Into @id,@name
end
close cur
deallocate cur
ENDif @@error<>0
rollback transaction trans_goods
else
commit transaction trans_goods