📄 guoc.txt
字号:
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
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -