Tag Archives: optional parameter
Optional parameters in a T-SQL stored procedure
Sometimes it’s really important to use optional parameter in Stored Procedure. For a beginner, it’s definitely a helpful if he/she practices optional parameters in Stored Procedure. For illustration the scenario here is an example. USE TSQL2012 CREATE PROCEDURE GET_EMP_SP ( … Continue reading
SQL Nirvana 