No announcements
Found 1362506 threads
-
3 VotesCounting ROWS in a table.
It returns the same value for the number of rows in the table as does the COUNT(*) method.Answered | 11 Replies | 3917 Views | Created by Code Lizard - Thursday, November 5, 2009 3:25 PM | Last reply by Phil Brammer - Thursday, November 5, 2009 8:23 PM
-
6 Votes
Find Row Count in Table
Simple use the aggregate function count() .Answered | 6 Replies | 1582 Views | Created by CarlosVelaZen - Wednesday, December 24, 2014 1:50 AM | Last reply by Ahsan Kabir - Wednesday, December 24, 2014 11:00 PM -
0 Votes
Compare row count of two tables
IF OBJECT_ID('test1') IS NOT NULL drop table test1 IF OBJECT_ID('test2') IS NOT NULL drop table test2 go create table test1 (A ...Answered | 2 Replies | 744 Views | Created by Y a h y a - Tuesday, February 11, 2020 1:23 AM | Last reply by Rachel_Wang - Tuesday, February 11, 2020 5:17 AM -
0 Votes
Table row count
We can using Count() function to get row count values.Answered | 3 Replies | 1507 Views | Created by runnerpaul - Tuesday, August 20, 2013 2:30 PM | Last reply by Alisa Tang - Wednesday, August 21, 2013 1:07 PM -
0 Votes
Count rows on table
Hi Askyy, According to your description, you need to count the numbers of row when it's value equal to 'TITLE', right?Answered | 10 Replies | 1015 Views | Created by askyy - Tuesday, January 19, 2016 10:55 AM | Last reply by Charlie Liao - Monday, January 25, 2016 7:43 AM -
0 Votes
Counting rows on table with TEXTIMAGE_ON
Select count(*) just gets 0, filtered or not.Answered | 4 Replies | 703 Views | Created by Jnana - Tuesday, February 17, 2015 7:00 PM | Last reply by Jnana - Wednesday, February 18, 2015 2:15 PM -
0 Votes
Row count for all the tables in a Database?
The following page deals with row counting: http://www.sqlusa.com/bestpractices2005/alltablesrowcount/ Counting unique rows ...Answered | 6 Replies | 5449 Views | Created by ronsql - Saturday, June 18, 2011 1:47 PM | Last reply by gao.seng - Friday, June 24, 2011 3:45 PM -
1 Votes
Counting all the rows in a table
Hi Miguel, No, what I was talking about was to be able to use the Group By dialog and have no column to group by - that's to say, I'd just want to be able to count the ...Answered | 4 Replies | 3367 Views | Created by Christopher Webb - Wednesday, August 7, 2013 10:10 PM | Last reply by Miguel.Llopis - Thursday, January 23, 2014 4:35 AM -
0 Votes
How to getting the row count for all tables in the database
Check this blog post How to get information about all databases without a loop that contains several scripts providing this information.Answered | 4 Replies | 1148 Views | Created by Amer AL_Tahawy - Saturday, January 16, 2016 5:33 PM | Last reply by Uri Dimant - Sunday, January 17, 2016 7:34 AM -
3 Votes
dynamic SQL to list all tables in a database with row count for each table
First, while the row counts will almost always be exactly correct, you might occasionally get one that is incorrect.Answered | 3 Replies | 31468 Views | Created by Knot - Wednesday, August 22, 2012 2:41 AM | Last reply by Tom Cooper - Wednesday, August 22, 2012 4:42 AM -
0 Votes
Row count
No, you don't need the Row Count transform.Answered | 6 Replies | 5762 Views | Created by Mike Lora - Friday, April 2, 2010 1:49 PM | Last reply by johnwelch - Friday, April 2, 2010 3:30 PM -
0 Votes
How to write a cursor for Row Count
Hi Cherukuri19, You don't have to loop each table to get the row count.Answered | 2 Replies | 740 Views | Created by SQLCHERU - Wednesday, May 20, 2015 10:11 AM | Last reply by Eric__Zhang - Thursday, May 21, 2015 6:23 AM -
0 Votes
Table properties row count differs from sys.dm_db_partition_stats
Hi, They returns the row counts are different because SELECT COUNT(*) FROM tablename will perform a table scan to obtain the ...Answered | 2 Replies | 1496 Views | Created by shiftbit - Tuesday, January 7, 2014 1:50 PM | Last reply by tracycai - Thursday, January 9, 2014 4:14 AM -
0 Votes
What's the best way to count rows in a memory table?
For regular tables you can get a quick row count from sys.partitions or by using sp_spaceused.Answered | 2 Replies | 624 Views | Created by JRStern - Tuesday, June 21, 2016 6:18 PM | Last reply by Stan210 - Tuesday, June 21, 2016 7:04 PM -
2 Votes
Measure Count Rows - If Condition - Multiple Tables
'Met Objective Count') is evaluated within the context of each row in this virtual Incident table which means that only the related, qualifying Apparatus ...Answered | 12 Replies | 1934 Views | Created by bvanscoy678 - Friday, November 7, 2014 7:04 PM | Last reply by Michael Amadi - Wednesday, June 3, 2015 12:37 PM -
8 Votes
COUNT OF ROWS
CountRows("Datasetname") will give your count of rows in dataset (total rows) If you want count of values in a particulat ...Answered | 9 Replies | 1390 Views | Created by susheel1347 - Friday, March 7, 2014 3:55 PM | Last reply by Murali dhar - Monday, March 10, 2014 12:20 AM -
0 Votes
Row count
If in control flow you can use sql statement (COUNT(*)) to get row count and save it in a variable.Answered | 3 Replies | 685 Views | Created by AmyBI - Tuesday, December 4, 2018 7:35 PM | Last reply by Visakh16 - Wednesday, December 5, 2018 11:02 AM -
0 Votes
Rowcount of all Tables - showing multiple rows per Table - Count not matching
https://stackoverflow.com/questions/428458/counting-rows-for-all-tables-at-once Raghavendra NarayanaAnswered | 2 Replies | 699 Views | Created by Raghavendra Narayana - Thursday, November 15, 2018 12:10 PM | Last reply by Raghavendra Narayana - Thursday, November 15, 2018 1:21 PM -
1 Votes
Count of rows in all tables filtered by a column name
Try this - Tables with row count.Answered | 5 Replies | 4694 Views | Created by duanewilson - Wednesday, August 22, 2012 7:27 PM | Last reply by Santhosh H - Thursday, August 23, 2012 5:54 AM -
0 Votes
row count
Do you mean the number of rows removed by a TRUNCATE statement?Answered | 3 Replies | 7339 Views | Created by KIRAN KUAMR - Monday, June 20, 2011 11:52 AM | Last reply by Dan Guzman - Monday, June 20, 2011 12:06 PM - Items 1 to 20 of 1362506 Next ›
No announcements
