如何获取数据库中表的修改数据 [英] How to get modified data of a Table in a Database

问题描述

朋友，

有一个数据库.在那我们有10个表.每天我都可以在某些表中插入和删除数据.所以我的问题是...
我今天想知道，今天修改了哪个表，今天又添加了什么数据....为此，我需要查询

hi friends,

There is a Database. In that we have 10 Tables. Daily i can insert and delete the data in some tables.So My Question is...
I want to know today, which table is modified and what is the data added today.... For this i need query

推荐答案

试试这个

SELECT OBJECT_NAME(OBJECT_ID) AS DatabaseName, last_user_update,*
FROM sys.dm_db_index_usage_stats
WHERE database_id = DB_ID( 'DbName') 

DbName =您的数据库名称

DbName = your database name

您可以通过服务器日志来做到这一点，但这将是锤子.
我会将DateTime字段添加到所有表记录中，并使用它来查询修改后的记录.

You could do it via the server logs, but that would be a sledgehammer to crack a nut.

I would add a DateTime field to all table records and use that to query the modified records.

这篇关于如何获取数据库中表的修改数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！