In several of my stored procedures I assign the default value of a parameter as -2147483648 (Int32.MinValue) as well as do comparisons on that value. How can one abstract that away to a global variable of sorts?
It would help me feel more confident that a typo hasn't occurred and that whoever maintains this database has one less thing to worry about. If this needs changing it would speed up the change process quite a bit (even though Redgate has a fantastic - free! - SQL Search tool 🙂 and change isn't my primary motivation in this)