如何在截断后从表中获取数据 [英] how to get back data from table after truncate

问题描述

我遗憾地在sql中截断了一些表，但我希望这些数据能够重新回到那个表中怎么做tat plz帮我解决..

I truncated some table in sql unfortunately, but i want those data to reback into that table how to do tat plz help me out..

推荐答案

http：// blog.sqlauthority.com/2010/03/04/sql-server-rollback-truncate-command-in-transaction/ [ ^ ]



http://stackoverflow.com/questions/4193402/how-to-recover -data-from-truncated-table [ ^ ]

这可能会对您有所帮助......

http://raresql.com/2012/04/08/how-to-recover-truncated-data-from-sql-server-without-backup/ [ ^ ]

This may help you...
http://raresql.com/2012/04/08/how-to-recover-truncated-data-from-sql-server-without-backup/[^]

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