Check if a parameter is null or empty in a stored procedure

by

I sometimes use NULLIF like so…

IF NULLIF(@PreviousStartDate, '') IS NULL

There’s probably no reason it’s better than the way suggested by @Oded and @bluefeet, just stylistic preference.

@danihp’s method is really cool but my tired old brain wouldn’t go to COALESCE when I’m thinking is null or empty 🙂

More Related Contents:

  1. SQL Server Insert if not exists
  2. How to set table name in dynamic SQL query?
  3. Split values over multiple rows [duplicate]
  4. Procedure or function !!! has too many arguments specified
  5. Stored procedure that exports data into csv files only exports to one file
  6. SQL Server: should I use information_schema tables over sys tables?
  7. How to execute a stored procedure inside a select query
  8. Bulk insert using stored procedure
  9. Call stored procedure with table-valued parameter from java
  10. Unpivot with column name
  11. sql query to return differences between two tables
  12. formula for computed column based on different table’s column
  13. Can a stored procedure/function return a table?
  14. Script to kill all connections to a database (More than RESTRICTED_USER ROLLBACK)
  15. How does this CASE expression reach the ELSE clause?
  16. SQL Server: Cannot insert an explicit value into a timestamp column
  17. Execute Dynamic Query with go in sql
  18. TransactSQL to run another TransactSQL script
  19. Conditional logic in PostDeployment.sql script using SQLCMD
  20. How can I get a list of element names from an XML value in SQL Server
  21. How can I group time by hour or by 10 minutes?
  22. Custom function with check constraint SQL Server 2008
  23. How to rename something in SQL Server that has square brackets in the name?
  24. Comma Separated values with SQL Query
  25. how to separate string into different columns?
  26. How to count in SQL all fields with null values in one record?
  27. How to use Alias in Where clause? [duplicate]
  28. Dynamic order direction
  29. Does MS access(2003) have anything comparable to Stored procedure. I want to run a complex query in MS acceess
  30. SQL Server equivalent of WM_CONCAT function [duplicate]

Leave a Comment