How many kind of User Defined Functions can be created in Sql Server2000

Home >> Dababase Interview Questions >> Sql Server 2000 Query

Posted on May 22nd , 2009 by Admin

	here are three types of User-Defined functions in SQL Server 2000 and they are Scalar, Inline Table-Valued and Multi-statement Table-valued.A Scalar user-defined function returns one of the scalar data types.An Inline Table-Value user-defined function returns a table data type.A Multi-Statement Table-Value user-defined function returns a table.