SQL Server stored procedure return code oddity

by

In playing around with the procedure, I can get a a return -6, if I insert a null into foo.KeyCol and remove the RAISERROR in the inner catch. This is something SQL Server is doing, and is documented here: Return Values from Stored Procedures.

More Related Contents:

  1. T-SQL stored procedure that accepts multiple Id values
  2. Select columns from result set of stored procedure
  3. Escape a string in SQL Server so that it is safe to use in LIKE expression
  4. EXEC sp_executesql with multiple parameters
  5. T-SQL Dynamic SQL and Temp Tables
  6. How do I find a stored procedure containing ?
  7. Check if a string contains a substring in SQL Server 2005, using a stored procedure
  8. Why can’t Entity Framework see my Stored Procedure’s column information?
  9. Max Nbr of Months W/ No Activity in Past 12 Months
  10. SQL server query to output the data shown below
  11. Will ANSI JOIN vs. non-ANSI JOIN queries perform differently?
  12. Function vs. Stored Procedure in SQL Server
  13. How do you view ALL text from an ntext or nvarchar(max) in SSMS?
  14. Floor a date in SQL server
  15. Create a view with ORDER BY clause
  16. What does ‘COLLATE SQL_Latin1_General_CP1_CI_AS’ do?
  17. INSERT INTO vs SELECT INTO
  18. Possible to store value of one select column and use it for the next one?
  19. SQL Server SELECT into existing table
  20. How to list all dates between two dates [duplicate]
  21. SQL Server sp_msforeachtable usage to select only those tables which meet some condition
  22. How to check if a stored procedure exists before creating it
  23. Scheduled run of stored procedure on SQL server
  24. SQL Server ORDER BY date and nulls last
  25. SQL Server variable columns name?
  26. Convert decimal time to hours and minutes
  27. SQL Query Where Column = ” returning Emoji characters 🎃 and 🍰
  28. FOR JSON PATH results in SSMS truncated to 2033 characters
  29. How Can I Detect and Bound Changes Between Row Values in a SQL Table?
  30. SQL Server error “Implicit conversion of because the collation of the value is unresolved due to a collation conflict.”

Leave a Comment