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

SQL Server×Ô¶¯ÒìµØ±¸·Ý·½·¨ (¾«Ñ¡)

SQL×Ô¶¯ÒìµØ±¸·Ý·½·¨
·½·¨Ò»£º 
mssqlÊý¾Ý¿âÔ¶³Ì±¸·ÝµÄjob
/*ÔÚÔ¶³Ì»úÆ÷²Ù×÷ϵͳµÄ¼ÆËã»ú¹ÜÀíÀィÁ¢Ò»¸öÓû§ÃûΪkyleµÄÓû§£¬ÃÜÂëΪ1234£¬Í¬Ê±ÔÚÄÇ̨»úÆ÷µÄ·ÇϵͳÅÌÀィһ¸öÃûΪbackupµÄ¹²ÏíÎļþ¼Ð£¬ÎªÁË°²È«ÁíÍâÉèÖÃÕâ¸öÎļþ¼ÐÖ»ÓÐÕâ¸ökyleÓû§¿ÉÒÔ·ÃÎÊ¡£*/
declare @sql varchar(500)
select @sql='\\10.2.0.12\backup\dbname'+'_db_'+convert(varchar(10),getdate(),112) +
substring(convert(varchar(10),getdate(),108),1,2) +'.bak'
exec master..xp_cmdshell 'net use \\10.2.0.12\backup 1234 /user:remotehost\kyle'
backup database dbname to disk=@sql --±¸·ÝÊý¾Ý¿â£¬ÕâÀïµÄ10.2.0.12ΪԶ³Ì»úÆ÷µÄip£¬remotehostΪԶ³Ì»úÆ÷µÄ»úÆ÷Ãû£¬dbnameΪ±¾µØsqlserver·þÎñÆ÷Òª±¸·ÝµÄÊý¾Ý¿â
go
declare @sql varchar(500)
select @sql='del '+'\\10.2.0.12\backup\dbname'+'_db_'+convert(varchar(10),dateadd(day,-7,getdate()),112) +
substring(convert(varchar(10),dateadd(day,-7,getdate()),108),1,2) +'.bak'
exec master..xp_cmdshell @sql --ɾ³ý7ÌìÇ°µÄ±¸·Ý£¬Ò²¾ÍÊÇÖ»±£Áô7¸ö×îб¸·Ý
go
·½·¨¶þ£º
 ÓÃSQL×Ô´øµÄschedule¶¨Ê±°ÑÊý¾Ý¿âbackupÉúÎļþ£¬ÓÃwindowsµÄ¼Æ»®ÈÎÎñ¶¨Ê±copyÎļþµ½ÆäËü»úÆ÷£¬ÔÙÓÃSQL×Ô´øµÄschedule¶¨Ê±°ÑÎļþrestore³ÉÊý¾Ý¿â¡£
Èç¹û´ÓÊý¾ÝÔ´»úÆ÷µÄEnterprise ManagerÖпÉÒÔ¿´µ½»òÌí¼Ó×¢²áÄ¿±êÊý¾Ý¿âµÄ»°£¨¼´¿ª·ÅÁË1433¶Ë¿Ú£©£¬¿ÉÒÔÑ¡ÔñÓõ¼³ö¹¦ÄÜ£¬ÔÚDTS wizardÖÐÑ¡ºÃÔ´Êý¾Ý¿âºÍÄ¿±êÊý¾Ý¿â£¬Ñ¡ÖÐÔ´Êý¾Ý¿âÖÐËùÓÐ±í£¬²¢¼ÇµÃÅäÖÃÿ¸ö±íµÄtransformÏîΪ“Çå¿ÕÄ¿±ê±í”£¬ÓÐ×ÔÔö³¤×ֶεĻ°ÒªÑ¡“ÔÊÐíÌí¼Ó×ÔÔö³¤×ֶΔ£¬½ÓÏÂÀ´ÒªÑ¡¶¨ÆÚÖ´Ðв¢Ñ¡ºÃ¼Æ»®£¬¾ÍOKÁË¡£
all taskÖÐÑ¡backupµÄʱºò£¬×îÏÂÃæÓÐÒ»Ïî¾ÍÊÇschedule
ÓÒ¼üµã»÷ÄãÒª±¸·ÝµÄÊý¾Ý¿â£¬µ¯³ö²Ëµ¥ÖÐÑ¡“ËùÓÐÈÎÎñ”Öеē±¸·ÝÊý¾Ý¿â”£¬×îÏÂÃæÑ¡ÖГ¼Æ»®±í”È»ºó¾Í¿ÉÒÔÉèÖö¨ÆÚÔËÐеģ¬Èç¹ûÄãµÄÊý¾Ý¿âÓõÄÊÇȱʡµÄÍêÈ«»Ö¸´Ä£Ê½£¬Ñ¡²îÒ챸·ÝÓ¦¸ÃÊDZȽϺÏÀíµÄÑ¡Ôñ£¬ÕâÑù±¸·ÝËÙ¶È×î¿ì¡£
·½·¨Èý£º
ÏÈ˵һÏÂ˼·£¬¾ÍÊÇÔÚ·þÎñÆ÷Éϱ¸·ÝÉú³ÉÎļþºó£¬ÔÙͨ¹ýDOSÃüÁ´ËÎļþCOPYµ½Áíһ̨µçÄÔ¡£
ÏÈÔÚ·þÎñÆ÷ÉÏÔËÐÐÊý¾Ý¿â±¸·Ý¡£
È»ºóÔÚÒìµØ»úÉϹ²ÏíÒ»¸öÎļþ¼Ð£¬×öΪ·þÎñÆ÷ÉϵÄÒ»¸öÓ³ÉäÍøÂçÇý¶¯Æ÷¡£
½«ÎļþCOPYµ½Õâ¸öÎļþ¼Ð¾ÍËãÍêÊÂÁË£¬µ«ÊÇÒªÔõôʵÏÖ×Ô¶¯²¢ÇÒ¶¨Ê±COPYÄØ£¿
¾ÍÓÃDOSÃüÁîÀ´ÊµÏÖ×


Ïà¹ØÎĵµ£º

MS SQL 2000/2005 Ð޸ıíËùÓÐÕß´æ´¢¹ý³Ì

Create PROCEDURE [dbo].[ChangeObjectOwner]
@OldOwner as NVARCHAR(128),
@NewOwner as NVARCHAR(128)
AS
DECLARE @Name   as NVARCHAR(128)
DECLARE @Owner  as NVARCHAR(128)
DECLARE @OwnerName as NVARCHAR(128)
DECLARE curObject CURSOR FOR
select 'Name' = name,
 'Owner'&n ......

SQL Server SQLÓï¾äµ¼Èëµ¼³ö´óÈ«

/*******  µ¼³öµ½excel
EXEC master..xp_cmdshell ’bcp SettleDB.dbo.shanghu out c:\temp1.xls -c -q -S"GNETDATA/GNETDATA" -U"sa" -P""’
/***********  µ¼ÈëExcel
SELECT *
from OpenDataSource( ’Microsoft.Jet.OLEDB.4.0’,
  ’Data Source="c:\test.xls";User ......

linq to sql ÖдÓdbmlÎļþÖд´½¨Êý¾Ý¿â

        ½ñÌìºÜÓôÃÆ,ʵÑéÊҵķþÎñÆ÷¶«Î÷¶¼Ã»ÓÐÁË,¶øÎÒµÄÊý¾Ý¿âÓÖÔÚÄÄÀï,ÎÒÓÖûÓб¸·Ý,°ÑÎÒÒÖÓôµÄÒªÃü,ÐÒ¿÷ÎÒÓõÄlinq to sql.×ÐϸÏëÏë,ËûµÄdbmlÎļþ»ù±¾°üº¬ÁËÊý¾Ý¿âµÄËùÓÐÄÚÈÝ,ËùÒÔ,Ò»¶¨Óа취´ÓdbmlÎļþÖд´½¨Êý¾Ý¿â!
        Ñо¿ÁËÒ»¶ÎÊ ......

SQL ServerÊý¾Ý¿âά»¤¼Æ»®µÄʵʩ²½Ö裨תÌû£©

¡¡ÎÒ¹«Ë¾ÔÚ×齨¾ÖÓòÍøʱ£¬¿¼Âǵ½ÉÌÒµÆóÒµµÄÌص㣬×Ðϸ¿¼Á¿Á˹º¡¢Ïú¡¢´æÈý´ó»·½ÚÖз¢ÉúµÄ¸÷ÖÖÊý¾Ý¼°Æä´æ´¢ÎÊÌâºó£¬Ñ¡¶¨ÁËÒÔWindows 2000 ServerΪ²Ù×÷ϵͳ£¬SQL Server 2000ΪÊý¾Ý¿âƽ̨À´´î½¨¾ÖÓòÍøµÄÓ¦ÓÃϵͳµÄÈí¼þƽ̨£¬ÒÔÍøÏßΪÔØÌ彫¹º¡¢Ïú¡¢´æµÈºËÐIJ¿ÃŵļÆËã»úͨ¹ý¾ÖÓòÍøƽ̨½ôÃܵØÁ¬½ÓÆðÀ´¡£ÕâÑù£¬¸÷¸öºËÐIJ¿ÃÅÿÌì ......

Sql Server²é¿´ËùÓÐÊý¾Ý¿âÃû,±íÃû,×Ö¶ÎÃûSQL

1.»ñÈ¡ËùÓÐÊý¾Ý¿âÃû:
SELECT Name from Master..SysDatabases ORDER BY Name
2.»ñÈ¡ËùÓбíÃû:
SELECT Name from DatabaseName..SysObjects Where XType='U' ORDER BY Name
XType='U':±íʾËùÓÐÓû§±í;
XType='S':±íʾËùÓÐϵͳ±í;
3.»ñÈ¡ËùÓÐ×Ö¶ÎÃû:
SELECT Name from SysColumns WHERE id=Object_Id('TableNam ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ