Login Register
Snippets
25 Latest Articles Current Articles | Archives | Search
05

Alter Table - Setting a Column Default Value

posted on December 05, 2012 04:36
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...

Post Rating

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
  P. O. BOX 2342, BREWSTER, MA 02631
  (774) 323-3176
  CONTACT US