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

Datatypes Confusion Expand / Collapse
Author
Message
Posted Tuesday, May 5, 2009 10:32 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Tuesday, May 11, 2010 2:15 AM
Points: 327, Visits: 364
Comments posted to this topic are about the item Datatypes Confusion
Post #710811
Posted Wednesday, May 6, 2009 7:03 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 8:20 AM
Points: 2,373, Visits: 2,726
Nice question. A simple explanation, but it requires attention to detail.

- webrunner


-------------------
"Operator! Give me the number for 911!" - Homer Simpson

"A SQL query walks into a bar and sees two tables. He walks up to them and says 'Can I join you?'"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html
Post #711020
Posted Wednesday, May 6, 2009 4:33 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Friday, January 22, 2010 11:18 AM
Points: 67, Visits: 4

i tested this on SQL Server 2000 and the answer was 60.
Post #711676
Posted Wednesday, May 6, 2009 10:14 PM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Tuesday, September 16, 2014 5:48 AM
Points: 3,241, Visits: 5,002
This type of tricky questions clicks the refresh button of mind.

Nice...


----------------------------------------------------------------------------------------------------------------------------------------------------------------------

Sometimes, winning is not an issue but trying.

You can check my BLOG here

Post #711750
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse