See why your stored procedures should use OUTPUT and SELECT for data, and use RETURN only for error or status codes.

I talk about problems that can result from "problematic" characters in entity names.

Find out why you should always specify lengths for declarations of variable types like varchar.