SQL Server Management StudioÁ¬½Ó·þÎñÆ÷ʱָ¶¨¶Ë¿ÚºÅ
½ñÌìÏëÁ¬½ÓSQL Server·þÎñÆ÷ʱ·¢ÏÖû·¨Á¬½Ó£¬·¢Ïֶ˿ںŲ»ÊÇĬÈϵĶ˿ںţ¬ÐèÒªÖ¸¶¨¶Ë¿ÚºÅ£¬¸Õ¿ªÊ¼ÒÔΪÊÇIPµØÖ·¼ÓðºÅÔٶ˿ںžÍÐÐÁË£¬½á¹û·¢ÏÖûÓã¬googleÒ»°Ñ·¢ÏÖÔÀ´²»ÊÇðºÅ£¬ÊǶººÅ£¬¹þ¡£±ÈÈ磺127.0.0.1,1451 , ¸ñʽ¾ÍÊÇ£º[IP],[Port] ¡£ Íê±Ï¡£
Ïà¹ØÎĵµ£º
Use DatabaseName
--DB shrink
--»ñÈ¡database ¿ÕÓà¿Õ¼ä£¬¡¡¾ö¶¨ÊÇ·ñ×÷shrinkDB
exec [DBNAME].dbo.sp_spaceused
DBCC ShrinkDB(DBNAME)
--Log file shrink
Use DatabaseName
GO
Alter Database DatabaseName Set Recovery Simple
GO
Alter Database DatabaseName Set Recovery Full
GO
DBCC SHRINKFILE ('Log ......
sql ·þÎñÆ÷½ÇÉ« Êý¾Ý¿â½ÇÉ«
·þÎñÆ÷½ÇÉ«
ËùÓеķþÎñÆ÷½ÇÉ«¶¼ÊÇ“¹Ì¶¨µÄ”½ÇÉ«£¬²¢ÇÒ£¬´ÓÒ»¿ªÊ¼¾Í´æÔÚÓÚÄÇÀï——×Ô°²×°ÍêSQL ServerµÄÄÇÒ»¿ÌÆð£¬Ä㽫ӵÓеÄËùÓзþÎñÆ÷½ÇÉ«¾ÍÒѾ´æÔÚÁË¡£
½Ç¡¡¡¡É«
ÌØ¡¡¡¡ÐÔ
sysadmin
¸Ã½ÇÉ«Äܹ»Ö´ÐÐSQL ServerÉϵÄÈκβÙ× ......
ÍêÈ«±¸·Ý»òÈÕÖ¾±¸·ÝËä˵¶¼ÓнضÏÈÕÖ¾µÄ¹¦ÄÜ,µ«ÊDz»»áÊÕËõÈÕÖ¾ÎļþµÄ¿Õ¼ä·µ»Ø¸ø²Ù×÷ϵͳ.
Èç¹ûÄãÏ뽫ÈÕÖ¾ÎļþµÄ¿Õ¼ä·µ»Ø¸ø²Ù×÷ϵͳµÄ»°,Ö»ÓÐÒ»ÖÖ·½·¨,¾ÍÊÇÊÕËõÊý¾Ý¿â(Ñ¡ÔñÈÕÖ¾Îļþ)
ZTÒ»¸öÏà¹ØÌû×Ó,¹©²Î¿¼!
ÎïÀíÈÕÖ¾Îļþ£º
Õâ¸ö±È½ÏºÃÀí½â£¬ÊµÊµÔÚÔڵĶ«Î÷£¬Êý¾Ý¿âĿ¼ÏÂÃæµÄ.ldfÎļþ¾ÍÊÇ£¬ÓÐЩÈËϲ»¶¸Äºó ......
Student(S#,Sname,Sage,Ssex) ѧÉú±í
Course(C#,Cname,T#) ¿Î³Ì±í
SC(S#,C#,score) ³É¼¨±í
Teacher(T#,Tname) ½Ìʦ±í
ÎÊÌ⣺
1¡¢²éѯ“001”¿Î³Ì±È“002”¿Î³Ì³É¼¨¸ßµÄËùÓÐѧÉúµÄѧºÅ£»
select a.S# from (select s#,score from SC where C#='001') a,(select s#,score
fr ......
ÒÔÏÂ×ªÔØ£¬ÔÎÄÕª×Ôhttp://www.cnblogs.com/fubeidong/archive/2007/07/06/526247.html
Êý¾Ý¿âÖÐÓиö×ֶνÐorderTime£¬ÊÇDateTimeÀàÐ͵ÄÊý¾Ý£¬Èç¹ûÎÒÃÇÓÃÒÔÏÂSQLÓï¾ä°ÑËüÈ¡³öÀ´£º
select
orderTime
from orders
Ôò»á°Ñʱ¼ä¶¼ÏÔʾ³öÀ´£¬¶øÈç¹û¸Ä³ÉÏÂÃæµÄSQLÓï¾ä£º
select
orderTime = convert(varchar(10),orderTime, ......