SQL Express×Ô¶¯±¸·Ý
--µÚÒ»²½
--ÔÚmaster¿âÖн¨Á¢Ò»¸ö±¸·ÝÊý¾Ý¿âµÄ´æ´¢¹ý³Ì.
USE master
GO
CREATE PROC p
@db_name sysname, --Êý¾Ý¿âÃû
@bk_path NVARCHAR(1024) --±¸·ÝÎļþµÄ·¾¶
AS
IF ISNULL(@db_name,'')=''
SET @db_name=db_name() ;
DECLARE @dt VARCHAR(50) ;
SET @dt=@db_name+'_'+CONVERT(VARCHAR(8) , GETDATE() ,112)+'_';
SET @dt=@dt+REPLACE(CONVERT(VARCHAR(10) ,GETDATE() ,108),':','')
IF RIGHT(@bk_path,1)<>'\'
SET @bk_path=@bk_path+'\';
EXEC ('BACKUP DATABASE ['+@db_name+'] TO DISK='''+@bk_path+@dt+'.bak'' WITH FORMAT');
GO
--µÚ¶þ²½
--ÔÚij¸öÎļþ¼ÐÀィÁ½¸ötxtÎļþ --ÈçD:\batComand.txt ¸úD:\BackupDatabase.txt
--È»ºóbatCommand.txtÎļþÄÚÈÝÈçÏÂ:
sqlcmd -Smyfend\liangck -E -iG:\BackupDatabase.sql
È»ºó±£´æ.½«À©Õ¹Ãû¸ÄΪ.bat
×¢:ÕâÀïµÄ-SÊÇ ·þÎñÆ÷Ãû\ʵÀýÃû -E ÊǼ¯³É°²È«ÐÔ
È»ºóBackupDatabase.txtÎļþÄÚÈÝÈçÏÂ:
USE master
GO
EXEC p 'Òª±¸·ÝµÄÊý¾Ý¿âÃû','G:\Backup\'
È»ºó±£´æ,½«À©Õ¹Ãû¸ÄΪ.sql
--µÚÈý²½
н¨ÈÎÎñ¼Æ»®.È»ºóÔÚÑ¡ÔñÖ´ÐÐÄĸöÈÎÎñµÄʱºò..µ¥»÷ä¯ÀÀ..Ñ¡ÔñD:\batCommand.bat
ÉèÖÃÿÌìÖ´ÐÐ..¼´¿É.
±¸·ÝʱµÄÎļþÃûÊÇ : Êý¾Ý¿âÃû_ÈÕÆÚ_ʱ¼ä.bak
Ïà¹ØÎĵµ£º
A¡£
SQLÓï¾äµÄ²¢¼¯UNION£¬½»¼¯JOIN(ÄÚÁ¬½Ó£¬ÍâÁ¬½Ó)£¬½»²æÁ¬½Ó(CROSS
JOINµÑ¿¨¶û»ý)£¬²î¼¯(NOT IN)
1.
a. ²¢¼¯UNION
SELECT column1, column2 from table1
UNION
SELECT column1, column2 from table2
b. ½»¼¯JOIN
SELECT * from table1 AS a JOIN table2 b ON a.name=b.name
c. ²î¼¯NOT IN
SELECT * from tabl ......
SQL·ÖÒ³
ÍòÄÜ·ÖÒ³
.net´úÂë
select top ÿҳÏÔʾµÄ¼Ç¼Êý * from topic where id not in
(select top £¨µ±Ç°µÄÒ³Êý-1£©×ÿҳÏÔʾµÄ¼Ç¼Êý id from topic order by id desc)  ......
´¥·¢Æ÷ÊÇÒ»ÖÖÌØÊâµÄ´æ´¢¹ý³Ì£¬ÀàËÆÓÚʼþº¯Êý£¬SQL Server™ ÔÊÐíΪ Insert¡¢Update¡¢Delete ´´½¨´¥·¢Æ÷£¬¼´µ±ÔÚ±íÖвåÈë¡¢¸üС¢É¾³ý¼Ç¼ʱ£¬´¥·¢Ò»¸ö»òһϵÁÐ T-SQLÓï¾ä¡£
´¥·¢Æ÷¿ÉÒÔÔÚ²éѯ·ÖÎöÆ÷Àï´´½¨£¬Ò²¿ÉÒÔÔÚ±íÃûÉϵãÓÒ¼ü->“ËùÓÐÈÎÎñ”->“¹ÜÀí´¥·¢Æ÷”À´´´½¨£¬²»¹ý¶¼ÊÇҪд T-SQL ......
SQL Server 2008ÆóÒµ°æ. SQL Server 2008ÆóÒµ°æÊÇÒ»¸öÈ«ÃæµÄÊý¾Ý¹ÜÀíºÍÒµÎñÖÇÄÜƽ̨£¬Îª¹Ø¼üÒµÎñÓ¦ÓÃÌṩÁËÆóÒµ¼¶µÄ¿ÉÀ©Õ¹ÐÔ¡¢Êý¾Ý²Ö¿â¡¢°²È«¡¢¸ß¼¶·ÖÎöºÍ±¨±íÖ§³Ö¡£ÕâÒ»°æ±¾½«ÎªÄãÌṩ¸ü¼Ó¼á¹ÌµÄ·þÎñÆ÷ºÍÖ´Ðдó¹æÄ£ÔÚÏßÊÂÎñ´¦Àí¡£
SQL Server 2008±ê×¼°æ. SQL Server 2008±ê×¼°æÊÇÒ»¸öÍêÕûµÄÊý¾Ý¹ÜÀíºÍÒµÎñÖÇÄÜƽ̨£¬Îª²¿ ......
תÔØ˵Ã÷£º¸øÕýÔÚ×öϵͳºÍÏë×öϵͳµÄÈË£¬SQL²©´ó¾«ÉÄãÃÇ»áÓõ½µÄ¡£——mAysWINd
Ò»¸öÌâÄ¿Éæ¼°µ½µÄ50¸öSqlÓï¾ä
Student(S#,Sname,Sage,Ssex) ѧÉú±í
Course(C#,Cname,T#) ¿Î³Ì±í
SC(S#,C#,score) ³É¼¨±í
Teacher(T#,Tname) ½Ìʦ±í
ÎÊÌ⣺
1¡¢²éѯ“001”¿Î³Ì±È“002”¿Î³Ì³É¼¨¸ßµ ......