PLEASE HELP - Trigger For Duplicate Rows

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

PLEASE HELP - Trigger For Duplicate Rows

Author

Topic

mary H
Starting Member

32 Posts

Posted - 2008-10-09 : 04:43:25

I need a trigger to prevent duplicate rows. I dont have any experience with MySQL.

Any help ?

elancaster
A very urgent SQL Yakette

1208 Posts

Posted - 2008-10-09 : 04:47:17

quote:
Originally posted by mary H

I need a trigger to prevent duplicate rows. I dont have any experience with MySQL.

...you should note, this is a forum for Microsoft SQL Server. perhaps you would be better advised to post on a MySQL forum?

Em

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-10-09 : 05:10:18

one such forum is present at

www.dbforums.com

mary H
Starting Member

32 Posts

Posted - 2008-10-09 : 07:14:51

quote:
Originally posted by visakh16

one such forum is present at

www.dbforums.com

Do you know how to create the trigger in sql server?

Any help would be much appreciable!!

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-10-09 : 12:13:14

quote:
Originally posted by mary H

quote:
Originally posted by visakh16

one such forum is present at

www.dbforums.com

Do you know how to create the trigger in sql server?

Any help would be much appreciable!!

yup. but you told your db is MySQL. in sql it will like

CREATE TRIGGER TriggerName
ON TableName
{FOR/AFTER/INSTEAD} OF {INSERT/UPDATE/DELETE}
AS
BEGIN
...
....Body
...
END

books online should be your first reference for getting syntax helps

http://doc.ddart.net/mssql/sql70/create_8.htm

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources