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.
Dotnet, DotnetCore, Azure, C#,VB.net, Sql Server, WCF, MVC ,Linq, Javascript and Jquery
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
Subscribe to:
Posts (Atom)
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...
-
ViewBag, ViewData, TempData and View State in MVC ASP.NET MVC offers us three options ViewData, ViewBag and TempData for passing data from...
-
· Azure Service Fabric is Microsoft’s Platform-as-a-Service (PaaS) and is used to build and deploy microservices-based cloud applicat...
-
// Export Datatable to Excel in C# Windows application using System; using System.Data; using System.IO; using System.Windows.Forms; ...