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 «««123

Type lengths Expand / Collapse
Author
Message
Posted Tuesday, September 16, 2008 7: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
Rajan John (9/9/2008)
douglascfast (9/9/2008)
Did I miss something? If two columns are 1 in lengh, and the others are 9 "some text" and 14 "Some more text", then would not the count(*) give you 2 (1 length) 1(9 lenght) and 1(14 lenght).

I did this on my database and i got

Query1
-----------
2
1
1

Query2
-----------
4

Query3
-----------
2
1
1

Confused - - - as normal
Doug


I also got the same results. Anything missing?



As Ninja's_RGR'us points out 3,1,3. i.e. Question asks for total number of rows not the Counts returned by those rows.
Post #570227
Posted Friday, October 24, 2008 6:48 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Friday, October 15, 2010 8:23 AM
Points: 371, Visits: 437
I almost went 3,3,3 then took a look at the data types again before submitting .. tricky :)
Post #591154
Posted Thursday, March 4, 2010 7:57 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Monday, July 21, 2014 3:43 AM
Points: 1,939, Visits: 1,162
I got wrong.
But the question is good.


Malleswarareddy
I.T.Analyst
MCITP(70-451)
Post #876852
« Prev Topic | Next Topic »

Add to briefcase «««123

Permissions Expand / Collapse