get the count of rows all tables based on created date (Month or year ) in SQL Server

Question

get the count of rows all tables based on created date (Month or year ) in SQL Server

ramazan orhan 20

how can find the count of rows all tables based on created date (Month or year ) in SQL Server

LiHongMSFT-4306 31,566 Reputation points

2024-10-24T02:07:47.0466667+00:00

Hi @ramazan orhan

Not quite understand what you mean, please clarify your request with more details or some simplified examples.
Olaf Helper 47,436 Reputation points

2024-10-24T04:36:38.5933333+00:00

What for a "created date"? Do you mean the table has a column with timestamp, when the record was inserted?

Please post table design as DDL, some sample data as DML statement and the expected result.

Accepted answer

0 additional answers

Your answer

LiHongMSFT-4306 31,566 Reputation points

2024-10-24T02:07:47.0466667+00:00

Hi @ramazan orhan

Not quite understand what you mean, please clarify your request with more details or some simplified examples.
Olaf Helper 47,436 Reputation points

2024-10-24T04:36:38.5933333+00:00

What for a "created date"? Do you mean the table has a column with timestamp, when the record was inserted?

Please post table design as DDL, some sample data as DML statement and the expected result.

Answer 1

Erland Sommarskog 121.4K MVP Volunteer Moderator

Your question is not very clear.

But if the question is: How can I get a count of rows added to each table per month of year, the answer is that you can't in the general case, since this is nothing that SQL Server tracks out of the box.

But it is not uncommon when you design tables, that you have an auditing column named CreateTime or something of the kind that defaults to sysdatetime() or getdate() and which never changes. So if your tables have such a column, you can get this information this way.

Share via

get the count of rows all tables based on created date (Month or year ) in SQL Server

0 additional answers

Your answer