Good day everyone!

I have a problem with a trigger.

I created a trigger to insert the current date into a filed if no date as
been specified. For some reason it does not work.

Here is how it look:

CREATE TRIGGER GETDATE ON docsadm.PROFILE
FOR INSERT,UPDATE
AS

UPDATE DOCSADM.PROFILE
SET DOCNAME = 'Document No.' + ' ' + CONVERT(varchar(24), (DOCNUMBER))
WHERE DOCNAME = ''

DECLARE @MYDATE DATETIME
DECLARE @MYSTRING VARCHAR(11)
SELECT @MYSTRING = CONVERT(VARCHAR, GETDATE())
SELECT @MYDATE = CONVERT(DATETIME, @MYSTRING)

UPDATE DOCSADM.PROFILE
SET document_date = @MYDATE
WHERE document_date = 'JAN 1 1753'

Can anyone tell me why it does not work?
If I place the trigger in it freeze the application.



Thanks




MS Sql Server LazyDBA home page