SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Archives: December 2012

SQL Server – Skipping Function Execution when parameters are NULL

You can avoid executing a function when NULL values are passed as parameters. To achieve this you need to create function with RETURNS NULL ON NULL INPUT, this option introduced in SQL Server 2005.

You can use this while creating a function as below:

USE [SqlAndMe]



CREATE Read more

5 comments, 3,996 reads

Posted in SQL and Me on 19 December 2012