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

Sql Server2005ʵÏÖÔ¶³Ì±¸·ÝÊý¾Ý¿â

 
ÏàÐÅ´ó¼Ò¶¼ÔÚµ±ÐÄÊý¾Ý¿âµÄ¶ªÊ§£¬ÕâÒ²ÊÇÿ¸ö¿ª·¢ÕßÍ·Í´µÄÒ»¼þʼþ£¬ÒòΪÕýÔÚÔËÐеķþÎñÆ÷¼°Êý¾Ý¿âÒ²ÔÚÕą̂·þÎñÆ÷ÉÏ¡£Èç¹û·þÎñÆ÷±ÀÀ££¬ÄÇôËùÓеÄÊý¾Ý
¶¼²»´æÔÚÁË£¬¾ÍËãÊÇÄãÔÚÄãµÄ»ú×ÓÉÏ×öÁ˱¸·Ý£¬ÄÇÒ²ÊÇûÓÐÓõģ¬ÎªÊ²Ã´»áÕâÑù˵Ö÷ÒªÊÇÒòΪ±¾»úÊÇÏò»¥ÁªÍø¹«¿ªµÄ£¬ËùÒÔ³öʹʵĸÅÂʾͱȽϸߡ£×îÖÕÎÒÃÇ¿ÉÒÔÀû
ÓþÖÓòÍø½â¾öÕâÑùµÄÎÊÌâ¡£¾ÍÄÃÁ½Ì¨»ú×Ó×öÀý×Ó£¬A»úÊÇ·þÎñÆ÷£¬B»úÊÇÒª°ÑA·þÎñÆ÷ÉϵÄÊý¾Ý¿â±¸·Ýµ½B»úÉÏ£¬Ç°ÌáÊÇB»ú±ØÐëÒªÓÐÊý¾Ý¿â£¬ÒÔSql
Server2005ΪÀý¡£
Ê×ÏÈA»ú±ØÐë¾ß±¸Êý¾Ý¿â£¬³ÌÐò£¬IIS£¬B»ú±ØÐë¾ß±¸Êý¾Ý¿â£¬·þÎñ³ÌÐò¡£Ç°ÌáÊÇB»ú±ØÐëÖªµÀA»úµÄ»úÆ÷ÃÜÂë¡£
Æä´Î´úÂë²Ù×÷ÈçÏ ÕâÖ»ÊÇ´æ´¢¹ý³Ì
  1
IF
 
NOT
 
EXISTS
 (
SELECT
 
*
 
from
 sys.objects 
WHERE
 
object_id
 
=
 
OBJECT_ID
(N
'
[dbo].[BackSqlorFile]
'

AND
 type 
in
 (N
'
P
'
, N
'
PC
'
))
  2
BEGIN
  3
EXEC
 dbo.sp_executesql 
@statement
 
=
 N
'
  4
  5
  6
CREATE proc [dbo].[BackSqlorFile]
  7
@ServerIp varchar(50),--Êý¾Ý¿â·þÎñÆ÷IP
  8
@ServerName varchar(50),--Êý¾Ý¿â¼ÆËã»úÓû§
  9
@ServerPwd   varchar(50),--Êý¾Ý¿â¼ÆËã»úÓû§ÃÜÂë
 10
@ServerIISIp varchar(50),--IIs·þÎñÆ÷Ip
 11
@ServerIIsName varchar(50),--IIs·þÎñÆ÷Ãû³Æ
 12
@ServerIIsPwd  varchar(50),--IIs·þÎñÆ÷ÃÜÂë
 13
@SqlShareFile    varchar(50),--Ô¶³Ìsql¹²ÏíÎļþ
 14
@IIsShareFile   varchar(50),--Ô¶³ÌIIS¹²ÏíÎļþ
 15
@MoveIIsPath   varchar(50),--d:\back
 16
@MoveSqlPath   varchar(50),--d:\sql
 17
@DataName      varchar(50),--Êý¾Ý¿âÃû³Æ
 18
@SqlloginName varchar(50),--Ô¶³ÌÊý¾Ý¿âµÇ½Ãû³Æ
 19
@SqlLoginPwd  varchar(50)--Ô¶³ÌÊý¾Ý¿âµÇ½ÃÜÂë
 20
as
 21
begin
 22
/*==========================================


Ïà¹ØÎĵµ£º

SQL SERVER ²é¿´CPUÀûÓÃÂÊ

 --²é¿´CPUÀûÓÃÂÊ
-- CREATE PROCEDURE sp_GetTop10_CPU () AS
BEGIN
  SET NOCOUNT ON
  DECLARE @cinterval char(8)
  DECLARE @interval int
  SET @cinterval = '00:00:10'
  CREATE TABLE #thread
  (
    RUN INT NOT NULL,
    SPI ......

SQLÈÕÆÚ¸ñʽ»¯Ó¦ÓôóÈ«

Sql Server ÖÐÒ»¸ö·Ç³£Ç¿´óµÄÈÕÆÚ¸ñʽ»¯º¯Êý
Select CONVERT(varchar(100), GETDATE(), 0): 05 16 2006 10:57AM
Select CONVERT(varchar(100), GETDATE(), 1): 05/16/06
Select CONVERT(varchar(100), GETDATE(), 2): 06.05.16
Select CONVERT(varchar(100), GETDATE(), 3): 16/05/06
Select CONVERT(varchar(100), GE ......

pl/sqlÀûÓÃrownumÈ¡µÃÅÅÐòºóµÄ²¿·ÖÐÐÐòÁÐ

ÎÒÃÇʹÓÃoracleµÄÈ˶¼ÖªµÀ¿ÉÒÔͨ¹ýrownumαÁеõ½²éѯ½á¹ûÐòÁÐÇ°ÃæµÄÖ¸¶¨µÄÐУ¬ÎªÁËÏÂÃæ¸üºÃµÄ½øÐÐ˵Ã÷ÎÊÌ⣬ÎÒÃÇÏÈÀ´´´½¨Ò»¸öÊý¾Ý±ítable1£º
create table table1
(AAA integer primary key,
BBB varchar(30));
È»ºóÔÚtable1ÖвåÈë9ÌõÊý¾Ý£º
insert into table1 values (8, 'good');
insert into table1 values (7 ......

Sql Server·¢ÓʼþÅäÖÃ

¡¡Ç°Ì᣺°²×°sqlserver£¬°²×°outlook£¬outlookÒѾ­ÕýÈ·ÅäÖá£
    £¨1£©ÅäÖÃsqlserverµÄÆô¶¯Óû§ÎªÓòÓû§¡£sqlserverÆô¶¯Ä¬Èϵı¾µØÕË»§£¬±¾µØÕË»§Æô¶¯µÄ·þÎñÊÇÎÞ·¨Íê³ÉÓʼþµÄ·¢ËͽÓÊܹ¦Äܵġ£
     ÅäÖÃÓòÓû§Æô¶¯£º´ò¿ª¿ØÖÆÃæ°åµÄ--¹ÜÀí¹¤¾ß--·þÎñ£¬ÕÒµ½sqlserver·þÎñ£¬²é¿´ÊôÐÔ¡£Ô ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ