May 16, 2011 at 9:37 am
it's quite interesting as to what sometimes seems quite simple often isn't.
The GrumpyOldDBA, you are soo right, LOL
May 16, 2011 at 9:38 am
simflex-897410 (5/16/2011)
it's quite interesting as to what sometimes seems quite simple often isn't.The GrumpyOldDBA, you are soo right, LOL
As a side question. Why do you want that column to only hold certain characters?
May 16, 2011 at 10:17 am
That's actually a good question that I actually asked the users who told us that they all their maintenance items do not contain ALL numeric values.
They further stated that some vendor FTPs these names to them and that sometimes, the names are numeric which are invalid because they can't associate them with any hardware.
Even though they have instructed their data entry folks to NOT enter those numbers, they want to have extra protection by adding Contraints check on the columname.
May 16, 2011 at 1:14 pm
I so love following this type of post because it's real world practical stuff that it's good to know as who knows what the business/developers are going to throw at you next!
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
Viewing 4 posts - 16 through 18 (of 18 total)
You must be logged in to reply to this topic. Login to reply