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.
CLR User-Defined Functions. User-defined functions are routines that can take parameters, perform calculations or other actions, and return a result. Beginning with SQL Server 2005, you can write user-defined functions in any Microsoft .NET Framework programming language, such as Microsoft Visual Basic .NET or Microsoft Visual C#. There are two types of functions: scalar, which returns a single value, and table-valued, which returns a set of rows.