<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
Article Discussions
»
Article Discussions by Author
»
Discuss content posted by Yousaf Khan
»
concatenation
36 posts, Page 2 of 4
««
1
2
3
4
»
»»
concatenation
Rate Topic
Display Mode
Topic Options
Author
Message
gaminik1
gaminik1
Posted Tuesday, August 21, 2012 6:09 AM
Say Hey Kid
Group: General Forum Members
Last Login: Friday, April 26, 2013 5:51 AM
Points: 688,
Visits: 162
Thanks for the question. I ran in to a similar situation while creating a query last week.
Post #1347739
CELKO
CELKO
Posted Tuesday, August 21, 2012 6:20 AM
SSCommitted
Group: General Forum Members
Last Login: Tuesday, January 15, 2013 11:11 AM
Points: 1,945,
Visits: 2,782
this is why we use || in ANSI Standard SQL for concatenation.
Books in Celko Series for Morgan-Kaufmann Publishing
Analytics and OLAP in SQL
Data and Databases: Concepts in Practice
Data, Measurements and Standards in SQL
SQL for Smarties
SQL Programming Style
SQL Puzzles and Answers
Thinking in Sets
Trees and Hierarchies in SQL
Post #1347742
sestell1
sestell1
Posted Tuesday, August 21, 2012 6:31 AM
SSC Eights!
Group: General Forum Members
Last Login: Today @ 11:36 AM
Points: 837,
Visits: 1,219
Nice question, and a nice example showing that data type issues don't always result in an error. Implicit conversion isn't always your friend.
Post #1347744
sknox
sknox
Posted Tuesday, August 21, 2012 7:02 AM
Ten Centuries
Group: General Forum Members
Last Login: Tuesday, May 21, 2013 9:31 AM
Points: 1,041,
Visits: 1,356
Prassad Dabbada V R (8/21/2012)
I thought it will conevert everything to int. As the expression eveluates from right to left so from the right first plus will return 121 (120 will be converted to int) and so on and so forth.
but unfortunately my guess is wrong.
No, expressions evaluate from
left
to
right
.
I got it wrong because I'm so used to shortcutting the addition of 3 numbers in my head that I for some reason thought SQL Server could do the same. Too early in the morning, not enough coffee, {{insert additional generic excuse}}.
Post #1347761
Error Handler
Error Handler
Posted Tuesday, August 21, 2012 7:28 AM
SSC-Addicted
Group: General Forum Members
Last Login: Today @ 8:11 AM
Points: 456,
Visits: 157
Good question..! I m woundering why almost 50% attempts are wrong.
Best,
Naseer Ahmad
SQL Server DBA
Post #1347785
Toreador
Toreador
Posted Tuesday, August 21, 2012 7:30 AM
Ten Centuries
Group: General Forum Members
Last Login: Friday, May 17, 2013 9:52 AM
Points: 1,356,
Visits: 4,761
sestell1 (8/21/2012)
Implicit conversion isn't always your friend.
Implicit conversion isn't
ever
your friend!
Post #1347786
Divine Flame
Divine Flame
Posted Tuesday, August 21, 2012 7:49 AM
Ten Centuries
Group: General Forum Members
Last Login: Today @ 5:48 AM
Points: 1,076,
Visits: 1,922
Nice question
. Thanks.
- Divine Flame
Post #1347798
EL Jerry
EL Jerry
Posted Tuesday, August 21, 2012 7:57 AM
Hall of Fame
Group: General Forum Members
Last Login: Thursday, May 02, 2013 3:45 PM
Points: 3,748,
Visits: 928
Nice question, learned something new today. I was quite sure the answer would be 251, but then I remembered data type precedence may be tricky.
Toreador (8/21/2012)
sestell1 (8/21/2012)
Implicit conversion isn't always your friend.
Implicit conversion isn't
ever
your friend!
Implicit conversion isn't
even
your friend!
"El" Jerry.
"A watt of Ottawa" - Gerardo Galvan
Post #1347804
chgn01
chgn01
Posted Tuesday, August 21, 2012 8:43 AM
Say Hey Kid
Group: General Forum Members
Last Login: Today @ 1:05 PM
Points: 703,
Visits: 694
good and easy question, thanks
--------------------------------------
"Stay Hungry, Stay Foolish." ― Jobs
“Everything has beauty, but not everyone sees it.” ― Confucius
Post #1347826
KWymore
KWymore
Posted Tuesday, August 21, 2012 8:48 AM
SSCrazy
Group: General Forum Members
Last Login: Today @ 10:59 AM
Points: 2,579,
Visits: 1,537
Nice question about the basics. Thanks!
Post #1347832
« Prev Topic
|
Next Topic »
36 posts, Page 2 of 4
««
1
2
3
4
»
»»
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
