–– create the table

CREATE TABLE [dbo].[Orders](

[OrderId] [uniqueidentifier] NOT NULL,

[OrderDate] [datetime] NULL,

 CONSTRAINT [PK_Orders] PRIMARY KEY CLUSTERED 

(

[OrderId] ASC

)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]

) ON [PRIMARY]



–– change order date column to have a default of current date and time

ALTER TABLE dbo.Orders ADD CONSTRAINT

DF_Orders_OrderDate DEFAULT getDate() FOR OrderDate



–– test order date default value

insert into Orders (OrderId)

values (newId())



–– look at the awesome results

select *

from Orders