//
archives

IsNullOrEmpty – A user Defined Function in SQL server

This tag is associated with 1 post

IsNullOrEmpty – A user Defined Function in SQL server


This is an equal implementation of C# function String.IsNullOrEmpty in SQL. This function returns 1 if parameter is NULL or empty. Here is the implementation of this function: Implementation: CREATE FUNCTION dbo.IsNULLOrEmpty(@data varchar(max)) RETURNS BIT AS BEGIN if(NULLIF(@data,”)) is NULL return 1 — return 1 when there is a NULL or Empty. return 0 — … Continue reading