Triggers in SQL ver 6.5 and SQL ver 7.0

Triggers in SQL ver 6.5 and SQL ver 7.0

Post by Gina Geurgi » Sat, 20 Mar 1999 04:00:00



Hello,

I have a table called STUDENTS and STUDENTS_LOG.

I have created a TRIGGER on STUDENTS table that executes automatically when
I attempt to Insert or update the STUDENTS table.  The trigger adds a record
into STUDENTS_LOG using the INSERTED logical  table. This is to keep a
history of all modifications in the STUDENTS table.
------------------------------------
CREATE TRIGGER TRIG_STUDENT ON dbo.STUDENTS

FOR INSERT,UPDATE
AS

  INSERT INTO STUDENTS_LOG SELECT *  FROM INSERTED
-------------------------------------

STUDENTS table contains an IDENITY field.  I use a stored procedure to add a

other purposes.
STUDENTS_LOG table does not contain any IDENTITY fields

This operation worked fine with SQL ver 6.5



command in the TRIGGER

Why?

Thankyou for your time.

Gina Geurgis
The University of Queensland


 
 
 

1. How to Move my DAtabse from SQl 7Trial ver to SQl Server Full Ver

I had Installed BAckoffice. The sql version in that allows only 5 Connection. So I bought the full ver(SQL 7). I would like to know how do I move my databse to the newer ver. or upgrade to sql7 full version.

Atul Singh
Network Administrator

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

2. After a Sql Insert, Retrieving the last Identity??

3. Ver 6.5 SQL Server ERROR seen on 7.0: Losing DTC Service May Leave Orphaned Transactions (Q195542)

4. DLL Not Found After Install (using JRO)

5. Restoring data from ver 6 into ver 6.5

6. SQL SERVER ERROR

7. will SQL client ver 7 completely interoperate with SQL Server 6.5

8. Return value(s) from EXEC @SQL_STR

9. free or trial ver of Sybase SQL Anywhere ver 5

10. HELP: returnsrows after upgrade ver 6.5 to 7.0

11. ver 6.5 vs 7.0 Syntax err

12. Database Comparison Tool ( Ver 6.5 or 7.0 )

13. T SQL syntax - upgrading from ver 6.5 to 2000