﻿<?xml version='1.0' encoding='UTF-8'?><rss version="2.0" xmlns:dc="http://purl.org/dc/elements/1.1/"><channel><title>SQLServerCentral / SQLServerCentral.com / Articles Requested  / Add a default to a column / Latest Posts</title><generator>InstantForum.NET v2.9.0</generator><description>SQLServerCentral</description><link>http://www.sqlservercentral.com/Forums/</link><webMaster>notifications@sqlservercentral.com</webMaster><lastBuildDate>Wed, 19 Jun 2013 23:46:40 GMT</lastBuildDate><ttl>20</ttl><item><title>RE: Add a default to a column</title><link>http://www.sqlservercentral.com/Forums/Topic1079835-2824-1.aspx</link><description>[quote][b]Steve Jones - SSC Editor (11/29/2011)[/b][hr]Yes, and Yes. We want to expand and cover things that are in BOL in a different way. A practical use for this in a short article that someone has implemented in production would be nice.[/quote]Understood and can do.  I'll take this one on.  Thank you for the guidance.I believe I still owe you one on getting BCP (and other methods) to produce column headers, as well.  I'll see what I can do about that, as well.</description><pubDate>Wed, 30 Nov 2011 06:09:36 GMT</pubDate><dc:creator>Jeff Moden</dc:creator></item><item><title>RE: Add a default to a column</title><link>http://www.sqlservercentral.com/Forums/Topic1079835-2824-1.aspx</link><description>Yes, and Yes. We want to expand and cover things that are in BOL in a different way. A practical use for this in a short article that someone has implemented in production would be nice.</description><pubDate>Tue, 29 Nov 2011 21:32:56 GMT</pubDate><dc:creator>Steve Jones - SSC Editor</dc:creator></item><item><title>RE: Add a default to a column</title><link>http://www.sqlservercentral.com/Forums/Topic1079835-2824-1.aspx</link><description>Since this is very well documented in Books Online, I have to ask, do you still want an article on this and, if so, should it be more of a "Spackle" article?</description><pubDate>Tue, 29 Nov 2011 19:01:23 GMT</pubDate><dc:creator>Jeff Moden</dc:creator></item><item><title>RE: Add a default to a column</title><link>http://www.sqlservercentral.com/Forums/Topic1079835-2824-1.aspx</link><description>No worries, we'll find someone else.</description><pubDate>Fri, 29 Jul 2011 09:23:09 GMT</pubDate><dc:creator>Steve Jones - SSC Editor</dc:creator></item><item><title>RE: Add a default to a column</title><link>http://www.sqlservercentral.com/Forums/Topic1079835-2824-1.aspx</link><description>Hi SteveI'm going to have to pass on this. Workload means I don't currently have time to write an article that adds any value compared to what is already out there. Sorry. I've submitted a QOTD instead as penance.Anybody else able to do this?</description><pubDate>Fri, 29 Jul 2011 09:08:18 GMT</pubDate><dc:creator>Dwayne Dibley</dc:creator></item><item><title>RE: Add a default to a column</title><link>http://www.sqlservercentral.com/Forums/Topic1079835-2824-1.aspx</link><description>Excellent, this should be an easy one.</description><pubDate>Thu, 17 Mar 2011 10:50:42 GMT</pubDate><dc:creator>Steve Jones - SSC Editor</dc:creator></item><item><title>RE: Add a default to a column</title><link>http://www.sqlservercentral.com/Forums/Topic1079835-2824-1.aspx</link><description>Hi SteveI'll take this.Regards</description><pubDate>Thu, 17 Mar 2011 10:29:59 GMT</pubDate><dc:creator>Dwayne Dibley</dc:creator></item><item><title>Add a default to a column</title><link>http://www.sqlservercentral.com/Forums/Topic1079835-2824-1.aspx</link><description>Show in SSMS and T-SQL, how to add a default to a column at design time (CREATE) and later (ALTER).Be nice to add these defaultsspace  for char field0 for numericcurrent date for date field</description><pubDate>Thu, 17 Mar 2011 10:15:05 GMT</pubDate><dc:creator>Steve Jones - SSC Editor</dc:creator></item></channel></rss>