Thursday, July 23, 2009

Decimal(18,2)?!?

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:

http://twitter.com/MidnightDBA

6 comments:

Anonymous said...

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

Anonymous said...

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!

Anonymous said...

[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]

Poker said...

"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.

Holdem Play Online said...

I am so happy you took the time to make incredible Instead of working, I blog blog here. See you around
--------------------------
Celeb iPoker room

Poker said...

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

About Me

My Photo
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.
View my complete profile

Labels

Blogumulus by Roy Tanck and Amanda Fazani

Page Views