Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

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µÄÓï·¨ÔÚ ACCESS Ï´󲿷ÝÒ²¶¼ÊÇÒ»ÑùµÄ
ÏîÒ»Ïî²éÔÄ,²¢¾­×Ô¼ºÊ¹ÓÃÑéÖ¤,È·ÈÏÔÚaccess Êý¾Ý¿âÖÐÌí¼Ó×Ô¶¯±àºÅ×Ö¶ÎʹÓÃÒÔÏ·½·¨±È½ÏºÏÊÊ: create table Êý¾Ý±íÃû³Æ (id counter constraint primarykey primary key) ÐèҪעÒâµÄµØ·½ÊÇ:µÚ¶þ¸öprimaryÖмäÓпոñ,ÁíÍâ,¹Ø¼ü×Ö²»Çø·Ö´óСд. ÁíÍâ×Ô¼º×î½ü·¢ÏÖµÄÒ»ÖÖ·½·¨ÊÇ: sql="create table mytb (id autoincrement(25,1) primary key,age int)" sql2="create table testtb (id autoincrement,age int,email char, primary key (id))" ÆäÖÐÔÚaccessÖÐ,autoincrementΪ×Ô¶¯±àºÅÀàÐÍ×Ö¶Î,(25,1)·Ö±ðΪ³õʼֵ¼°²½³¤Öµ,Èç¹û²»Ð´µÄ»°,ĬÈÏÊÇ1,1,primary keyÖ¸¶¨ÁËÖ÷¼ü,ÒÔÉÏʾÀý,Á½ÖÖÖ¸¶¨·½·¨¶¼¿ÉÒÔ
5.6. Ð޸ıí
Èç¹ûÄã´´½¨ÁËÒ»¸ö±íºó·¢ÏÖ×Ô¼º·¸ÁËһЩ´íÎ󣬻òÕßÊÇÓ¦ÓõÄÐèÇó ·¢ÉúÁ˱仯£¬ÄÇôÄã¿ÉÒÔɾ³ýÕâ¸ö±íÈ»ºóÖØд´½¨Ëü¡£µ«ÊÇÈç¹ûÕâ¸ö ±íÒѾ­Ìî³äÁ˺öàÊý¾ÝÁË£¬»òÕßÊǸñíÒѾ­±»ÆäËüÊý¾Ý¿â¶ÔÏóÒýÓ㬠£¨±ÈÈçÒ»¸öÍâ¼üÔ¼Êø£© ÄÇÕâ¿É²»ÊÇÒ»¸ö·½±ãµÄÑ¡Ïî¡£Òò´Ë PostgreSQL ÌṩÁËÒ»×åÃüÁî


Ïà¹ØÎĵµ£º

SQL SERVER 2005·ÖÒ³´æ´¢¹ý³Ì

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go
ALTER PROCEDURE [dbo].[PE011_Page]
  @TableName varchar(50),        --±íÃû
 @Fields varchar(5000) = '*',    --×Ö¶ÎÃû(È«²¿×Ö¶ÎΪ*)
 @OrderField varchar(5000),    &n ......

SQL Server BI Step by Step SSIS 1 ×¼±¸

SQL Server 2005 ºÍ2008ÌṩÁ˺ܶàеĺÍÔöÇ¿µÄÉÌÎñÖÇÄܹ¦ÄÜ,°üÀ¨ÀûÓü¯³É·þÎñ(SSIS)ÕûºÏ¶àÖÖÊý¾ÝÔ´;ÀûÓ÷ÖÎö·þÎñ(SSAS)ʹÊý¾ÝÄÚÈݸü·á¸»²¢ÇÒ½¨Á¢¸´ÔÓµÄÉÌÒµ·ÖÎö; ÒÔ¼°ÀûÓñ¨±í·þÎñ(SSRS)±à¼­,¹ÜÀí,ºÍÌá½»·á¸»µÄ±¨±í. Èç¹ûÄãÏÖÔÚ»¹²»Çå³þÕâЩ¹¦ÄÜ,ÄÇô½ÓÏÂÀ´Ò»ÏµÁеĽéÉÜ»áÈÃÄã¶ÔSQL ServerÏÖÔÚµÄÉÌÎñÖÇÄÜÖ§³Ö´ó³ÔÒ»¾ª.²»¹ý ......

SQL Server 2005µ¼Èëµ¼³ö´æ´¢¹ý³Ì

1. ¿ÉÒÔÓýű¾±¸·Ý
¡¡¡¡manger studio--ÓÒ¼üÄãµÄÊý¾Ý¿â--ÈÎÎñ--Éú³É½Å±¾
¡¡¡¡Ôڽű¾Éú³ÉÏòµ¼µÄ"Ñ¡Ôñ¶ÔÏóÀàÐÍ"²½ÖèÖÐ, ½«"´æ´¢¹ý³Ì"Ñ¡ÉÏ, ÔÚ½ÓÏÂÀ´µÄ"Ñ¡Ôñ´æ´¢¹ý³Ì"µÄ²½ÖèÖÐ, Ñ¡ÔñËùÓеĴ洢¹ý³Ì(»òÕßÄãÒª¸´ÖƵĴ洢¹ý³Ì)
¡¡¡¡Íê³Éºó, ËùÓд洢¹ý³ÌµÄ½Å±¾»áÉú³ÉÔÚÒ»¸öеIJéѯ´°¿ÚÖÐ, ¹ØµôÉú³É½Å±¾Ïòµ¼, ÔÚÉú³ÉµÄ´æ´¢¹ý³Ì ......

SQL Server ErrorLog

תÖÁhttp://mbtk.blog.sohu.com/150003773.html £¬²¢²¹³äһЩÏà¹Ø֪ʶ¡£
DBCC ErrorLog £ºÈç¹ûºÜÉÙÖØÆðmssqlserver·þÎñ£¬ÄÇô·þÎñÆ÷µÄÈÕÖ¾»áÔö³¤µÃºÜ¿ì£¬¶øÇÒ´ò¿ªºÍ²é¿´ÈÕÖ¾µÄËÙ¶ÈÒ²»áºÜÂý¡£Ê¹ÓÃÕâ¸öÃüÁ¿ÉÒԽضϵ±Ç°µÄ·þÎñÆ÷ÈÕÖ¾£¬Ö÷ÒªÊÇÉú³ÉÒ»¸öеÄÈÕÖ¾¡£¿ÉÒÔ¿¼ÂÇÉèÖÃÒ»¸öµ÷¶ÈÈÎÎñ£¬Ã¿ÖÜÖ´ÐÐÕâ¸öÃüÁî×Ô¶¯½Ø¶Ï·þÎ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ