Re: SQL 2005 Trigger?

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: "Jens" <Jens@xxxxxxxxxxxxxxxx>
Date: 20 Dec 2006 03:27:39 -0800

Hi,

(untested)
, versuch das mal hier:

CREATE Trigger SomEtrigger On SomeTable
FOR INSERT
AS
BEGIN

INSERT INTO SomeOtherTable
(
NameColumn
)
SELECT
dbo.Split(OriginalNameColumn,' ')
FROM INSERTED

END

Mit der Funktion die man hier finden kann:

http://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=320221&SiteID=17

HTH, Jens K. Suessmeyer.

---
http://www.sqlserver2005.de
---

.

Prev by Date: Re: Effiziente Fallunterscheidung in Stored Procedure
Next by Date: Re: Effiziente Fallunterscheidung in Stored Procedure
Previous by thread: SQL Server 2005 Service Pack 2 CTP3 verfügbar!
Next by thread: Re: SQL Serverregistrierung über VPN-Tunnel
Index(es):
- Date
- Thread

Relevant Pages

Re: Mehrere Instanzen?
... -Schaffen von abgeschotteten System zur höheren Sicherheit ... HTH, Jens K. Suessmeyer. ...
(microsoft.public.de.sqlserver)
=?iso-8859-1?q?Re:_Invalid_SQL_l=E4uft_doch=3F?=
... einen Alias bringt Dir einen Syntaxfehler: ... HTH, Jens K. Suessmeyer. ...
(microsoft.public.de.sqlserver)
Re: SQL 2005
... ALTER LOGIN WITH PASSWORD= 'Something' UNLOCK ... HTH, Jens K. Suessmeyer. ...
(microsoft.public.de.sqlserver)
Re: Hallo NG
... Seite, einfach mal vorbeischauen;-) ... HTH, Jens K. Suessmeyer. ...
(microsoft.public.de.sqlserver)
Re: Certification
... google should be your friend allthe time before asking in the groups: ... HTH, Jens K. Suessmeyer. ...
(microsoft.public.sqlserver.clients)