Hello. I wrote a script that builds a table in SQL Server. The table was built correctly but I don't know how to assign a default value.<BR><BR>CREATE TABLE [dbo].[campaigns] (<BR>[id] [int] IDENTITY (1, 1) NOT NULL ,<BR>[campaign_name] [varchar] (75) NULL ,<BR>[campaign_exp] [datetime] NULL ,<BR>[impression_exp] [int] NULL , <BR><BR>In this example, I'd like the default date for campaign_exp to be today's date. I'd also like the impression_exp default value to be 99999999. Can you help?<BR><BR>Thanks!