Tag: scalar

Pro Members SQL Server Standard Members

Tips for using SQL Server 2012 User-Defined Functions

by

Tips for using SQL Server 2012 User-Defined Functions If you want to invoke a stored procedure directly from a query and this stored procedure returns a scalar value, consider replacing a stored procedure with a scalar user-defined function. A stored procedure cannot be invoked from the SELECT statement, but if you need to invoke some code inside the query, try...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Continue Reading →
Pro Members SQL Server Standard Members

Troubleshooting problems with user-defined functions in SQL Server 2008 R2

by

Troubleshooting problems with user-defined functions in SQL Server 2008 R2 If you have problems with user-defined functions (UDF) in SQL Server 2008 R2, review this troubleshooting checklist to find potential solutions. 1. Install the latest SQL Server 2008 R2 service pack. Because many SQL Server 2008 R2 UDF bugs were fixed in SQL Server service packs, you should install the...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Continue Reading →