SQL Create Function Simple Example

Create functionTest@Num varchar( -))--@Num Parametersreturns varchar( -)--return value type asbeginDeclare @MSG varchar( -)if(@Num =1)    Select @MSG ='correct'Else    Select @MSG ='Error'return @MSGEnd

--Call function
Select Dbo.test (2)--Pass parameter 2
Return Result: Error

--Create a function that returns a table type

Create function gettabledetails () returns TABLE  as     return (Select* from sales)

--Call function
SELECT * FROM dbo. Gettabledetails ()--dbo. Need attention
Returns all records for the sales table.

SQL Create Function Simple Example