Trigger on Update MSSQL - 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

Trigger on Update MSSQL

Author

Topic

brizey
Starting Member

2 Posts

Posted - 2012-03-30 : 03:45:01

I need some help with creating my trigger, I want to run this query after any update in my gpsinfo table on my GPSNET database

AFTER UPDATE
AS
UPDATE [GPSNET].[dbo].[gpsinfo]
SET [GeoLocation] = geography::Point([latitude], [longitude], 4326)
GO

rajarajan
Starting Member

48 Posts

Posted - 2012-03-30 : 04:00:27

http://www.codeproject.com/Articles/25600/Triggers-Sql-Server

This will help you ..

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2012-03-30 : 04:54:29

quote:
Originally posted by brizey

I need some help with creating my trigger, I want to run this query after any update in my gpsinfo table on my GPSNET database

AFTER UPDATE
AS
UPDATE [GPSNET].[dbo].[gpsinfo]
SET [GeoLocation] = geography::Point([latitude], [longitude], 4326)
GO

I don't think it is MS SQL Server?

No, you're never too old to Yak'n'Roll if you're too young to die.

rajarajan
Starting Member

48 Posts

Posted - 2012-03-30 : 05:07:37

Its just a sample ..how to Create trigger

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources