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 7, 2008 9:42 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Friday, December 20, 2013 4:45 AM
Points: 236, Visits: 239
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 7, 2008 10:28 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, February 18, 2014 7:14 AM
Points: 1,344, Visits: 1,983
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


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Thursday, July 10, 2014 11:20 AM
Points: 1,888, Visits: 2,323
Good one!!


_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
Post #1398289
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse