Unanswered: Just want to make sure (declare data type)
I've reviewed the books on line looking to see if SQL Server 2005 would now include a feature that Oracle has for years. When you declare a variable in a procedure, function, etc you can declare them as a particular table and column type. Example:
ghdep2 is the table and ssndependentid is the column. This is great because I'll never run in to a truncation issue as the variable will always be whatever the table is. This may slow things down a bit doing that sort of check but I don't care.
I just want to confirm that I can't do this in SQL 2005. All signs point to no.
Actually, in this case it would be the other way around. It is always changing the database for the application that breaks procedures on this end. Developers here have no idea what a dependency is I guess.
Either way, I'm over it. Sometimes, it is a nice option to have.