Showing posts with label COALESCE Ignore Parameter if it is null in SQL Server Queries or Stored Procedure. Show all posts
Showing posts with label COALESCE Ignore Parameter if it is null in SQL Server Queries or Stored Procedure. Show all posts

20 April 2014

COALESCE Ignore Parameter if it is null in SQL Server Queries or Stored Procedure

COALESCE Ignore Parameter if it is null in SQL Server Queries or Stored Procedure

Example :
SELECT Employee, City, DateHired
FROM Employees
WHERE Employee = COALESCE(@Employee, Employee)

If @Employee is null, it displays all the Employee details and if it is not null, it filters and displays the record.


Consistency level in Azure cosmos db

 Consistency level in Azure cosmos db Azure Cosmos DB offers five well-defined consistency levels to provide developers with the flexibility...