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µÄ¶ÔÏó×ÊÔ´¹ÜÀíÆ÷ÖÐÓÒ»÷“ά»¤¼Æ»®”£¬Ñ¡Ôñ“ά»¤¼Æ»®Ï
Ïà¹ØÎĵµ£º
create PROCEDURE pagelist
@tablename nvarchar(50),
@fieldname nvarchar(50)='*',
@pagesize int output,--ÿҳÏÔʾ¼Ç¼ÌõÊý
@currentpage int output,--µÚ¼¸Ò³
@orderid nvarchar(50),--Ö÷¼üÅÅÐò
@sort int,--ÅÅÐò·½Ê½£¬1±íʾÉýÐò£¬0±íʾ½µÐòÅÅÁÐ
......
¿´ÍêÈëÃÅƪºÍ½ø½×ƪºó£¬ÉÔ¼ÓÁ·Ï°£¬ÆƽâÒ»°ãµÄÍøÕ¾ÊÇûÎÊÌâÁË¡£µ«Èç¹ûÅöµ½±íÃûÁÐÃû²Â²»µ½£¬»ò³ÌÐò×÷Õß¹ýÂËÁËһЩÌØÊâ×Ö·û£¬ÔõôÌá¸ß×¢ÈëµÄ³É¹¦ÂÊ£¿ÔõôÑùÌá¸ß²Â½âЧÂÊ£¿Çë´ó¼Ò½Ó×ÅÍùÏ¿´¸ß¼¶Æª¡£
µÚÒ»½Ú¡¢ÀûÓÃϵͳ±í×¢ÈëSQLServerÊý¾Ý¿â
SQLServerÊÇÒ»¸ö¹¦ÄÜÇ¿´óµÄÊý¾Ý¿âϵͳ£¬Óë²Ù×÷ϵͳҲÓнôÃܵÄÁªÏµ£¬Õâ¸ø¿ª·¢ ......
Ò»¡¢SQL PLUS
1 ÒýÑÔ
SQLÃüÁî
ÒÔÏÂ17¸öÊÇ×÷ΪÓï¾ä¿ªÍ·µÄ¹Ø¼ü×Ö£º
alter drop revoke
audit grant rollback*
commit* insert select
comment lock update
create noaudit validate
delete rename
ÕâЩÃüÁî±ØÐëÒÔ“;&rdqu ......
ÔÎÄ´«ËÍÃÅ£ºhttp://topic.csdn.net/u/20091119/17/388cd1dd-4018-403f-a97f-0bc135895264.html?85256
Êý¾Ý¿âÀýÈç:
id ÐÕ Ãû ½± ½ð
1 ÕÅÈý 20Íò
2 ÀîËÄ 10Íò
3   ......
ÔÚ×ö“¶¼ÊмÒÔ°”ÓÅ»¯Ê±£¬¾ßÌåÊÇÓû§×¢²áʱ£¬Ìá½»ÐÅÏ¢£¬±¾À´BirthdayÊÇûÓÐдÈëÖµµÄ£¬´Ë×Ö¶ÎҲûÓÐĬÈÏÖµ£¬¿ÉÊý¾Ý¿âÖÐȴΪ“1905/3/14 0:00:00”£¬ÓôÃÆÖÁ¼«£¬ÉÏgoogle&baiduÒ²ÊÇûÓнâ¾öµÄ·½°¸¡£
Ö»ÄÜÕâÑùÔʼµÄ½â¾ö£º
Register ´æ´¢¹ý³Ì
insert into UserInfo(UserID,sex) ......