Ask a Question related to Microsoft SQL / MS SQL Server, Design and Development.
-
Elisabeth Smith #1
Trigger key
Hi,
I need to create a insert trigger so that when a new row
is inserted in table A then the same row is inserted in
table B on a remote server. The problem is table A has no
primary key or any kind of unique field that I could use
as a reference. We can't create an artificial PK because
that would involve too much work in changing SP's that
populate / access table A.
Does anyone know how to grab the last inserted row when
there is no unique / PK field defined on the table?
Cheers
Elisabeth
Elisabeth Smith Guest
-
XML.TRIGGER
Hello. I have an XML connector that I'm using a tigger event on. I was wondering if anyone knows a way for me to check when this completes. I... -
Events don't trigger
In my C# code I am finding all of the open IE windows in a loopand assigning their HWND to an object or this: ... -
Trigger
I have three tables: class - table of classes ---------- classID className classtypeID classtype - table of class types -------------- -
An trigger question
Hi,all: I want to create some trigger on an important database,my database is IDS2000. My question is: If exist a way to limit me only can create... -
Trigger Help
I have a trigger (code below). Where do I put in IF statements to kick off the CASE? I put in a commented out example of the IF I want to do in...
Reply With QuoteSimilar Questions and Discussions
Posting Permissions
- You may not post new threads
- You may post replies
- You may not post attachments
- You may not edit your posts
