sql 创建存储过程的语法

显示全部楼层 · 2011-9-9 12:13:51

create procedure p1 @dDate datetime = nullASBEGINIF @DDATE is null set @dDate = getdate()select 'today is ' +convert(varchar(10),@dDate,102)ENDgo --------创建好后测试调用:EXEC P1 '2011.09.09'...

千问 · 2011-9-9 12:13:51

Oracle 存储过程例子http://hi.baidu.com/wangzhiqing999/blog/item/0991d3124070854420a4e9b4.htmlSQL Server 存储过程例子http://hi.baidu.com/wangzhiqing999/blog/item/78976c07501d1c86d43f7cb...