获取已删除的id表单 [英] getting deleted id form table

问题描述

我有一张桌子：



桌子：

id姓名电子邮件

1 kapil k @ d .com

2 smith [e-mail]

3 jhon [e-mail]

4 scahin [e-mail]




现在让我抓住身份证：3





和out put：

id name email

1 kapil [e-mail]

2 smith [e-mail]

4 scahin [e-mail]





现在怎么能得到我删除的id。 $>


MSSQL中的查询

解决方案

您必须将已删除的ID存储到某个临时表中，以便您可以获得它回来了。请参见 http： //blog.sqlauthority.com/2007/10/01/sql-server-2005-output-clause-example-and-explanation-with-insert-update-delete/ [ ^ ]

I have a table:

table:
id name email
1 kapil [e-mail]
2 smith [e-mail]
3 jhon [e-mail]
4 scahin [e-mail]


now let I deteled id: 3


and out put:
id name email
1 kapil [e-mail]
2 smith [e-mail]
4 scahin [e-mail]


Now how can get which "id" I had deleted.

query in MSSQL

解决方案

You have to store the deleted id into some temp table so that you can get it back later. See http://blog.sqlauthority.com/2007/10/01/sql-server-2005-output-clause-example-and-explanation-with-insert-update-delete/[^]

这篇关于获取已删除的id表单的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！