Help with MSSQL 2005 Trigger

[Soa]

Hello all, I want to know if such a Trigger can change the X Y Z coordinations from a new Player?

I am not that good with MSSQL so I hope someone can help me with the Trigger.

-- ================================================
-- Template generated from Template Explorer using:
-- Create Trigger (New Menu).SQL
--
-- Use the Specify Values for Template Parameters 
-- command (Ctrl-Shift-M) to fill in the parameter 
-- values below.
--
-- See additional Create Trigger templates for more
-- examples of different Trigger statements.
--
-- This block of comments will not be included in
-- the definition of the function.
-- ================================================
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:		<Soa>
-- Create date: <20.11.2008>
-- Description:	<KalOnline Trigger v1>
-- =============================================
CREATE TRIGGER Startpoint 
   ON  Player
   AFTER INSERT
AS 
BEGIN
	-- SET NOCOUNT ON added to prevent extra result sets from
	-- interfering with SELECT statements.
	SET NOCOUNT ON;
UPDATE X, Y, Z
SET X = 225800, Y = 310515, Z = 45028
    -- Insert statements for trigger here

END

Plz help me with this


thx Soa

 

[Soa]

noone?

 

[crosenblum]

trigger's are a painful method in kal databases...

For example, a year ago, we tried to use a trigger on logins, and because of the way the server software is setup, using trigger's may not be very wise... because of hidden issues related to refferential integrity or foreign key relationships...

Might be easier to use a stored procedure...

 

[Soa]

so can u exlain me how to change the start coordinates for a new player?
Is it possible?