sql 创建存储过程的语法

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