guoc.txt

自己做的一个商品销售信息管理的程序。 VB新手

create procedure sp_chuku_kucun
@shangpinmingc char,@shangpinshul int
as
declare @kucun int
declare cursor_chuku cursor  for select 库存数量 from kucunxinxibiao 
where 商品名称=@shangpinmingc
open cursor_chuku
fetch first from cursor_chuku into @kucun
close cursor_chuku
deallocate cursor_chuku
updata kucunxinxibiao
set 库存数量=@kucun-@shangpinshul
where 商品名称=@shangpinmingc