Function in SQL Server

hi,

There are two types of User-Defined functions in SQL Server.Scalar, Inline Table-Valued and Multi-statement Table-valued.
A Scalar user-defined function returns one of the scalar data types.

CREATE FUNCTION MyValue
(@Value int)
RETURNS varchar(30)
AS
BEGIN
declare @Return varchar(30)
select @return = 'you are Entered: 1'
end

An Inline Table-Value or Multi-statement Table-Value user-defined function returns a table data type and is an exceptional alternative to a view as the user-defined function can pass parameters into a T-SQL select command and in essence provide us with a parameterized, non-updateable view of the underlying tables.

CREATE FUNCTION Customers
(@CustomerId Int)
RETURNS TABLE
AS
RETURN
  SELECT *  FROM customers
  WHERE customerId = @CustomerId

Please refer
http://msdn.microsoft.com/en-us/library/ms186755.aspx

hope this will help you.

Hi Vipendra,


Please refer the below links

http://www.sqlteam.com/article/user-defined-functions

http://www.functionx.com/sqlserver/functions/create.htm

http://www.simple-talk.com/sql/t-sql-programming/sql-server-functions-the-basics/

Thanks

Check this link for some examples of creating user-defined functions:

http://www.techrepublic.com/blog/datacenter/understand-when-to-use-user-defined-functions-in-sql-server/171