Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

Conversion Expand / Collapse
Author
Message
Posted Tuesday, October 07, 2008 9:42 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, May 01, 2013 5:15 AM
Points: 236, Visits: 235
Like many who attempted the question, I got the right answer but possibly for the wrong reason. At first, I though truncation and implicit conversion would occur, but as 600,000 was not offered as pointed out by others, it was a simple process of elimination.
I shall have a read of BOL.
Good ques.
Post #581935
Posted Tuesday, October 07, 2008 10:28 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, May 13, 2013 2:04 AM
Points: 1,342, Visits: 1,946
bc (10/6/2008)
i hope a few people learned about this "gotcha" that puzzled me when i first came upon it in trying to answer another forum question. thanks
As I mentioned, I'd already encountered this before, but I too puzzled over it when I first saw it.

Definitely a good question.


Derek
Post #581984
Posted Wednesday, December 19, 2012 4:18 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Sunday, May 19, 2013 11:16 PM
Points: 1,061, Visits: 1,151
Good one!!
Post #1398289
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse