Need help on trigger for delete

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

Need help on trigger for delete

Author

Topic

Delinda
Constraint Violating Yak Guru

315 Posts

Posted - 2010-06-23 : 22:59:10

I've table as follow,


CREATE TABLE [dbo].[DERTicket_201106](
	[DCout] [varchar](20) NOT NULL,
	[TickP] [varchar](20) NOT NULL,
	[TickN] [varchar](100) NOT NULL,
	[TID] [varchar](20) NOT NULL,
	[RID] [varchar](20) NOT NULL,
 CONSTRAINT [DERTicket_201106_P01] UNIQUE NONCLUSTERED 
(
	[TickN] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY];

CREATE TABLE [dbo].[DERTicketHist_201106](
	[DCout] [varchar](20) NOT NULL,
	[TickP] [varchar](20) NOT NULL,
	[TickN] [varchar](100) NOT NULL,
	[TID] [varchar](20) NOT NULL,
	[RID] [varchar](20) NOT NULL,
 CONSTRAINT [DERTicketHist_201106_P01] UNIQUE NONCLUSTERED 
(
	[TickN] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY];

My question is,
1. How to Create Trigger for Delete in DERTicket_201106
2. As a result, this trigger will save any delete row in DERTicket_201106, and saved into DERTicketHist_201106

Need help

pk_bohra
Master Smack Fu Yak Hacker

1182 Posts

Posted - 2010-06-23 : 23:29:16

I feel like this is homework.

I didn't do much homework during my college days. So doing one for you now

Create trigger Trg_DERTicket_201106
on DERTicket_201106
After delete
as
Begin
Insert into [DERTicketHist_201106]
select * from deleted
end

I am here to learn from Masters and help new bees in learning.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources