Function in Sql 2008 ??? [Resolved]

Posted by S.Preeti under ASP.NET on 9/30/2012 | Points: 10 | Views : 1090 | Status : [Member] | Replies : 4
How to create function in sql 2008.

Thnx in advance.




Responses

Posted by: Ranjeet_8 on: 9/30/2012 [Member] [MVP] Gold | Points: 50

Up
0
Down

Resolved
Use this code to create function in sql

CREATE FUNCTION YourFunction_Name()
RETURNS Decimal(6, 2) // Set your return type
AS
BEGIN
// your calculation here.
RETURN 944.22 // return your value
END;
GO


S.Preeti, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Jayakumars on: 9/30/2012 [Member] [MVP] Bronze | Points: 25

Up
0
Down
hi

refer this

http://www.dotnetfunda.com/codes/code3295-how-to-create-function-in-sql-2008.aspx



Mark as Answer if its helpful to you

S.Preeti, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Jayakumars on: 9/30/2012 [Member] [MVP] Bronze | Points: 25

Up
0
Down
hi

Please mark as answer if it helpful to you.

Mark as Answer if its helpful to you

S.Preeti, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: S.Preeti on: 9/30/2012 [Member] Starter | Points: 25

Up
0
Down
Plz dont post link only.

S.Preeti, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response