sql ±íÐÞ¸ÄÁÐ
create table #a
(
a int identity(1,1) primary key,
b int default(0) not null,
c nvarchar(20)
)
insert into #a(c)
select 'a' union all
select 'b' union all
select 'c' union all
select 'd' union all
select 'e'
select * from #a
alter table #a drop constraint DF__#a_____________b__1273C1CD
alter table #a add constraint DF__#a_____________b__1273C1CD default(1) for b
alter table #a add c nvarchar(10) not null constraint DF_#a_b default('aa')
--ÓÐÔ¼ÊøµÄʱºò¿ÉÒÔͨ¹ý´íÎóÌáʾÀ´²éÔ¼ÊøÃû
alter table ±íÃû drop column [ÁÐÃû]
alter table ±íÃû add [ÁÐÃû] [ÀàÐÍ] NULL CONSTRAINT [DF_±íÃû_ÁÐÃû] DEFAULT ((0))
select * from #a
Ïà¹ØÎĵµ£º
Õ⼸ÌìÓÃÁËÒ»ÏÂMicrosoft SQL Server 200µÄ·ÖÎö·þÎñ£¬Ìù³öÀ´¸ø´ó¼Ò·ÖÏíһϡ£
Çë¶à¶àÖ¸Õý¡£Ð»Ð»¡£
Ò»¡¢ÐèÇó£º
½¨Á¢Ò»¸öͼÊ鶩µ¥Í³¼Æϵͳ
1¡¢Í³¼Æ¸÷¸öͼÊé¹Ý¶©µ¥ÊýÁ¿¡£
2¡¢Í³¼Æ¸÷¸öͼÊé¹Ý¶©µ¥µÄ¸÷¸ö״̬µÄÊýÁ¿Õ¼¸ÃͼÊé¹ÝµÄ¶©µ¥ÊýÁ¿µÄ°Ù·Ö±È¡£
3¡¢Í¬Ê±Í³¼ÆÔʼÊýÁ¿ºÍ´¢ÔËÊýÁ¿
¶þ¡¢Êý¾Ý±í
Ö ......
Ò»¡¢ÔÚDelphi7ÖÐÁ¬½ÓMS SQL Server 2000µÄ·½·¨¡£
¸Õ¿ªÊ¼Ê±½çÃæÈçÏ£ºÌí¼Ó4¸ö¿Ø¼þ¡£
ÉèÖÿؼþÊôÐÔ¹ý³Ì£º
1¡¢ADOConnection1ÉèÖÃ
1£©Ë«»÷ADOConnection1£¬½øÐÐÉèÖÃÁ¬½Ó×Ö·û´®£¨×÷ÓÃÊÇ£ºÑ¡È¡Á¬½ÓÇý¶¯·½Ê½ºÍÁ¬½ÓµÄÊý¾Ý¿âÉèÖã©¡£¹ý³ÌÈçÏÂͼËùʾ£º
2¡¢ADOQuery1ÉèÖãº
1£©ADOQuery1.connectionÊôÐÔΪADOConnection1; ......
´ò¿ª²éѯ·ÖÎöÆ÷£¬ÊäÈëÃüÁî¼´¿É¡£ DUMP TRANSACTION Êý¾Ý¿âÃû WITH NO_LOG
Èç¹û¾õµÃ·¢ÏÖLDFÎļþÕ¼ÓôÅÅ̿ռ仹ÊǺܴó¡£
Çë´ò¿ªÆóÒµ¹ÜÀíÆ÷--ÓÒ¼üµã»÷ÐèѹËõµÄÊý¾Ý¿â--ËùÓÐÈÎÎñ--ÊÕËõÊý¾Ý¿â--ÊÕËõÎļþ--Ñ¡ÔñÈÕÖ¾Îļþ--ÔÚÊÕËõ·½Ê½ÀïÑ¡ÔñÊÕËõÖÁXXM,ÕâÀï»á¸ø³öÒ»¸öÔÊÐíÊÕËõµ½µÄ×îСMÊý,µ÷ÕûÈ·¶¨¼´¿É¡£
Technorati ±êÇ©: SQL ......
ʹÓùý Access µÄÅóÓѶ¼ÖªµÀ£¬Access ÀïÓиö“ÊÇ/·ñ”Êý¾ÝÀàÐÍ£¬ÔÚ SQL Server ÖУ¬Ã»ÓÐÕâ¸öÃû³Æ£¬¶øʹÓà bit¡£ÔÚʹÓùý³ÌÖÐÓм¸µãÐèҪעÒâµÄ£º
£±¡¢bit Óë SQL Server µÄÕûÐͺÍÊý×ÖÊý¾ÝÏàËƵÄÊý×ÖÊý¾Ý£¬µ« bit ÁÐÖ»ÄÜ´æ´¢ 0 ºÍ 1¡£
£²¡¢ÔÚ²åÈë¡¢ÐÞ¸Ä bit Êý¾Ýʱ£¬Ê¹Óà 0 »ò 1 £¬¶ø²»ÊÇ false »ò true£¬bit ×Ö¶ ......