June T-SQL Guru - Naomi brings us "How SQL Server Determines Type of the Constant"
It's time for our next June TechNet Guru winner!
ABOUT NAOMI: I am an IT professional with more than 15 years of experience in a variety of programming languages and technologies. I am a Microsoft Community Award Recipient and was Personality of the Year at the UniversalThread.com forum in 2008,2009,2010,2011.
Here is Naomi's winning article:
Here are all the June T-SQL winners (two were from Naomi):
|Transact-SQL Technical Guru - June 2013|
|Naomi N||How SQL Server Determines Type of the Constant||Richard Mueller: "A good recommendation to explicitly CAST values, with an example of possible consequences if you don't."|
|Naomi N||SET ANSI_PADDING Setting and Its Importance||Samuel Lester: "Outstanding contribution! I love the process of walking us through the debugging you performed. People who read this article gain an understanding of not only the SET ANSI_PADDING setting, but also how you arrived at discovering this as well as the technical resources available to ask in the MSDN forums. Very, very good!" Ed Price: "Very in depth article with great code formatting!" Richard Mueller: "This explains an issue I was not aware of. Well researched. Good to include a script to correct the situation."|
|Johnny Bell Jnr||SQL Server Result Set In An HTML Email||Richard Mueller: "Very instructive. I like this because similar techniques can be used for other applications." Samuel Lester: "Great article and very handy for sure. I'm a big fan of code generation through T-SQL as you're doing with the @HTML parameter. I use similar tricks often to generate code for other programming languages. Very good!" Ed Price: "The text does a great job setting up the code blocks!"|
Transact SQL was our second largest category with 9 submissions (4 from Naomi)! Naomi holds onto her title for a second month. Thanks go out to all our contributors... Kalman, Naomi, Sathyanarrayanan, and Johnny Bell! You made it tough on the judges to select from an excellent group! Please go check them all out here.
Here's an excerpt from the article:
The problem was stated as following:
produced 1000 while
gave an error "Arithmetic overflow error converting expression to data type numeric."
Read the rest here:
Also, for the July Guru competition, see TechNet Guru Contributions for July 2013.
Any questions or comments for Naomi?
Are you a Wiki Ninja? http://technet.com/wiki
- Ninja Ed