Store Procedure with Output Parameter

 Store Procedure  with Output Parameter

Stored procedure with Encryption

Table Valued Function

--Create

create function funTableValued()

returns table

as

return(

select * from test1.dbo.Employee

)

--Execute

select * from dbo.funTableValued()

Scaler Valued Functions

--Create

create function funScalerValued()

returns numeric(18,2)

as

begin

declare @num numeric(18,2)

select @num=count(*) from test1.dbo.Employee

return @num

end

--Execute

select dbo.funScalerValued()