<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[anteye的专栏]]></title><description><![CDATA[]]></description><link>https://blog.csdn.net/anteye</link><language>zh-cn</language><generator>https://blog.csdn.net/</generator><copyright><![CDATA[Copyright &copy; anteye]]></copyright><item><title><![CDATA[SQL修改表结构写法]]></title><link>https://blog.csdn.net/anteye/article/details/1623305</link><guid>https://blog.csdn.net/anteye/article/details/1623305</guid><author>anteye</author><pubDate>Wed, 23 May 2007 22:52:00 +0800</pubDate><description><![CDATA[开始时创建表CREATE TABLE A ( CREATEDATE DATETIME NOT NULL)GO现在我要将CREATEDATE字段设置有默认值DEFAULT GETDATE()。在不DROP这个字段的情况下，我怎么能用脚本添加这个默认值。为以下相应的SQL语句:alter TABLE A add constraint default_create_date defaul]]></description><category></category></item></channel></rss>