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

sqlserver »ù´¡ÖªÊ¶´óÕûÀí

SQL-Structured Query Language
--(¿ªÆôSQL·þÎñ£ºnet start mssqlserver)
--(ÔÚÃüÁîÐÐÖÐÊäÈë'sqlwb'ÃüÁî¿É´ò¿ªSQL¹ÜÀíÆ÷ )
--(Èç¹ûÒªÖ´ÐжàÌõÃüÁîÖеÄÒ»Ìõ,Êó±êÑ¡¶¨ºóÔÙ°´F5Ö´ÐÐ)
create database sales --´´½¨Ò»¸öÃûΪsalesµÄÊý¾Ý¿â
on
(
name='sales_data',
filename='d:\sales_data.mdf',
size=10,
maxsize=50,
filegrowth=5
)
log on
(
name='sales_log',
filename='d:\sales_log.ldf',
size=10,
maxsize=50,
filegrowth=5
)
drop database sales --ɾ³ýËù´´½¨µÄÊý¾Ý¿â
sp_helpdb sales --²é¿´Êý¾Ý¿âµÄÏà¹ØÐÅÏ¢
sp_helpfile --²é¿´µ±Ç°Êý¾Ý¿âÊý¾ÝÎļþÓëÈÕÖ¾ÎļþµÄÏà¹ØÐÅÏ¢
sp_detach_db sales --×ªÒÆÊý¾Ý¿âʱ·ÖÀëÊý¾Ý¿â
sp_attach_db sales,@filename1='Êý¾ÝÎļþ·¾¶Ãû' --ÕûºÏ·ÖÀëµÄÊý¾Ý¿â
,@filename2='ÈÕÖ¾Îļþ·¾¶Ãû'
--(ÈçºÎ¼õСÊý¾Ý¿âÈÕÖ¾ÎļþµÄ´óС: a.·ÖÀëÊý¾Ý¿â b.×ªÒÆÈÕÖ¾Îļþ c .ÕûºÏÊý¾Ý¿âµ«²»Ö¸¶¨ÈÕÖ¾Îļþ)
--Êý¾Ý¿âµÄ±¸·Ý
sp_addumpdevice 'disk','mydisk','d:\sales.bak' --Ìí¼ÓÉ豸¡£disk±íʾĿ±êÉ豸ÀàÐÍ,mydisk±íʾĿ±êÉ豸Âß¼­Ãû³Æ,d:\sales.bak±íʾĿ±êÉ豸ÎïÀíÃû³Æ
backup database sales to mydisk --ÏòÉ豸дÈëÊý¾Ý.ÆäÖеÄsalesÖ¸Êý¾Ý¿âÃû,mydiskΪ×Ô¶¨µÄÉ豸±êʾ·û
restore database sales from mydisk --»Ö¸´Êý¾Ý¿â
sp_dropdevice mydisk --ɾ³ýÉ豸
EXEC sp_dboption 'sales','read only','true' --ÉèÊý¾Ý¿âΪֻ¶Á
EXEC sp_dboption 'sales',autoshrink,true --ÉèÊý¾Ý¿âΪ×Ô¶¯Ñ¹Ëõ
EXEC sp_dboption 'sales','single user' --ÉèÊý¾Ý¿âΪµ¥Óû§
--(ÒÔÉÏÃüÁîÖе¥ÒýºÅ¿É¼Ó¿É²»¼Ó,µ«Ãû×ÖÖгöÏÖ¿Õ¸ñµÄÒ»¶¨Òª¼Ó.´óСд²»·Ö)
DBCC shrinkdatabase (sales,10) --½«Êý¾Ý¿âÖеÄÎļþ¼õС,ʹÊý¾Ý¿âÖÐÓÐ10%µÄ¿ÉÓÿռä
---------------------------------------------------------------------------------------------------------------
create table goods --½¨±íµÄµÚÒ»ÖÖÔ¼ÊøÓï·¨
(
gid int primary key,
gname varch


Ïà¹ØÎĵµ£º

sqlserver»ñÈ¡µÚnÐÐÊý¾Ý

ÈçºÎÔÚÒ»¸öûÓÐÖ÷¼üµÄ±íÖлñÈ¡µÚnÐÐÊý¾Ý£¬ÔÚsql2005ÖпÉÒÔÓÃrow_number£¬µ«ÊDZØÐëÖ¸¶¨ÅÅÐòÁУ¬·ñÔòÄã¾Í²»µÃ²»ÓÃselect intoÀ´¹ý¶Éµ½ÁÙʱ±í²¢Ôö¼ÓÒ»¸öÅÅÐò×ֶΡ£
ÓÃÓαêµÄfetch  absoluteÓï¾ä¿ÉÒÔ»ñÈ¡¾ø¶ÔÐÐÊýϵÄijÐÐÊý¾Ý,²âÊÔ´úÂëÈçÏÂ:
set nocount on
--½¨Á¢²âÊÔ»·¾³²¢²åÈëÊý¾Ý£¬²¢ÇÒ±íûÓÐÖ÷¼ü
create table t ......

×ܽáÒ»µãAccessÓëSqlserverµÄsqlµÄ²îÒì

×î½üÕûÀí³öÀ´µÄ.Èç¹û²»ÍêÈ«µÄ»°Ï£Íû´ó¼Ò²¹³ä.
ÔÚaccessÖУ¬×ª»»Îª´óдµÄsqlº¯ÊýÊÇucase£¬ÔÚsqlserverÖУ¬×ª»»Îª´óдµÄº¯ÊýÊÇupper£»ÔÚaccessÖУ¬×ª»»ÎªÐ¡Ð´µÄº¯ÊýÊÇlcase£¬ÔÚsqlserverÖУ¬×ª»»ÎªÐ¡Ð´µÄº¯ÊýÊÇlower£»ÔÚaccessÖУ¬È¡µ±Ç°Ê±¼äµÄº¯ÊýÊÇnow£¬ÁíÍ⻹ÓÐÒ»¸öÈ¡ÈÕÆÚº¯Êýdate£¬ÔÚsqlserverÖУ¬È¡µ±Ç°µÄº¯ÊýÊÇgetdate ......

aspÁ¬sqlserver²âÊÔ´úÂë

<%
Dim Conn, Connstr
Dim strServer, strUid, strPwd, strDB
strServer = "HUA-5780C2D1CCF"        'SQLÊý¾Ý¿â·þÎñÆ÷µØÖ·
strUid = "sa"                'Êý¾Ý¿âÓû§Ãû
strPwd = "123456"  ......

ÓÃCASE WHENʵÏÖsqlserverÊý¾Ý¿âµÄ·ÖÀà»ã×ܹ¦ÄÜ

/*ÓÃCASE WHENʵÏÖsqlserverÊý¾Ý¿âµÄ·ÖÀà»ã×ܹ¦ÄÜ*/
/*Àý1£ºÍ³¼Æ¸öÊý*/
/*±í½á¹¹
id  cityid  major
1   1         A
2   1         B
3   2        ......

SQLServerϵͳ´æ´¢¹ý³Ì

sp_databases --Áгö·þÎñÆ÷ÉϵÄËùÓÐÊý¾Ý¿â
sp_server_info --Áгö·þÎñÆ÷ÐÅÏ¢£¬Èç×Ö·û¼¯£¬°æ±¾ºÍÅÅÁÐ˳Ðò
sp_stored_procedures--Áгöµ±Ç°»·¾³ÖеÄËùÓд洢¹ý³Ì
sp_tables --Áгöµ±Ç°»·¾³ÖÐËùÓпÉÒÔ²éѯµÄ¶ÔÏó
sp_start_job --Á¢¼´Æô¶¯×Ô¶¯»¯ÈÎÎñ
sp_stop_job --Í£Ö¹ÕýÔÚÖ´ÐеÄ×Ô¶¯»¯ÈÎÎñ
sp_password --Ìí¼Ó»òÐ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ