This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(140.8, 75%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESR%3C/text%3E%3C/svg%3E)
Hi Expert,
Have loaded data in table for 2 times in a week without date dimension table or last extracted date ... how will i identify last refresh date and current refresh date in sql server
create table emp(employee varchar(23),Age varchar(23),Salary varchar(23))
insert into emp('Test1','23','10')
insert into emp('Test2','25','20')
insert into emp('Tes3','27','30')
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(259.20000000000005, 98%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERC%3C/text%3E%3C/svg%3E)
To identify the last refresh date you can check with a query on it.
SELECT name, modify_date
FROM sys.tables
WHERE name = 'emp';
This will help to modify date
For identifying the current refresh date :
You can use the current date and time from the GETDATE() function:
SELECT GETDATE() AS CurrentRefreshDate;
Both codes will help you to do this.
Hi,
You can take a look at the answers below. If it can help you, please accept it.
To identify the last refresh date you can check with a query on it. SELECT name, modify_date FROM sys.tables
Sorry, this is plain wrong. modify_date gives you the most recent schema change on the table, but it says nothing about when data was changed.
If that is all the data you have, the answer is you don't. You will need to arrange for this by adding a datetime column that defaults to sysdatetime() or similar.
I heard about something called changed table ... how about that
There is a function CHANGETABLE which is part of Change Tracking. But Change Tracking only tracks that something has changed, not when.
You may be thinking of temporal tables. With a temporal tables, updated and deleted rows are automatically saved in a history table, and there is specific syntax so you can query how the data was at a certain point in time. Whether that fits your scenario, I don't know. Your question is a bit vague.
sure can you give me an example for this on my query please CHANGETABLE
To be able to use CHANGETABLE, you first need to configure Change Tracking, and I can't see that it is applicable to your case. If you want to learn about the function, mr Google can help you. Which is where I would need to go, if I would have to use it myself; I don't know it by heart. So you may just try yourself.
Any other suggestion from other experts on CHANGETABLE please