No announcements
Found 1702509 threads
-
6 VotesFind Row Count in Table
Simple use the aggregate function count() .Answered | 6 Replies | 1693 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
Table row count
We can using Count() function to get row count values.Answered | 3 Replies | 1665 Views | Created by runnerpaul - Tuesday, August 20, 2013 2:30 PM | Last reply by Alisa Tang - Wednesday, August 21, 2013 1:07 PM -
3 Votes
Counting 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 | 4020 Views | Created by Code Lizard - Thursday, November 5, 2009 3:25 PM | Last reply by Phil Brammer - Thursday, November 5, 2009 8:23 PM -
0 Votes
Counting rows on table with TEXTIMAGE_ON
Select count(*) just gets 0, filtered or not.Answered | 4 Replies | 775 Views | Created by Jnana - Tuesday, February 17, 2015 7:00 PM | Last reply by Jnana - Wednesday, February 18, 2015 2:15 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 | 1108 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
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 | 705 Views | Created by JRStern - Tuesday, June 21, 2016 6:18 PM | Last reply by Stan210 - Tuesday, June 21, 2016 7:04 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 | 5528 Views | Created by ronsql - Saturday, June 18, 2011 1:47 PM | Last reply by gao.seng - Friday, June 24, 2011 3:45 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 | 891 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 -
3 Votes
Find first empty row in table?
Hello Robert, Please read this post: http://www.eggheadcafe.com/software/aspnet/35886615/find-first-empty-row-of-a-table.aspx.Answered | 2 Replies | 9297 Views | Created by Robert Crandal - Sunday, March 6, 2011 4:12 AM | Last reply by Graham Mayor - Sunday, March 6, 2011 3:23 PM -
8 Votes
COUNT OF ROWS
I just need one row.Answered | 9 Replies | 1504 Views | Created by susheel1347 - Friday, March 7, 2014 3:55 PM | Last reply by Murali dhar - Monday, March 10, 2014 12:20 AM -
2 Votes
finding number of records in a table without count *
Instead, the example uses the Window Function (OVER) to compute the sum of rows.Answered | 6 Replies | 3047 Views | Created by cameron10001 - Saturday, March 22, 2014 11:09 AM | Last reply by CarnegieJ - Sunday, March 23, 2014 12:15 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 | 771 Views | Created by Raghavendra Narayana - Thursday, November 15, 2018 12:10 PM | Last reply by Raghavendra Narayana - Thursday, November 15, 2018 1:21 PM -
0 Votes
finding the rows of multiple count on a specific column
2"; this tell us to pull just customers with more than two orders.Answered | 5 Replies | 3990 Views | Created by boobyy - Sunday, January 25, 2009 8:14 AM | Last reply by Hunchback - Sunday, January 25, 2009 3:46 PM -
1 Votes
how to count number of rows in table ??
Use Count property.Answered | 1 Replies | 1885 Views | Created by SSmadhu - Thursday, August 2, 2012 5:57 AM | Last reply by Adavesh - Thursday, August 2, 2012 6:05 AM -
0 Votes
Count all rows for all tables in a database...
Get the number of rows from the corresponding table on a linked server and place it in a variable.Answered | 9 Replies | 5621 Views | Created by ThadRizzi - Friday, July 23, 2010 12:29 AM | Last reply by ThadRizzi - Friday, July 23, 2010 2:24 AM -
1 Votes
Count of rows in all tables filtered by a column name
Try this out this will basically gives u the tablenames and rowcnt where their is no sink between same tables in both servers SELECT ...Answered | 5 Replies | 4927 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
No, you don't need the Row Count transform.Answered | 6 Replies | 5879 Views | Created by Mike Lora - Friday, April 2, 2010 1:49 PM | Last reply by johnwelch - Friday, April 2, 2010 3:30 PM -
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 | 31942 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
It requires a SSIS integer variable to be created and mapped which will store the count value.Answered | 3 Replies | 797 Views | Created by AmyBI - Tuesday, December 4, 2018 7:35 PM | Last reply by Visakh16 - Wednesday, December 5, 2018 11:02 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 | 1672 Views | Created by shiftbit - Tuesday, January 7, 2014 1:50 PM | Last reply by tracycai - Thursday, January 9, 2014 4:14 AM - Items 1 to 20 of 1702509 Next ›
No announcements
