First time here? You are looking at the most recent posts. You may also want to check out older archives or the tag cloud. Please leave a comment, ask a question and consider subscribing to the latest posts via RSS. Thank you for visiting! (hide this)

Stored Procedures

There are 1 entries for the tag Stored Procedures

Code smells also in SQL server system tables and StoredProcs

Almost 2 months ago Steve Harman, showed a ugly character map used in a database field to store the week's working days. Today I came across something similar, or maybe even worse, since the super-smelly database field is used in some system SPs in SQL Server 2000. I found a few examples of inconsistencies and "strange" implementations but let's focus on just one system stored proc: sp_help_job. This SP is used to retrieve a list of jobs or, if called specifying a GUID, it returns 3 result sets with the steps and schedules of a single job. Let's see some examples: enabled, which can be...