Register
Menu

Stored Procedures

Support  /  Knowledge Base  /  Microsoft SQL Server  /  Stored Procedures

Snippets

25 Latest Articles Current Articles | Archives | Search
05

Alter Table - Setting a Column Default Value

DNN Expert posted on December 05, 2012 04:36 Article Rating
ALTER TABLE MyTableName ADD CONSTRAINT DF_MyTableName DEFAULT GETDATE() FOR MyColumnName
Posted in: SQL Scripts
Actions: E-mail | Permalink | Comments (0) RSS comment feed

Related Articles

Replace Null or Empty Value with String Select ISNULL(NULLIF(GIBS_FBLineItems.ReportType, ''), '--Undefined--') as ReportType from GIBS_FBLineItems
Formatting a Short Date in SQL using Convert Function To format a short date like MM/DD/YY try the following: select CONVERT(VARCHAR(8), GETDATE(), 1) as MyShortDate For a complete guide to&nb...

Comments

There are currently no comments, be the first to post one!

Post Comment

Only registered users may post comments.

120 OLD FREEMANS WAY, BREWSTER, MA 02631
MAILING: P.O. BOX 2342, BREWSTER, MA 02631
PHONE (774) 323-3176