Write and submit a create stored procedure statement for a stored procedure named EmpOrderCount in the dbo schema that takes a territoryid as a parameter. The parameter must be named TerritoryID. The parameter should default to null. The stored proc should not return the rowcount. The stored proc should raise a SQL Server error with a severity of 11, a message saying “@TerritoryID not in table” with a state of 1 when the given @TerritoryID is not in the Territories table.

Answer rating: 100% (QA)

Heres a SQL Server stored procedure named EmpOrderCount in the dbo schema that meets your re... View the full answer