Resources » Code Snippets » SQL

How to write a Function in SQL Server


Posted Date: 17-Sep-2008  Last Updated:   Category: SQL    
Author: Member Level: Gold    Points: 10



This code shows how to write a function in sql server
A function which takes Empno and calculate Total and Anuual Salary and returns them

Create Function get_EmpData(@empno int)
Returns @MyTable Table(Total Money,Annual Money)
As
Begin
Declare @Sal Money,@Comm Money
Declare @TSal Money,@ASal Money
Select @Sal=sal, @Comm=comm from emp
where empno@empno

Set @TSal = @Sal + IsNull(@Comm,0)
Set @ASal = (@Sal + IsNull(@Comm,0))*12
Inset into @MyTable Values(@TSal,@ASal)
Return

End

Calling the above function

Select * from get_EmpData(1005)

Regards
S.S.Bajoria


Did you like this resource? Share it with your friends and show your love!

Responses to "How to write a Function in SQL Server"
Author: umang    29 Sep 2008Member Level: Bronze   Points : 0
This coding is very useful.by this way a programmer get much a help.


Feedbacks      

Post Comment:




  • Do not include your name, "with regards" etc in the comment. Write detailed comment, relevant to the topic.
  • No HTML formatting and links to other web sites are allowed.
  • This is a strictly moderated site. Absolutely no spam allowed.
  • Name:   Sign In to fill automatically.
    Email: (Will not be published, but required to validate comment)



    Type the numbers and letters shown on the left.


    Submit Article     Return to Article Index

    Subscribe to Subscribers
    Active Members
    TodayLast 7 Daysmore...

    Awards & Gifts
    Talk to Webmaster Tony John

    Online Members

    More...
    Copyright © SpiderWorks Technologies Pvt Ltd., Kochi, India