SQLSERVER存储过程和函数的定义,调用

1.Create Procedure

 

CREATE   PROCEDURE  sp_Test
( @Param1   varchar ( 64 ) = '' , @Param2   varchar ( 64 ))
AS
select   *   from  table_name

调用方法

sp_Test 'param1','param2' 

2. Create Function

 

CREATE   FUNCTION  fn_Test 
( @Param1   varchar ( 64 ), @Param2   varchar ( 64 ))
RETURNS   TABLE
AS
select   *   from  table_name 

调用方法

select * from fn_Test('param1','param2')