Optional parameters in sql server stored procedures Part 68

Link for code samples used in the demo Link for csharp, dotnet basics, mvc and sql server video tutorial playlists Parameters of a sql server stored procedure can be made optional by specifying default values. We wil be using table tblEmployee for this Demo. CREATE TABLE tblEmployee ( Id int IDENTITY PRIMARY KEY, Name nvarchar(50), Email nvarchar(50), Age int, Gender nvarchar(50), HireDate date, ) Insert into tblEmployee values ( Sara Insert into tblEmployee values ( James Insert into tblEmployee values ( Mary Insert into tblEmployee values ( Paul Name, Email, Age and Gender parameters of spSearchEmployees stored procedure are optional