📄 scheduletransfer.txt
字号:
create procedure scheduletransfer(@acno varchar(10), @payee varchar(10), @tranpwd varchar(10), @amt money,@schddate datetime, @tdesc varchar(50))
as
declare @id integer
if not exists ( select * from users where acno = @acno and tpwd = @tranpwd )
begin
raiserror('Invalid Transaction Password',16,1)
return
end
select @id = isnull(max(stid),0) + 1 from schdtrans
insert into schdtrans
values(@id, @acno,@payee,@schddate,@amt,@tdesc)
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -