> I am a new with MS SQL and reading documentation I didn't found way how to
> implement stored procedure which will set present date-time (GetDate()) in
> some record datetime field on insert event (primary key is not autoinc - I
> solve probem with autoinc). Something like this Interbase trigger:

> Triggers on Table SOMETABLE:
> TRIGGERNAME, Sequence: 0, Type: BEFORE INSERT, Active
> as begin  new.SOMEDATE = "now"; end

> Help, please !

> Sinisa

> > I am a new with MS SQL and reading documentation I didn't found way how to
> > implement stored procedure which will set present date-time (GetDate()) in
> > some record datetime field on insert event (primary key is not autoinc - I
> > solve probem with autoinc). Something like this Interbase trigger:

> > Triggers on Table SOMETABLE:
> > TRIGGERNAME, Sequence: 0, Type: BEFORE INSERT, Active
> > as begin  new.SOMEDATE = "now"; end

> > Help, please !

> > Sinisa

> If this were not a TRIGGER and done as a normal Stored procedure using
> MS SQL
> it would be something like this:

> PROCEDURE Add_Customer
>           @Customer_ID_int INT,
>           @Customer_First_Name_vch VARCHAR(50),
>           @Customer_Last_Name_vch VARCHAR(50),
>           @Customer_Email_Address_vch VARCHAR(50

> AS

> INSERT INTO Customer
>      VALUES (
>              @Customer_ID_int,
>              @Customer_First_Name_vch,
>              @Customer_Last_Name_vch,
>              @Customer_Email_Address_vch,
>              GetDate()
>             )

> GO

> The GetDate() call is just placed into the column you want to insert the
> date into.

> HTH

> Rkr
> --

>                    \|||/
>                    /'^'\
>                   ( 0 0 )
> --------------oOOO--(_)--OOOo--------------
> . Reid Roman                              .
> . Programmer / Analyst                    .
> . TVisualBasic := Class(None)             .
> . May the Source be With You              .
> -------------------------------------------
> . Auto-By-Tel (http://www.autobytel.com)  .
> . Irvine, CA U.S.A                        .
> . E-Mail : rkroman (at) home (dot) com    .
> -------------------------------------------

> Many thank for replay,
> I made mistake when I (some how) wrote 'Stored procedure', I just looking for
> trigger (what is more less same in MSSQL) or something like that.
> Accidentally, I found somewhere in MSSQL help that I could use GetDate()
> function as default value for my datetime field, what is exactly what I looking
> for.
> That was little surprise for me, because I didn't except that function call
> could be a default value. So, my next question will be 'Where is a limit ?', or
> is GetDate() exception ?