Geeks With Blogs
Denis Pitcher Denis Pitcher's Tech Blog

As I jump back into some SQL Server development, I've come across a couple things that I wish were features in SQL Server.

One is that when developing many stored procedures or functions, it has always been a pet peeve of mine that SQL Server basically lists every one together.  This is a bit cumbersome as if you are developing functions for a specific purpose, you are unable to group them together (except by schema, which is not what I'm looking for) so that it is easier to find them later.  A simple sub categorization based upon creating sub folders in the function folders would be an ideal and simple solution.

The other thought I'd like to express is the inability to create global variables.  There are times when one would like to be able to set global constants to be utilized in multiple procs/functions so that if they ever need to change you only have to change one spot rather then every sproc/function.  I'm uncertain as to why this design component was left out however I can at least make do with the workaround of creating a parameterless function to act as the constant by naming it and having it return the desired value, that way I only need to change the function to impact all sprocs/functions that call it.

Less then ideal, but it'll do.  Hopefully with the next upgrade, Microsoft will consider the usefulness of these suggestions.

Posted on Wednesday, January 24, 2007 2:59 PM | Back to top

Comments on this post: SQL Server Wish List

# re: SQL Server Wish List
Requesting Gravatar...

For the second wish list - I would say use a table and store your values in the table and write a function fetch those values, why need a added functionality.

- Girish
Left by Girish on Dec 16, 2008 6:31 PM

# re: SQL Server Wish List
Requesting Gravatar...
How about per database messages....
When you add messages with sp_addmessage, they are added to the master db.
Would be nice to back up custom messages with db.

Left by rob on Dec 08, 2009 11:05 PM

# re: SQL Server Wish List
Requesting Gravatar...
Include an option in SQL Server Management Studio under Stored Procedure Filters window, allowing the user to filter on 'Content' i.e. Where sproc content contains/does not contain/equals: 'xxx'.

This would allow filtering all sprocs where table/view/object/string (etc) [xyz] is referenced in the text, a feature sorely missing from current versions.
Left by Douglas Lund on Oct 28, 2011 6:21 AM

Your comment:
 (will show your gravatar)

Copyright © Denis Pitcher | Powered by: