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

SQL ServerʵÏÖÊý¾Ý¿â¶¨Ê±×Ô¶¯±¸·Ý

ÔÚSQL ServerÖгöÓÚÊý¾Ý°²È«µÄ¿¼ÂÇ£¬ËùÒÔÐèÒª¶¨Æڵı¸·ÝÊý¾Ý¿â¡£¶ø±¸·ÝÊý¾Ý¿âÒ»°ãÓÖÊÇÔÚÁ賿ʱ¼ä»ù±¾Ã»ÓÐÊý¾Ý¿â²Ù×÷µÄʱºò½øÐУ¬ËùÒÔÎÒÃDz»¿ÉÄÜÒªÇó¹ÜÀíԱÿÌìÊص½ÍíÉÏ1µãÈ¥±¸·ÝÊý¾Ý¿â¡£ÒªÊµÏÖÊý¾Ý¿âµÄ¶¨Ê±×Ô¶¯±¸·Ý£¬×î³£Óõķ½Ê½¾ÍÊÇʹÓÃSQL Server´úÀíÖеÄ×÷Òµ¡£Æô¶¯SQL Server Agent·þÎñ£¬È»ºóÔÚÆäÖÐн¨×÷Òµ£¬×÷ÒµÖÐÌí¼Ó1¸ö±¸·Ý²½Ö裬ÀàÐÍÊÇT-SQL½Å±¾£¬È»ºóÔÚÃüÁîÖÐÊäÈëÈçÏÂSQLÓï¾ä£¬¸ÃÓï¾äʵÏÖÁ˶ÔÊý¾Ý¿âTestDB1µÄÍêÕû±¸·Ý£¬±¸·ÝÎļþÔÚCÅÌBackupÎļþ¼ÐÖУ¬ÎļþÃû¾ÍÊÇTestDB1+µ±Ê±±¸·ÝµÄÈÕÆÚ×Ö·û´®.bak¡£
declare @name varchar(250) 
set @name='C:\Backup\TestDB1_'+ 
convert(varchar(50),getdate(),112)+'.bak' 
BACKUP DATABASE [TestDB1] TO  
DISK = @name 
WITH NOFORMAT, NOINIT,  
NAME = N'TestDB1-ÍêÕû Êý¾Ý¿â ±¸·Ý', 
SKIP, NOREWIND, NOUNLOAD
´´½¨ºÃ²½ÖèÒԺ󣬽ÓÏÂÀ´¾ÍÊÇ´´½¨¼Æ»®£¬´´½¨¼Æ»®µÄ²Ù×÷Ê®·Ö¼òµ¥£¬½çÃæÉÏ˵Ã÷µÄºÜÏêϸÁË£¬ÎҾͲ»¶à˵ÁË¡£ÁíÍ⻹¿ÉÒÔÅäÖþ¯±¨ºÍ֪ͨ£¬²»¹ýÒ»°ãºÜÉÙÓÃÕâ¸ö¡£
ʹÓÃSQL×÷ÒµÖÐÖ´ÐÐSQL½Å±¾½øÐб¸·ÝµÄ·½·¨ËäÈ»ÒѾ­ºÜ¼òµ¥ÁË£¬µ«ÊÇÖÁÉÙ»¹ÊÇҪȥдBACKUP½Å±¾£¬ÕâµãÓÐЩÈ˾õµÃ²»Ë¬£¬ÄÇÓÐûÓиü¼òµ¥£¬¸üÀÁµÄ·½·¨À´ÊµÏÖÊý¾Ý¿âµÄ×Ô¶¯¶¨Ê±±¸·ÝÄØ£¿ÓУ¬ÄǾÍÊǓά»¤¼Æ»®”¡£
“ά»¤¼Æ»®”ÊÇÔÚSSMSµÄ¶ÔÏó×ÊÔ´¹ÜÀíÖГ¹ÜÀ픽ڵãÏÂÃ档ʹÓÃά»¤¼Æ»®¿ÉÒÔͨ¹ý¿ÉÊÓ»¯µÄ²Ù×÷£¬Ö»µãµãÊó±ê¾Í¿ÉÒÔ´´½¨Êý¾Ý¿âά»¤µÄSSIS°ü£¬È»ºóÈÔÈ»ÊÇͨ¹ýSQL Server×÷ÒµµÄ·½Ê½À´ÔËÐС£Î¬»¤¼Æ»®ÓëÇ°Ãæ˵µ½µÄ±¸·Ý·½·¨±¾ÖʵIJ»Í¬¾ÍÊÇ£ºÎ¬»¤¼Æ»®ÊÇSSIS°ü£¬ÉÏÃæµÄÊÇT-SQL½Å±¾¡£
¼ÙÉèÎÒÃÇÏÖÔÚÓÐÒ»¸öÉú²úϵͳµÄÊý¾Ý¿âÐèÒª½øÐб¸·Ý£¬ÓÉÓÚÊý¾Ý¿âÖеÄÊý¾ÝºÜ¶à£¬Êý¾ÝÎļþºÜ´ó£¬Èç¹ûÿ´Î¶¼½øÐÐÍêÕû±¸·ÝÄÇôӲÅÌÕ¼ÓÃÁ˺ܴó¿Õ¼ä£¬¶øÇÒ±¸·Ýʱ¼äºÜ³¤£¬Î¬»¤ÆðÀ´Ò²ºÜÂé·³¡£¶Ô´ËÎÒÃÇ¿ÉÒÔ²ÉÓÃÍêÕû±¸·Ý+²îÒ챸·ÝµÄ·½Ê½£¬Ã¿ÖÜÈÕ½øÐÐÒ»´ÎÍêÕû±¸·Ý£¬Ã¿ÌìÍíÉϽøÐÐÒ»´Î²îÒ챸·Ý¡£Ê¹ÓòîÒ챸·Ý¿ÉÒÔ¼õС±¸·ÝÎļþµÄ´óС£¬Í¬Ê±»¹¿ÉÒÔÌá¸ß±¸·ÝµÄËٶȣ¬²»¹ýȱµã¾ÍÊDZØÐëʹÓÃÉÏÒ»´ÎÍêÕû±¸·ÝµÄÎļþºÍ²îÒ챸·ÝµÄÎļþ²ÅÄÜ»¹Ô­²îÒ챸·Ýʱ¿ÌµÄÊý¾Ý¿â£¬µ¥¶ÀÖ»ÓвîÒ챸·ÝÎļþÊÇûÓÐÒâÒå¡£
ÏÂÃæÎÒÀ´½²Ò»ÏÂÈçºÎͨ¹ýά»¤¼Æ»®À´ÊµÏÖÍêÕû±¸·Ý+²îÒ챸·Ý£º
£¨1£©ÔÚSSMSµÄ¶ÔÏó×ÊÔ´¹ÜÀíÆ÷ÖÐÓÒ»÷“ά»¤¼Æ»®”£¬Ñ¡Ôñ“ά»¤¼Æ»®Ï


Ïà¹ØÎĵµ£º

sql 2005 ´æ´¢¹ý³Ì·ÖÒ³ java ´úÂë

 create PROCEDURE pagelist
@tablename nvarchar(50),
@fieldname nvarchar(50)='*',         
@pagesize int output,--ÿҳÏÔʾ¼Ç¼ÌõÊý
@currentpage int output,--µÚ¼¸Ò³
@orderid nvarchar(50),--Ö÷¼üÅÅÐò
@sort int,--ÅÅÐò·½Ê½£¬1±íʾÉýÐò£¬0±íʾ½µÐòÅÅÁÐ ......

SQL×¢È멶´È«½Ó´¥

 
¿´ÍêÈëÃÅƪºÍ½ø½×ƪºó£¬ÉÔ¼ÓÁ·Ï°£¬ÆƽâÒ»°ãµÄÍøÕ¾ÊÇûÎÊÌâÁË¡£µ«Èç¹ûÅöµ½±íÃûÁÐÃû²Â²»µ½£¬»ò³ÌÐò×÷Õß¹ýÂËÁËһЩÌØÊâ×Ö·û£¬ÔõôÌá¸ß×¢ÈëµÄ³É¹¦ÂÊ£¿ÔõôÑùÌá¸ß²Â½âЧÂÊ£¿Çë´ó¼Ò½Ó×ÅÍùÏ¿´¸ß¼¶Æª¡£
µÚÒ»½Ú¡¢ÀûÓÃϵͳ±í×¢ÈëSQLServerÊý¾Ý¿â
SQLServerÊÇÒ»¸ö¹¦ÄÜÇ¿´óµÄÊý¾Ý¿âϵͳ£¬Óë²Ù×÷ϵͳҲÓнôÃܵÄÁªÏµ£¬Õâ¸ø¿ª·¢ ......

SQL*PLUSÃüÁî sql±à³ÌÊÖ²á

 Ò»¡¢SQL PLUS
1 ÒýÑÔ
SQLÃüÁî
ÒÔÏÂ17¸öÊÇ×÷ΪÓï¾ä¿ªÍ·µÄ¹Ø¼ü×Ö£º
alter  drop  revoke
audit  grant  rollback*
commit*  insert  select
comment  lock  update
create  noaudit  validate
delete  rename
ÕâЩÃüÁî±ØÐëÒÔ“;&rdqu ......

²é³öË­µÄ½±½ð×ܺÏÊÇ×î¸ßµÄ£¬SQLÓï¾ä

 Ô­ÎÄ´«ËÍÃÅ£ºhttp://topic.csdn.net/u/20091119/17/388cd1dd-4018-403f-a97f-0bc135895264.html?85256
Êý¾Ý¿âÀýÈç:
id      ÐÕ  Ãû  ½±  ½ð
1        ÕÅÈý    20Íò
2        ÀîËÄ    10Íò
3      ......

ms sql dateimeÖ®1905

 ÔÚ×ö“¶¼ÊмÒÔ°”ÓÅ»¯Ê±£¬¾ßÌåÊÇÓû§×¢²áʱ£¬Ìá½»ÐÅÏ¢£¬±¾À´BirthdayÊÇûÓÐдÈëÖµµÄ£¬´Ë×Ö¶ÎҲûÓÐĬÈÏÖµ£¬¿ÉÊý¾Ý¿âÖÐȴΪ“1905/3/14 0:00:00”£¬ÓôÃÆÖÁ¼«£¬ÉÏgoogle&baiduÒ²ÊÇûÓнâ¾öµÄ·½°¸¡£
Ö»ÄÜÕâÑùԭʼµÄ½â¾ö£º
Register ´æ´¢¹ý³Ì
   insert into UserInfo(UserID,sex) ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ