sqlserver »ù´¡ÖªÊ¶´óÕûÀí
--(¿ªÆô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±íÊ
Ïà¹ØÎĵµ£º
ÁÙ½üÄêÖÕ£¬ÔÚ¹¤×÷Ö®Óà¶Ô¹¤×÷ºÍѧϰÖÐÓöµ½µÄÎÊÌâÒÔ¼°³£ÓõÄһЩ֪ʶµã×öÁËЩÕûÀí£¬ÒÔ±¸ºóÓᣱ¾ÎÄÉæ¼°µÄÄÚÈÝΪÊý¾Ý¿â,ËãÊǶԿª·¢×ܽá(1)---Êý¾Ý¿âÒ»ÎĵIJ¹³ä¡£
1 ¶ÔÓÚÖ÷¼üÉèÖÃÁËIdentityµÄ±í£¬ÔÚɾ³ý±íÖÐÊý¾ÝºóÔÙÍù±íÖвåÈëÊý¾Ý£¬IdentityÁв»ÊÇ´Ó1ÆðʼÁË£¬Èç¹ûÏëɾ³ýÊý¾ÝºóIndentityÁÐÈÔ´Ó1Æðʼ£¬¿ÉÒÔÓÃÏÂÃæ´úÂëÀ´É¾³ýÊý¾Ý ......
ÈçºÎÅäÖö©ÔÄÒÔʹÓà Web ͬ²½ (SQL Server Management Studio)
±¾Ö÷ÌâµÄ¹ý³ÌÊÇΪºÏ²¢¸´ÖÆÅäÖà Web ͬ²½µÄµÚÈý¸ö²½Öè¡£Ó¦ÔÚÆôÓ÷¢²¼²¢ÅäÖà Microsoft Internet ÐÅÏ¢·þÎñ (IIS) ºóÖ´Ðд˲½Öè¡£ÓйØÅäÖùý³ÌµÄ¸ÅÊö£¬Çë²ÎÔÄ ÈçºÎΪºÏ²¢¸´ÖÆÅäÖà Web ͬ²½ (SQL Server Management Studio)¡£ÔÚÍê³É±¾Ö÷ÌâÖеĹý³Ìºó£¬Çëͬ²½´´½ ......
Ò»¡¢SQLServer ͨÓÃË÷Òý×Ö¶Î
1¡¢Primary Key's Ö÷¼ü
2¡¢Foreign Key's Íâ¼ü
3¡¢Ö§³ÖSELECT¡¢INSERT¡¢UPDATEºÍDELETEÃüÁîµÄ×ֶΠ:
(1)¡¢INNER JOIN
(£²)¡¢RIGHT | LEFT OUTER JOIN
(£³)¡¢WHERE
(£´)¡¢ORDER BY
(£µ)¡¢GROUP BY
(£¶)¡¢HAVING
¶þ¡¢´´½¨Ë÷ÒýµÄÆäËûÒòËØ(Ö÷ÒªÒòËض¼ÒòΪË÷ÒýÊÇÊý¾Ý±íÍⲿ ......
1¡¢²é¿´ÔÊý¾Ý¿â±¸·ÝÇé¿ö£ºRESTORE FILELISTONLY from DISK = 'c:\NMGCNC-BABY_2009-4-1.dat' WITH NOUNLOAD, FILE = 1
2¡¢½øÐÐÊý¾Ý¿â»¹Ô£º
restore database babyAndwed from DISK = 'c:\NMGCNC-BABY_2009-4-1.dat' with move 'babyAndwed_Data' to
'c:\NMGCNC-BABY_Data.MDF',move 'babyAndwed_Log' to 'c:\NMGCNC-B ......
Ë÷Òý·ÖΪÁ½´óÀà:¾Û¼¯Ë÷ÒýºÍ·Ç¾Û¼¯Ë÷Òý
Ò»¡¢¾Û¼¯Ë÷Òý
µ±Êý¾Ý±íÖеÄÒ»Áб»È·¶¨ÎªÖ÷¼üºó,SQLServer»á×Ô¶¯ÎªËü½¨Á¢¾Û¼¯Ë÷Òý,ÒòΪ¾Û¼¯Ë÷ÒýÊDZêʶÿ¸ö¼Ç¼Ðеļü,ËùÒÔËü½«±»Ó¦Óõ½Ã¿¸ö²éѯÖÐ.
¶þ¡¢·Ç¾Û¼¯Ë÷Òý
·Ç¾Û¼¯Ë÷ÒýµÄÇé¿ö¾Í±È½Ï¸´ÔÓÁË,ÒòΪËüÊÇÏà¶ÔÓÚ±í¶ÀÁ¢×éÖ¯µÄ,ÔÚSQLServerÖÐÓе¥¶ÀµÄ½á¹¹À´´æ´¢·Ç¾Û¼¯Ë÷Òý.
......