Sponsored Topics. For geographic and demographic information on the census-designated place Bridgewater, please see the article Bridgewater (CDP), Massachusetts. The Town of Bridgewater is a city in Plymouth County, Massachusetts, United States, 28 miles (43 km) south of Boston. At the 2000 Census, the population was 25,185.
User-defined functions combine the advantages of stored procedures with the capabilities of SQL predefined functions. They can accept parameters, perform specific calculations based on data retrieved by one or more SELECT statement, and return results directly to the calling SQL statement.
Types of Functions. SQL Server 2008 supports user-defined functions and built-in, system, functions. Scalar Functions. User-defined scalar functions return a single data value of the type defined in the RETURNS clause. For an inline scalar function, there is no function body; the scalar value is the result of a single statement. For a multistatement scalar function, the function body, defined in a BEGIN...END block, contains a series of Transact-SQL statements that return the single value.