"SQL Server only maintains default values for CLR objects in this catalog view (sys.parameters); therefore, this column (has_default_value) has a value of 0 for Transact-SQL objects. To view the default...