sql sequence - SQL Server Forums

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

General SQL Server Forums

New to SQL Server Programming

sql sequence

Author

Topic

Jeskit@hotmail.co.uk
Starting Member

20 Posts

Posted - 2007-12-18 : 12:01:27

hi

i've been asked to write a sql sequence for a database i'm building but i haven't been using SQL very long and i have no idea how to write a sequence. Does anyone know anything about sql sequences?

thanks

jessica

dinakar
Master Smack Fu Yak Hacker

2507 Posts

Posted - 2007-12-18 : 12:05:00

Explain what you mean by "sql sequence" perhaps with some sample data?

Dinakar Nethi
************************
Life is short. Enjoy it.
************************
http://weblogs.sqlteam.com/dinakar/

Jeskit@hotmail.co.uk
Starting Member

20 Posts

Posted - 2007-12-18 : 12:18:24

hi

sorry i meant triggers
sorry
jessica

dinakar
Master Smack Fu Yak Hacker

2507 Posts

Posted - 2007-12-18 : 12:19:54

Please explain the entire task that you are working on and the issue you are facing. I have no idea what you are asking..

Dinakar Nethi
************************
Life is short. Enjoy it.
************************
http://weblogs.sqlteam.com/dinakar/

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2007-12-18 : 12:22:31

Create Trigger {Your_Trigger} ON {Your_Table}
FOR/INSTEAD OF(when u want trigger to fire ) INSERT/UPDATE/DELETE (for what all actions you need to trigger the code below)
AS
.........
code here
.......

GO

Jeskit@hotmail.co.uk
Starting Member

20 Posts

Posted - 2007-12-18 : 12:25:07

hi

sorry, i have to implement a trigger which will audit the table to automatically log all changes made to data in two certain tables. the trigger needs to log new and old vbvalues of the data.

thanks
jessica

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2007-12-18 : 12:32:20

something like this. :-

CREATE TRIGGER TABLE_AUDIT ON {Table_Name}
FOR INSERT,UPDATE,DELETE
AS
IF EXISTS(SELECT * FROM INSERTED)
BEGIN
INSERT INTO New_Values
SELECT {fields} FROM INSERTED
END
IF EXISTS(SELECT * FROM DELETED)
BEGIN
INSERT INTO Old_Values
SELECT {fields} FROM DELETED
END
GO

Jeskit@hotmail.co.uk
Starting Member

20 Posts

Posted - 2007-12-18 : 12:41:40

hi

tried that it saying i'm missing BEFORE, AFTER or INSTEAD OF keyword
CREATE TRIGGER TABLE_AUDIT ON {Difficulty_ratings}
FOR INSERT,UPDATE,DELETE
AS
IF EXISTS(SELECT * FROM INSERTED)
BEGIN
INSERT INTO Difficulty_ratings
SELECT {Hoilday_code, Description_of_ratings} FROM INSERTED
END
IF EXISTS(SELECT * FROM DELETED)
BEGIN
INSERT INTO Difficulty_ratings
SELECT {Hoilday_code, Description_of_ratings} FROM DELETED
END
GO

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2007-12-18 : 12:51:33

[code]CREATE TRIGGER TABLE_AUDIT ON {Table_Name}
AFTER INSERT,UPDATE,DELETE
AS
BEGIN
IF EXISTS(SELECT * FROM INSERTED)
BEGIN
INSERT INTO New_Values
SELECT {fields} FROM INSERTED
END
IF EXISTS(SELECT * FROM DELETED)
BEGIN
INSERT INTO Old_Values
SELECT {fields} FROM DELETED
END
END
GO[/code]

Jeskit@hotmail.co.uk
Starting Member

20 Posts

Posted - 2007-12-18 : 12:57:00

nope still not working still saying missing BEFORE, AFTER or INSTEAD OF keyword
CREATE TRIGGER TABLE_AUDIT ON {Difficulty_ratings}
AFTER INSERT,UPDATE,DELETE
AS
IF EXISTS(SELECT * FROM INSERTED)
BEGIN
INSERT INTO Difficulty_ratings
SELECT {Hoilday_code, Description_of_ratings} FROM INSERTED
END
IF EXISTS(SELECT * FROM DELETED)
BEGIN
INSERT INTO Difficulty_ratings
SELECT {Hoilday_code, Description_of_ratings} FROM DELETED
END
GO

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2007-12-18 : 13:07:11

quote:
Originally posted by Jeskit@hotmail.co.uk

nope still not working still saying missing BEFORE, AFTER or INSTEAD OF keyword
CREATE TRIGGER TABLE_AUDIT ON {Difficulty_ratings}
AFTER INSERT,UPDATE,DELETE
AS
IF EXISTS(SELECT * FROM INSERTED)
BEGIN
INSERT INTO Difficulty_ratings
SELECT {Hoilday_code, Description_of_ratings} FROM INSERTED
END
IF EXISTS(SELECT * FROM DELETED)
BEGIN
INSERT INTO Difficulty_ratings
SELECT {Hoilday_code, Description_of_ratings} FROM DELETED
END
GO

CREATE TRIGGER TABLE_AUDIT ON Difficulty_ratings
AFTER INSERT,UPDATE,DELETE
AS
IF EXISTS(SELECT * FROM INSERTED)
BEGIN
INSERT INTO Difficulty_ratings
SELECT Hoilday_code, Description_of_ratings FROM INSERTED
END
IF EXISTS(SELECT * FROM DELETED)
BEGIN
INSERT INTO Difficulty_ratings
SELECT Hoilday_code, Description_of_ratings FROM DELETED
END
GO

Jeskit@hotmail.co.uk
Starting Member

20 Posts

Posted - 2007-12-18 : 13:10:53

nope still saying that i'm missing BEFORE, AFTER or INSTEAD OF keyword

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2007-12-18 : 13:16:08

try putting BEGIN END after CREATE?

refer this too

[url]http://msdn2.microsoft.com/en-us/library/ms189799.aspx[/url]

Jeskit@hotmail.co.uk
Starting Member

20 Posts

Posted - 2007-12-18 : 13:44:41

HI

Its still not working, its still saying i'm missing BEFORE, AFTER or INSTEAD OF keyword
CREATE TRIGGER TABLE_AUDIT ON Difficulty_ratings
BEGIN
AFTER INSERT,UPDATE,DELETE
AS
IF EXISTS(SELECT * FROM INSERTED)
INSERT INTO Difficulty_ratings
SELECT Hoilday_code, Description_of_ratings FROM INSERTED
END
BEGIN
IF EXISTS(SELECT * FROM DELETED)
INSERT INTO Difficulty_ratings
SELECT Hoilday_code, Description_of_ratings FROM DELETED
END
GO

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-12-18 : 14:07:16

Read the excellent SQL Server help file Books Online for syntax help.

E 12°55'05.25"
N 56°04'39.16"

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources