一些记录会自动从aspnet_users表中的aspnetdb数据库中删除 [英] some records are automatically deleted from aspnetdb database in aspnet_users table

问题描述

嗨

这是Manjari。我在aspnetdb数据库中创建用户时遇到问题2-3次。通常它会创建但是有一段时间后会自动删除它。它不会每次都发生创建用户帐户。我想知道，一些记录是如何自动删除的。我已经检查了调度程序和触发器，因为确认。

请建议我正确的道路，为什么会这样...

任何帮助真的很明显。



谢谢，

Manjari

Hi
This is Manjari.I am facing the problem 2 -3 times while creating the users in aspnetdb database .Usually it creates but after sometime its got automatically deleted.It is not happening everytime while creating the users account.I am wondering,how some of the records are automaically deleted.I have checked the schedulers and triggers also because of the confirmation.
Please suggest me the right path,Why this is happening ...
Any help really appreciable.

Thanks,
Manjari

推荐答案

Ex-

在table_name上创建触发器trg_delete以进行删除

声明@id bigint;

select @ id = i.id from deleted d

as

begin

从table_name中删除id = @ id

结束



每当删除表中任何条件使用的情况。

Ex-
create trigger trg_delete on table_name for delete
declare @id bigint;
select @id=i.id from deleted d
as
begin
delete from table_name where id=@id
end

whenever delete table any key used where condition.

这篇关于一些记录会自动从aspnet_users表中的aspnetdb数据库中删除的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！