如何查找今天将在sql表中插入哪些数据 [英] how to find which data will be inserted in today in sql tables

问题描述

你好，

如何查找今天将在sql表中插入哪些数据.但是没有日期列和普通列.

但是我怎么知道结果

hello,

how to find which data will be inserted in today in sql tables. But there is no date column and common column.

But how i know that result

推荐答案

所有事务都记录在MS SQL Server中，您可以使用事务日志文件查看器查看和撤消它们. >
但其中有些非常昂贵，有些存在兼容性问题，因此请自己寻找合适的一款:

http://www.red-gate.com/products/dba/sql-log-rescue / [ ^ ]

http://www.apexsql.com/sql_tools_log.aspx [

all of the transactions are logged in MS SQL server and you can see and undo them with a transaction log file viewer.

but some of them are very expensive and some have compatibility problems so search for suitable one for yourself :

http://www.red-gate.com/products/dba/sql-log-rescue/[^]

http://www.apexsql.com/sql_tools_log.aspx[^]

如果表中没有日期时间列，则你不走运，你做不到.

您可以创建一个表，并在其中放置每个表的最后一个行号，表名和日期时间(每天的午夜)，然后查询该表并与当前的最后一个行号进行比较.

If you don''t have a datetime column in your tables then you are out of luck, you can''t.

You can create a table and put the last row number, tablename and datetime (midnight each day) for each table in that and query that and compare with the current last row number.

您可以创建触发器以按触发器查找每天要插入哪些数据

You Can Create Trigger To find which data will be inserted in every Day By Trigger

这篇关于如何查找今天将在sql表中插入哪些数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！