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
 
Ïà¹ØÎĵµ£º
========µÚһƪ=========
ÔÚÒ»ÕűíÖÐij¸ö×Ö¶ÎÏÂÃæÓÐÖØ¸´¼Ç¼£¬Óкܶ෽·¨£¬µ«ÊÇÓÐÒ»¸ö·½·¨£¬ÊDZȽϸßЧµÄ£¬ÈçÏÂÓï¾ä£º
select data_guid from adam_entity_datas a where a.rowid > (select min(b.rowid) from adam_entity_datas b where b.data_guid = a.data_guid)
Èç¹û±íÖÐÓдóÁ¿Êý¾Ý£¬µ«ÊÇÖØ¸´Êý¾Ý±È½ÏÉÙ£¬ÄÇô ......
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 ÐÐ
ÎÞ·¨Ö´ÐиòÙ×÷£¬ÒòΪÁ´½Ó·þÎñ ......
½«b±íÖÐcallerÁеÄÖµ²åÈëa±íÖÐcallÁÐÖС£
create table a
(
fid int,
call varchar(20),
age int
)
create table b
(
fid int,
caller varchar(20),
parentId int
)
select * from a
select * from b
insert into a values(1,null,19)
insert into a values(2,n ......
ǰ¶Îʱ¼ä×öÁËÒ»¸öÐéÄâ×éÖ¯µÄ´´½¨¡£Õâ¸öÐéÄâ×éÖ¯µÄ´´½¨ÊÇ´ÓÏÖÓеÄ×éÖ¯ÖжÁÈ¡Êý¾ÝÈ»ºó½øÐзÖÎö±£´æµ½ÐéÄâ×éÖ¯±íÖС£±£´æÖ®ºóдÈÕÖ¾·½±ãͬ²½µ½ÆäËüϵͳÖС£¹«Ë¾Ê¹ÓõÄÖ÷Òª¼¼ÊõÊÇSSH¡£ÓÉÓÚÊÇÐÂÈËûÓÐʲô¾Ñ飬¼Ó֮ʱ¼ä±È½Ï½ôÆÈ£¬×îºóʹÓÃÒ»°ãµÄÂ߼˼Ïëͨ¹ýµÝ¹éÔÚhibernateÏÂ˳Àû´´½¨ÁË¡£¿ÉÊÇ´ÓÏÖÓеÄ×éÖ¯Ö ......