<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 Gyan Garg
»
TSQL
88 posts, Page 1 of 9
1
2
3
4
5
»
»»
TSQL
Rate Topic
Display Mode
Topic Options
Author
Message
gyanp.garg
gyanp.garg
Posted Wednesday, March 25, 2009 8:17 PM
SSC-Enthusiastic
Group: General Forum Members
Last Login: Tuesday, September 25, 2012 4:03 AM
Points: 185,
Visits: 52
Comments posted to this topic are about the item
TSQL
Post #683808
Marius Els
Marius Els
Posted Thursday, March 26, 2009 12:57 AM
SSC Veteran
Group: General Forum Members
Last Login: Wednesday, October 31, 2012 3:59 AM
Points: 215,
Visits: 166
Hi there
I work in a SQL 2000 developer edition. when I run the provided script, it runs successfully returning rows 1 through 6.
Only if I run the script, without the from subselect, does it return a conversion error.
Why is that?
Marius
Post #683865
gserdijn
gserdijn
Posted Thursday, March 26, 2009 1:02 AM
Ten Centuries
Group: General Forum Members
Last Login: Tuesday, April 23, 2013 8:00 AM
Points: 1,065,
Visits: 698
When the SELECT statement is compiled for the INSERT, the
first
value is implicitly taken as an INT. In the UNIONs, as each SELECT is added, they must match this data type.
If that is the correct explanation, would the next statement work?
Insert into test Select 'A' union Select 1;
(Answer: No)
Dutch Anti-RBAR League
Post #683868
calldebraj
calldebraj
Posted Thursday, March 26, 2009 1:21 AM
Grasshopper
Group: General Forum Members
Last Login: Tuesday, May 14, 2013 1:09 AM
Points: 23,
Visits: 102
Hi,
The answer given here is wrong.The correct answer will be
1
2
3
4
5
6
Thanks.
Post #683874
Balachandra
Balachandra
Posted Thursday, March 26, 2009 1:24 AM
SSCrazy
Group: General Forum Members
Last Login: Wednesday, June 13, 2012 1:23 AM
Points: 2,162,
Visits: 170
Hi
The given script will work in SQL Server 2000 giving the results 1,2,3,4,5,6.
In SQL Server 2008 it fails saying conversion failed when converting the varchar value 'A' to data type int.
Post #683876
arconen
arconen
Posted Thursday, March 26, 2009 2:05 AM
SSC Veteran
Group: General Forum Members
Last Login: Thursday, April 19, 2012 4:50 AM
Points: 284,
Visits: 52
In future must show the version of MS SQL Server in order to prevent a misunderstanding.
I answered right for version 2000, but for 2008 I made a mistake.
Post #683887
Mighty
Mighty
Posted Thursday, March 26, 2009 2:23 AM
SSCrazy
Group: General Forum Members
Last Login: 2 days ago @ 8:33 AM
Points: 2,723,
Visits: 987
On SQL 2005 it also works, so in that case answer c is the correct one.
Post #683893
Marius Els
Marius Els
Posted Thursday, March 26, 2009 2:42 AM
SSC Veteran
Group: General Forum Members
Last Login: Wednesday, October 31, 2012 3:59 AM
Points: 215,
Visits: 166
I'm glad to see my thinking (from a SQL 2000 point of view) was at least in line with some other folks as well.
Unfortunately this didn't get us the points
I agree: indicating the version of SQL the script was written in would have helped...
Post #683898
RichB
RichB
Posted Thursday, March 26, 2009 2:44 AM
Ten Centuries
Group: General Forum Members
Last Login: Today @ 4:24 AM
Points: 1,026,
Visits: 752
What a crap question.
Can someone adjust this, its pretty bad. Plain wrong, in fact.
Post #683899
karthik M
karthik M
Posted Thursday, March 26, 2009 2:55 AM
SSCrazy
Group: General Forum Members
Last Login: Tuesday, May 21, 2013 2:56 AM
Points: 2,008,
Visits: 2,469
I ran this script it in sql2000. it is working fine. it shows 1,2,3,4,5,6. so the correct answer is c.
karthik
Post #683907
« Prev Topic
|
Next Topic »
88 posts, Page 1 of 9
1
2
3
4
5
»
»»
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.
