Sql Server 2005/2008±¸·Ý/ɾ³ý¹ýÆÚ±¸·ÝT
USE [master]
GO
/****** ¶ÔÏó: StoredProcedure [dbo].[sp_backupdatabase] ½Å±¾ÈÕÆÚ: 07/15/2009 16:23:56 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE proc [dbo].[sp_backupdatabase]
@bak_path nvarchar(4000)='', --±¸·Ý·¾¶;
@baktype int = null, --±¸·ÝÀàÐÍ0Ϊȫ±¸,1Ϊ²îÒ챸,2ΪÈÕÖ¾±¸·Ý
@type int = null, --ÉèÖÃÐèÒª±¸·ÝµÄ¿â,0Ϊȫ²¿¿â,1Ϊϵͳ¿â,2Ϊȫ²¿Óû§¿â,3Ϊָ¶¨¿â,4ΪÅųýÖ¸¶¨¿â;
@dbnames nvarchar(4000)='', --ÐèÒª±¸·Ý»òÅųýµÄÊý¾Ý¿â£¬ÓÃ,¸ô¿ª£¬µ±@type=3»ò4ʱÉúЧ
@overdueDay int = null, --ÉèÖùýÆÚÌìÊý£¬Ä¬ÈÏÌì;
@compression int =0 --ÊÇ·ñ²ÉÓÃsql2008µÄѹËõ±¸·Ý,0Ϊ·ñ,1Ϊ²ÉÓÃѹËõ
as
--sql server 2005/2008±¸·Ý/ɾ³ý¹ýÆÚ±¸·ÝT-sql °æ±¾v1.0
/*
author:perfectaction
date :2009.04
desc :ÊÊÓÃÓÚsql2005/2008±¸·Ý£¬×Ô¶¯Éú³É¿âÎļþ¼Ð£¬¿ÉÒÔ×Ô¶¨Ò屸·ÝÀàÐͺͱ¸·Ý¿âÃûµÈ
¿ÉÒÔ×Ô¶¨Ò屸·Ý¹ýÆÚµÄÌìÊý
ɾ³ý¹ýÆÚ±¸·Ý¹¦Äܲ»»áɾ³ý×îºóÒ»´Î±¸·Ý£¬ÄÄÅÂÒѾ¹ýÆÚ
Èç¹ûij¿â²»ÔÙ±¸·Ý£¬ÄÇôҲ²»»áÔÙɾ³ý֮ǰ¹ýÆÚµÄ±¸·Ý
ÈçÓдíÎóÇëÖ¸Õý£¬Ð»Ð».
*/
set nocount on
--¿ªÆôxp_cmdshellÖ§³Ö
exec sp_configure 'show advanced options', 1
reconfigure with override
exec sp_configure 'xp_cmdshell', 1
reconfigure with override
exec sp_configure 'show advanced options', 0
reconfigure with override
print char(13)+'------------------------'
--ÅжÏÊÇ·ñÌîд·¾¶
if isnull(@bak_path,'')=''
begin
 
Ïà¹ØÎĵµ£º
CLR¿ÉÒÔʵÏÖDMLºÍDDLÁ½ÖÖ´¥·¢ÐÎʽ£¬µ«ÊDZ¾ÈËÒ»°ã²»½¨ÒéʹÓÃCLRµÄ´¥·¢Æ÷£¬Ö÷ÒªÊÇ¿¼Âǵ½Ð§ÂÊÎÊÌâ¡£±ÈÈçÎÒÃÇʹÓÃtriggerÀ´ÊµÏÖ·¢mailµÈ²Ù×÷ʱ£¬¾ÍÒª¿¼ÂÇpop3»òÊÇsmtpµÈ´ýʱ¼ä£¬ÒòΪtrigger±¾Ê¾ÍÊǸöÊÂÎñ£¬Ò²¾ÍÊÇ˵£¬ÔÚsmtpµÈ´ýʱ¼äÒ²ËãÔÚÁËÕû¸öÊÂÎñÖУ¬ÕâÑù¾Í»á´ó´óÓ°ÏìЧÂÊ¡£
1.CLR DML´¥·¢Æ÷
DMLÖ¸µÄÊÇÊý¾Ý²Ù×÷ÓïÑÔ£¬Ò²¾Í ......
2000·¢²¼Óë¶©ÔÄ
Ô¤±¸¹¤×÷
1.·¢²¼·þÎñÆ÷,¶©ÔÄ·þÎñÆ÷¶¼´´½¨Ò»¸öͬÃûµÄwindowsÓû§,²¢ÉèÖÃÏàͬµÄÃÜÂë,×öΪ·¢²¼¿ìÕÕÎļþ¼ÐµÄÓÐЧ·ÃÎÊÓû§
--¹ÜÀí¹¤¾ß
--¼ÆËã»ú¹ÜÀí
--Óû§ºÍ×é
--ÓÒ¼üÓû§
--н¨Óû§
--½¨Á¢Ò»¸öÁ¥ÊôÓÚadministrator×éµÄµÇ½windowsµÄÓû§£¨SynUser£©
2.ÔÚ·¢²¼·þÎñÆ÷ÉÏ,н¨Ò»¸ö¹²ÏíĿ¼ ......
sql server·Ö²¼Ê½ÊÂÎñ½â¾ö·½°¸
ÊÊÓû·¾³
²Ù×÷ϵͳ£ºwindows 2003
Êý¾Ý¿â£ºsql server 2000/sql server 2005
ʹÓÃÁ´½Ó·þÎñÆ÷½øÐÐÔ¶³ÌÊý¾Ý¿â·ÃÎʵÄÇé¿ö
Ò»¡¢ ÎÊÌâÏÖÏó
ÔÚÖ´Ðзֲ¼Ê½ÊÂÎñʱ£¬ÔÚsql server 2005ÏÂÊÕµ½ÈçÏ´íÎó£º
ÏûÏ¢ 7391£¬¼¶±ð 16£¬×´Ì¬ 2£¬¹ý³Ì xxxxx£¬µÚ 16 ÐÐ
ÎÞ·¨Ö´ÐиòÙ×÷£¬ÒòΪÁ´½Ó·þÎñ ......
(1)SEQNAME.NEXTVALÀïÃæµÄÖµÈçºÎ¶Á³öÀ´£¿¿ÉÒÔÖ±½ÓÔÚinsert into test values(SEQNAME.NEXTVAL) ÊÇ¿ÉÒÔÓà ÕâÑù£º
SELECT tmp#_seq.NEXTVAL
INTO id_temp
from DUAL; È»ºó¿ÉÒ ......
ÍâÁ¬½ÓÈ¡Êý¾ÝÈç¹ûΪ¿Õ£¬²»´æÔÚASʱ¿ÉÄÜÈ¡µ½Êý¾Ý£¬µ«¼ÓÁËAS¾Í»á±¨´í¡£±ÈÈçSelect Top 10 a.*,b.Class AS ClassId
,b.DeviceName from AuxBusInfo a Left Join DeviceCandidate b On a.InitialDeviceRscId = b.DeviceRscId Order By AuxBusId£¬µ± ......