×ÔÔö×ֶεÄSQLÓï¾ä½â¾ö·½°¸
create table [±íÃû]
(
[×Ô¶¯±àºÅ×Ö¶Î] int IDENTITY (1,1) PRIMARY KEY ,
[×Ö¶Î1] nVarChar(50) default 'ĬÈÏÖµ' null ,
[×Ö¶Î2] ntext null ,
[×Ö¶Î3] datetime,
[×Ö¶Î4] money null ,
[×Ö¶Î5] int default 0,
[×Ö¶Î6] Decimal (12,4) default 0,
[×Ö¶Î7] image null ,
)
ɾ³ý±í£º
Drop table [±íÃû]
²åÈëÊý¾Ý£º
INSERT INTO [±íÃû] (×Ö¶Î1,×Ö¶Î2) VALUES (100,'51WINDOWS.NET')
ɾ³ýÊý¾Ý£º
DELETE from [±íÃû] WHERE [×Ö¶ÎÃû]>100
¸üÐÂÊý¾Ý£º
UPDATE [±íÃû] SET [×Ö¶Î1] = 200,[×Ö¶Î2] = '51WINDOWS.NET' WHERE [×Ö¶ÎÈý] = 'HAIWA'
ÐÂÔö×ֶΣº
ALTER TABLE [±íÃû] ADD [×Ö¶ÎÃû] NVARCHAR (50) NULL
ɾ³ý×ֶΣº
ALTER TABLE [±íÃû] DROP COLUMN [×Ö¶ÎÃû]
ÐÞ¸Ä×ֶΣº
ALTER TABLE [±íÃû] ALTER COLUMN [×Ö¶ÎÃû] NVARCHAR (50) NULL
ÖØÃüÃû±í£º(Access ÖØÃüÃû±í£¬Çë²Î¿¼ÎÄÕ£ºÔÚAccessÊý¾Ý¿âÖÐÖØÃüÃû±í)
sp_rename '±íÃû', 'бíÃû', 'OBJECT'
н¨Ô¼Êø£º
ALTER TABLE [±íÃû] ADD CONSTRAINT Ô¼ÊøÃû CHECK ([Ô¼Êø×Ö¶Î] <= '2000-1-1')
ɾ³ýÔ¼Êø£º
ALTER TABLE [±íÃû] DROP CONSTRAINT Ô¼ÊøÃû
н¨Ä¬ÈÏÖµ
ALTER TABLE [±íÃû] ADD CONSTRAINT ĬÈÏÖµÃû DEFAULT '51WINDOWS.NET' FOR [×Ö¶ÎÃû]
ɾ³ýĬÈÏÖµ
ALTER TABLE [±íÃû] DROP CONSTRAINT ĬÈÏÖµÃû
ɾ³ýSql Server ÖеÄÈÕÖ¾£¬¼õСÊý¾Ý¿âÎļþ´óС
dump transaction Êý¾Ý¿âÃû with no_log
backup log Êý¾Ý¿âÃû with no_log
dbcc shrinkdatabase(Êý¾Ý¿âÃû)
exec sp_dboption 'Êý¾Ý¿âÃû', 'autoshrink', 'true'
×ÔÔöÁв»ÄÜÖ±½ÓÐ޸ģ¬±ØÐ뽫ÔÓÐIDÁÐɾ³ý£¬È»ºóÖØÐÂÌí¼ÓÒ»ÁоßÓÐidentityÊôÐÔµÄID×ֶΣ¬Óï¾äÈçÏÂ
alter table ±íÃû
drop column ID
alter table ±íÃû
add ID int identity(1,1)
ÐÞ¸ÄÈÕÆÚ×Ö¶ÎΪDatatimeÀàÐÍ£¬Ê×ÏÈÒª±£Ö¤±íÖÐÎÞÊý¾Ý£¬»òÏÖÓÐÊý¾Ý¿ÉÒÔÖ±½Óת»»ÎªdatetimeÀàÐÍ£¬·ñÔòÐÞ¸Ä×Ö¶ÎÀàÐ;ͻáʧ°Ü¡£
alter table ±íÃû
alter column ÈÕÆÚ×Ö¶ÎÃû datetime
1, ʹÓÃÒ»¸öÊý¾Ý¿â֮ǰҪÒýÓÃËû£ºuse Êý¾Ý¿âÃû
2£¬ exists()ÅжÏ×Ó²éѯµÄ½á¹ûÊÇ·ñ´æÔÚ£¬·µ»Øtrue or false
3, object_id('¶ÔÏóÃû') ·µ»Ø¸Ã¶ÔÏóÃû¶ÔÓ¦µÄId,¸Ãid´æ´¢ÔÚsysobjects±íÖС£
4£¬ ½¨±íʱ×Ô¶¯½¨Á¢Ö÷¼üÔ¼Êø£ºcreate table a(b char(4),c int,constraint Ö÷¼üÃû primary key(c))
»òÕߣºcreate table a(a char(
Ïà¹ØÎĵµ£º
½ñÌìÖÕÓÚ°ÑÕâ¸öÎÊÌâ¸ø½â¾öÁË£º
²Î¿¼ÎÄÕ£ºhttp://blog.csdn.net/long2006sky/archive/2007/04/23/1576583.aspx
ʵÀý˵Ã÷£º
»·¾³£ºwin2k+sqlserver 2K+²éѯ·ÖÎöÆ÷
SQLSERVER·þÎñʵÀý ......
update anketo1 set fb = substring('10',fb+1,1) WHERE id =5
ºóÀ´ÎÊÁËBM,BM˵ֱ½ÓÈ¡·´
update anketo1 set fb = ~ fb WHERE id =5
ÎÒ¸æËßÁËBMÓÃsubstringÒ²¿ÉÒÔ.
BM˵:"Õâ¼Ò»ïÀ÷º¦£¬ÕâÒ²ÄÜÏë³ö,ÕâÊôÓÚаÃÅÎ书."
×îºóÓÖÏëµ½ÓÃABSÈ¡¾ø¶ÔÖµÒ²¿ÉÒÔ
update anketo1 set fb = abs(fb-1)
ÎÒ¾õµÃ²»¹ÜÊÇʲôÎ书,ÄÜÖ ......
ÅäÖÃʹÓà SQL ServerÌṩ³ÌÐò
<configuration>
<system.web> <-- ¸ü¸ÄÌṩ³ÌÐòÅäÖ㺠-->
<membership defaultProvider="AspNetSqlProvider" />
</system.web>
<membership> <--ÅäÖÃÌṩ³ÌÐò -->
<prov ......