Tag Archives: Stored Procedure

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

Posted in Uncategorized | Tagged , | Leave a comment