Default Parameter « Store Procedure Function « SQL Server / T-SQL






1.Paraemter with NULL value
2.Specifying a Default Parameter Value
3.Using the system date as a default parameter.