740
社区成员
发帖
与我相关
我的任务
分享
ALTER PROCEDURE "DBA"."update_ifenddate"()
BEGIN
DECLARE @ld_nowdate DATE ;
UPDATE DBA.dangan set ifenddate = 1 WHERE bcjsrq=@ld_nowdate;
END
ld_nowdate = date(today() , 'yyyy-mm-dd')
declare sp_update_ifenddate procedure for update_ifenddate
@ld_nowdate = :ld_nowdate;
execute sp_update_ifenddate;
if sqlca.sqlcode = 0 then
commit;
else
messagebox('错误信息:' , sqlca.sqlerrtext)
rollback;
end if
B. 使用带有参数的简单过程
下面的存储过程从四个表的联接中只返回指定的作者(提供了姓名)、出版的书籍以及出版社。该存储过程接受与传递的参数精确匹配的值。
USE pubs
IF EXISTS (SELECT name FROM sysobjects
WHERE name = 'au_info' AND type = 'P')
DROP PROCEDURE au_info
GO
USE pubs
GO
CREATE PROCEDURE au_info
@lastname varchar(40),
@firstname varchar(20)
AS
SELECT au_lname, au_fname, title, pub_name
FROM authors a INNER JOIN titleauthor ta
ON a.au_id = ta.au_id INNER JOIN titles t
ON t.title_id = ta.title_id INNER JOIN publishers p
ON t.pub_id = p.pub_id
WHERE au_fname = @firstname
AND au_lname = @lastname
GO
ALTER PROCEDURE "DBA"."update_ifenddate"(IN @ld_nowdate DATE )
BEGIN
UPDATE DBA.dangan set ifenddate = 1 WHERE bcjsrq=@ld_nowdate;
END