Advertisement

07.03.2008 at 01:37AM PDT, ID: 23536135
[x]
Attachment Details

Trigger Error

Asked by matrix_aash in MS SQL Server

Hi All,

I have two tables table_1 and history_table1

Table_1 contains column1,column2 and history_table1 contains column1,column2,modified_date,action.

I have written a trigger which will insert data into history_table1 about each updates,deletes and inserts taken place in table_1.

I have attached the sample insert trigger.

The problem I am having is that its conflicting with the constraint as column1 is a primary key and column2 is the forgein key.

Can anybody please help on the query on how to get round this problem?

Cheers.



Start Free Trial 
1:
2:
3:
4:
5:
6:
7:
8:

ALTER TRIGGER [insert_history] ON [dbo].[table_1] 
FOR INSERT
AS
INSERT History_table_1 (column1,column2
           ,[MODIFIED_DATE]
           ,[ACTION])
SELECT column1,column2, GETDATE(), 'INSERTED' 
FROM inserted
 
Keywords: Trigger Error
Title
1 SQL Query or Trigger
2 trigger
3 Instead of Trigger and NOT NULL const…
4 trigger question
5 PL SQL trigger
6 Trigger for forms
 
Loading Advertisement...
 
[+][-]07.03.2008 at 01:46AM PDT, ID: 21923672

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]07.03.2008 at 01:51AM PDT, ID: 21923693

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]07.03.2008 at 01:53AM PDT, ID: 21923704

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]07.03.2008 at 02:09AM PDT, ID: 21923761

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]07.03.2008 at 02:25AM PDT, ID: 21923800

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]07.03.2008 at 02:28AM PDT, ID: 21923812

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]07.03.2008 at 02:32AM PDT, ID: 21923829

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]07.03.2008 at 02:37AM PDT, ID: 21923843

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]07.03.2008 at 02:38AM PDT, ID: 21923847

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]07.03.2008 at 03:01AM PDT, ID: 21923930

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]07.03.2008 at 03:12AM PDT, ID: 21923965

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]07.03.2008 at 03:27AM PDT, ID: 21924022

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]07.03.2008 at 03:28AM PDT, ID: 21924026

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]07.03.2008 at 03:29AM PDT, ID: 21924030

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]07.03.2008 at 03:29AM PDT, ID: 21924033

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]07.03.2008 at 03:38AM PDT, ID: 21924067

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zone: MS SQL Server
Sign Up Now!
Solution Provided By: andycrofts
Participating Experts: 2
Solution Grade: B
 
 
[+][-]07.03.2008 at 05:30AM PDT, ID: 21924751

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_EXPERT_20070906