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

¾«ÃîSQLÓï¾ä


ÏÂÁÐÓï¾ä²¿·ÖÊÇMssql
Óï¾ä£¬²»¿ÉÒÔÔÚaccess
ÖÐʹÓá£
SQL
·ÖÀࣺ
DDL—
Êý¾Ý¶¨ÒåÓïÑÔ(CREATE
£¬ALTER
£¬DROP
£¬DECLARE)
DML—
Êý¾Ý²Ù×ÝÓïÑÔ(SELECT
£¬DELETE
£¬UPDATE
£¬INSERT)
DCL—
Êý¾Ý¿ØÖÆÓïÑÔ(GRANT
£¬REVOKE
£¬COMMIT
£¬ROLLBACK)
Ê×ÏÈ,
¼òÒª½éÉÜ»ù´¡Óï¾ä£º
1
¡¢ËµÃ÷£º´´½¨Êý¾Ý¿â
CREATE DATABASE database-name
2
¡¢ËµÃ÷£ºÉ¾³ýÊý¾Ý¿â
drop database dbname
3
¡¢ËµÃ÷£º±¸·Ýsql server
---
´´½¨ ±¸·ÝÊý¾ÝµÄ device
USE master
EXEC sp_addumpdevice 'disk',
'testBack', 'c:\mssql7backup\MyNwind_1.dat'
---
¿ªÊ¼ ±¸·Ý
BACKUP DATABASE pubs TO testBack
4
¡¢ËµÃ÷£º´´½¨Ð±í
create table tabname(col1 type1 [not null] [primary key],col2
type2 [not null],..)
¸ù¾ÝÒÑÓÐµÄ±í´´½¨ÐÂ±í£º
A
£ºcreate table tab_new like tab_old (
ʹÓÃ¾É±í´´½¨Ð±í)
B
£ºcreate table tab_new as select col1,col2… from tab_old
definition only
5
¡¢ËµÃ÷£ºÉ¾³ýбídrop table tabname
6
¡¢ËµÃ÷£ºÔö¼ÓÒ»¸öÁÐ
Alter table tabname add column col type
×¢£ºÁÐÔö¼Óºó½«²»ÄÜɾ³ý¡£DB2
ÖÐÁмÓÉϺóÊý¾ÝÀàÐÍÒ²²»Äܸı䣬ΨһÄܸıäµÄÊÇÔö¼Óvarchar
ÀàÐ͵ij¤¶È¡£
7
¡¢ËµÃ÷£ºÌí¼ÓÖ÷¼ü£º Alter table tabname add primary key(col)
˵Ã÷£ºÉ¾³ýÖ÷¼ü£º Alter table tabname
drop primary key(col)
8
¡¢ËµÃ÷£º´´½¨Ë÷Òý£ºcreate [unique] index idxname on tabname(col….)
ɾ³ýË÷Òý£ºdrop index idxname
×¢£ºË÷ÒýÊDz»¿É¸ü¸ÄµÄ£¬Ïë¸ü¸Ä±ØÐëɾ³ýÖØÐ½¨¡£
9
¡¢ËµÃ÷£º´´½¨ÊÓͼ£ºcreate view viewname as select statement
ɾ³ýÊÓͼ£ºdrop view viewname
10
¡¢ËµÃ÷£º¼¸¸ö¼òµ¥µÄ»ù±¾µÄsql
Óï¾ä
Ñ¡Ôñ£ºselect * from table1
where
·¶Î§
²åÈ룺insert into
table1(field1,field2) values(value1,value2)
ɾ³ý£ºdelete from table1 where
·¶Î§
¸üУºupdate table1 set
field1=value1 where
·¶Î§
²éÕÒ£ºselect * from table1
where field1 like ’%value1%’ ---like
µÄÓï·¨ºÜ¾«Ã²é×ÊÁÏ!
ÅÅÐò£ºselect * from table1
order by field1,field2 [desc]
×ÜÊý£ºselect count * as
totalcount from table1
ÇóºÍ£ºselect sum(field1) as
sumvalue from table1
ƽ¾ù£ºsel


Ïà¹ØÎĵµ£º

ms sql ³£ÓòÙ×÷Óï¾ä

MS SQLµÄһЩ¾­µä³£ÓòÙ×÷Óï¾ä»ã×Ü  ¡¾http://hi.baidu.com/kychen88/blog/item/b3c8e7d960821b3c32fa1cee.html¡¿
1.°´ÐÕÊϱʻ­ÅÅÐò:
Select * from TableName Order By CustomerName Collate Chinese_PRC_Stroke_ci_as
2.Êý¾Ý¿â¼ÓÃÜ:
select encrypt('ԭʼÃÜÂë')
select pwdencrypt('ԭʼÃÜÂë')
select pwdcomp ......

sql server 2005µÄsaÕ˺ÅÃÜÂëÍü¼ÇÁËÔõô°ì

¾ßÌå½â¾ö²½Öè:
µÚÒ»²½:´ò¿ª SQL2005 ÓùÜÀíÔ±µÇ¼ÏÈ,È»ºóÔÚ·þÎñÃû´¦ÓÒ»÷Ñ¡ÊôÐÔ>°²È«ÐÔ>ÓұߵĵǼ·½Ê½Ñ¡Ïî¸ÄΪ Éí·ÝÑéÖ¤ È·¶¨!
µÚ¶þ²½:Ñ¡Ôñ°²È«ÐÔ(Õ¹¿ª)>µÇ¼Ãû>Ë«»÷sa>ÃÜÂë¸Ä³ÉÄãÐèÒªµÄÃÜÂë È·¶¨!
È»ºó¹ØµôSQL2005 »òÕß ¶Ï¿ªÁ¬½Ó
µÚÈý²½:µã¿ªÊ¼>³ÌÐò>Ñ¡ÔñSQL2005>ÅäÖù¤¾ß>´ò¿ª configurat ......

SQL express °²×°Êֲᣭ°²×°

2¡¢sql express °²×° Èç¹ûÔÚXPÏ£¬Ö±½ÓË«»÷°²×°¾ÍºÃÁË¡£ ÏȰ²×° [ÔÚvistaÏÂÈç¹ûÖ±½ÓË«»÷¿ÉÄÜ»á³öÏÖ °²×°sql server express ³ö´í29506 ] [Vista°²×°µÄʱºò£¬ÐèҪʹÓá°ÒÔ¹ÜÀíÔ±Éí·ÝÔËÐС±°²×°] SQLServer2005_SSMSEE.msi°²×°½áÊø   studioÒѾ­°²×°ÉÏÈ¥£¬µ«ÊÇÄãÓÐûÓз¢ÏÖ£¬°²×°sqlµÄʱºòûÓз¢ÏÖÓÐÓû§saµÄà ......

SQL³£ÓÃÓï¾ä

1¡¢Óëgroup by´îÅäʹÓõĺ¯Êý
ÔÚÊý¾Ý¿âÖУ¬ÎÒÃÇ¿ÉÒÔʹÓÃGROUP BYº¯Êý°ÑÊý¾Ý×éºÏÔÚÒ»Æð£¬´Ó¶ø»ñµÃ×ܼÆÐÅÏ¢¡£¿ÉÒ԰Ѵ˹¦ÄÜ¿´³ÉÊÇÒ»ÖÖµ±Êý¾Ý´ÓÊý¾Ý¿âÖзµ»ØÊ±°ÑÏàͬÀàÐ͵ÄÐÅÏ¢¼¯Öе½Ò»ÆðµÄÄÜÁ¦¡£ÏÂÃæ¸ø³öÁËÍêÕûÁÐ±í¡£
avg([distinct]column_name)
ÇóËùÓйÍԱнˮµÄƽ¾ùÖµ¡£
select AVG(emp_salary)
from employee;
ÇóÈ¡c ......

Sql µãµÎ

ID int identity(1,1) primary key ×Ô¶¯Ôö³¤,Ö÷¼ü
EXEC sp_rename 'login_info','PDI_login_info'  Ö´Ðд洢¹ý³Ì sp_rename , ½«login_info±íÃû ¸ü¸ÄΪ PDI_login_info
SET   XACT_ABORT  {ON|OFF} Èç¹ûÊÂÎñÖз¢Éú´íÎó£¬on   Ôò»áÖÕÖ¹Õû¸öÊÂÎñµÄÖ´ÐУ¬Èç¹ûOFF£¬¼ÌÐø´íÎóµÄÏÂÃæÒ»¾ä  
SET &nbs ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ