Thursday, July 23, 2009
Decimal(18,2)?!?
16:55 | 
Posted by
Sean McCown
I just reviewed a script that had 3 major problems.
1. It created a #table and then immediately truncated it.
2. It passed in a var into the sp and then hardcoded the value a few lines later. The passed-in value will never be read.
3. It did the following operation.
Declare @var decimal(18,2)
Set @var = select count(*) from table
Really? Come on people let’s think about what we’re doing.
Watch my free SQL Server Tutorials at:
http://MidnightDBA.ITBookworm.com
Read my book reviews at:
www.ITBookworm.com
Blog Author of:
Database Underground – http://www.infoworld.com/blogs/sean-mccown
Follow my Twitter:
Labels:
Subscribe to:
Post Comments (Atom)
About Me
- Sean McCown
- I am a Contributing Editor for InfoWorld Magazine, and a frequent contributor to SQLServerCentral.com as well as SSWUG.org. I live with my wife and 3 kids, and have practiced and taught Kenpo for 22yrs now.
6 comments:
buy viagra meds online free sample pack of viagra homemade viagra generic viagra india viagra shelf life try viagra for free bought viagra fuerteventura viagra women viagra rrp australia cost what is generic viagra viagra no prescription viagra jokes try viagra for free canadian viagra
Your blog keeps getting better and better! Your older articles are not as good as newer ones you have a lot more creativity and originality now keep it up!
[url=http://www.ganar-dinero-ya.com][img]http://www.ganar-dinero-ya.com/ganardinero.jpg[/img][/url]
[b]La mejor web sobre ganar dinero[/b]
Hemos hallado la mejor guia en internet de como trabajo casa. Como fue de utilidad a nosotros, tambien les puede ser de utilidad a ustedes. No son unicamente formas de ganar dinero con su pagina web, hay todo tipo de metodos para ganar dinero en internet...
[b][url=http://www.ganar-dinero-ya.com][img]http://www.ganar-dinero-ya.com/dinero.jpg[/img][/url]Te recomendamos entrar a [url=http://www.ganar-dinero-ya.com/]Ganar-dinero-ya.com[/url][url=http://www.ganar-dinero-ya.com][img]http://www.ganar-dinero-ya.com/dinero.jpg[/img][/url][/b]
"Decimal(18,2)?!?" is the kind of article I love to find. I am extremely impressed with how well you researched this material. I think this is solid information and I agree.
--------------------------
Download iPoker to play poker.
I am so happy you took the time to make incredible Instead of working, I blog blog here. See you around
--------------------------
Celeb iPoker room
This is extremely impressive text. I like how you brought forward many clear viewpoints and I agree with many. Instead of working, I blog articles coaxes thought out of the reader from start to finish. I really like this.
--------------------------
Poker770 iPoker room & Juego dinero $50 & Poker Geld iPoker & Online Poker
Post a Comment