Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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Ìæ»»Óï¾ä

--·Ö½â×Ö·û´®°üº¬µÄÐÅÏ¢ÖµºóÈ»ºóºÏ²¢µ½ÁíÍâÒ»±íµÄÐÅÏ¢
--(°®Ð¾õÂÞ.ع»ª(Ê®°ËÄê·çÓê,ÊصñùɽѩÁ«»¨¿ª)  2007-12-23  ¹ã¶«ÉîÛÚ)
/*ÎÊÌâÃèÊö
tba
ID  classid   name
1     1,2,3   Î÷·þ
2     2,3     ÖÐɽװ
3&n ......

pl/sql developerµÄʹÓÃ

Ôړн¨”²Ëµ¥ÖУ¬ÓÐProgram window£¬Test window£¬SQL windowºÍCommand windowµÈ¡£
SQL windowºÍCommand windowÓÐʲôÇø±ð£¿£¿
Command windowʵÏÖÁËSQL*PlusµÄËùÓй¦ÄÜ£¬ÔÊÐíÔËÐÐsql*plusÃüÁsqlÃüÁsql½Å±¾¡£
SQL windowÓÃÓÚÖ´ÐÐsqlÓï¾ä£¬ÏÔʾsqlÊä³ö£¬Ö´ÐÐͳ¼ÆÐÅÏ¢¡££¨²âÊÔsqlÓï¾ä£¬²é¿´±íÖеÄÊý¾Ý£¬ ......

SQL SERVER 2005 Ö»ÓÐmdfÎļþµÄÊý¾Ý»Ö¸´·½·¨


Ò»´ÎProjectÏîĿƽ̨(PWA)ÒâÍâÍ£»úÇÒÅäÖÃÊý¾Ý¿âSharePoint_Config µÄLDF±»ÒâÍâɾ³ý,Èç¹ûÖ±½Ó¸½¼ÓMDFÎļþÔòÎÞ·¨¸½¼Ó.
Ïȳ¢ÊÔsp_attach_single_file_db»Ö¸´,Ö´ÐÐÈçÏÂ:
sp_attach_single_file_db 'SharePoint_Config','D:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\SharePoint_Config.mdf'
³öÏÖ´íÎóÌáʾ:
......

DBF±íÓëSQL Server±íµÄµ¼Èë¡¢µ¼³ö


----------Dbf µ¼Èë Sql Server±í----------
ÒÔϾùÒÔSQL2000¡¢VFP6¼°ÒÔÉϵıíΪÀý
´úÂëµ¼È룺²éѯ·ÖÎöÆ÷ÖÐÖ´ÐÐÈçÏÂÓï¾ä(ÏÈÑ¡Ôñ¶ÔÓ¦µÄÊý¾Ý¿â)
-------------Èç¹û½ÓÊܵ¼ÈëÊý¾ÝµÄSQL±íÒÑ´æÔÚ
--Èç¹û½ÓÊܵ¼ÈëÊý¾ÝµÄSQL±íÒѾ­´æÔÚ
Insert Into ÒѾ­´æÔÚµÄSQL±íÃû Select * from openrowset('MSDASQL','Driver=Microsoft ......

SQL Loader

Oracle µÄSQL*LOADER¿ÉÒÔ½«ÍⲿÊý¾Ý¼ÓÔص½Êý¾Ý¿â±íÖС£ÏÂÃæÊÇSQL*LOADERµÄ»ù±¾Ìص㣺
1£©ÄÜ×°È벻ͬÊý¾ÝÀàÐÍÎļþ¼°¶à¸öÊý¾ÝÎļþµÄÊý¾Ý
2£©¿É×°Èë¹Ì¶¨¸ñʽ£¬×ÔÓɶ¨½çÒÔ¼°¿É¶È³¤¸ñʽµÄÊý¾Ý
3£©¿ÉÒÔ×°Èë¶þ½øÖÆ£¬Ñ¹ËõÊ®½øÖÆÊý¾Ý
4£©Ò»´Î¿É¶Ô¶à¸ö±í×°ÈëÊý¾Ý
5£©Á¬½Ó¶à¸öÎïÀí¼Ç¼װµ½Ò»¸ö¼Ç¼ÖÐ
6£©¶ÔÒ»µ¥¼Ç¼·Ö½âÔÙ×°Èëµ½± ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ