CODEWITHSUNDEEP
sqlsql-server
Mufasil
Mufasil

Reputation: 231

trigger after insertion method

I am trying to built trigger in which when user delete a row after deleted user will able to view the row which he deleted.

i have tried my coading is follows please help.

create trigger insertion
before insert on client
for each row
as
select * from client

Upvotes: 0

Views: 53

Answers (3)

muhmud
muhmud

Reputation: 4604

delete from [<YourTable>] output deleted.*
/* where ... */

Upvotes: 1

www
www

Reputation: 4391

Try this:

create trigger deltrig 
on client 
for delete 
as 
   select deleted

Upvotes: 1

Frederic
Frederic

Reputation: 1028

isnt something like this what you want?

create table #deleted(nr int)
create table #teste_d(nr int)
insert into #teste_d 
values(1),(2),(3)

delete from #teste_d
OUTPUT deleted.nr INTO #deleted
where nr = 2

select * from #deleted

drop table #deleted
drop table #teste_d

the resultset would be what was deleted

or if you really want to use trigger should be instead delete or update

you should do something like

 insert into ##Data_deleted (col1,col2,...)
 select col1,col2,... from deleted

Upvotes: 0

Related Questions