Subscribe to this blog
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]
GO
CREATE Read more
5 comments, 2,572 reads
Posted in SQL and Me on 19 December 2012