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
/*==========================================
Ïà¹ØÎĵµ£º
2009Äê06ÔÂ24ÈÕ 09:47
create table [±íÃû]
(
[×Ô¶¯±àºÅ×Ö¶Î] int IDENTITY (1,1) PRIMARY KEY ,
[×Ö¶Î1] nVarChar(50) default 'ĬÈÏÖµ' null ,
[×Ö¶Î2] ntext null ,
[×Ö¶Î3] datetime,
[×Ö¶Î4] money null ,
[×Ö¶Î5] int default 0,
[×Ö¶Î6] Decimal (12,4) default 0,
[×Ö¶Î7] image null ,
)
É ......
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 ÌṩÁËÇ¿´ó¶øÁé»îµÄÊÖ¶ÎÀ´²¶×½ºÍ´¦Àí³ÌÐò²úÉúµÄÒì³££¬´Ó¶øÊ¹ oracle µÄÓû§Ô¶ÀëһЩÁîÈË·³ÄÕµÄ bug ¡£
pl/sql Òì³£´¦ÀíµÄ¸ÅÄîºÍÊõÓï
ÔÚ oracle ÖÐËùÓеĴíÎó¶¼±»ÈÏΪÊDz»Ó¦¸Ã·¢ÉúµÄÒì³£¡£Ò»¸öÒì³£¿ÉÄÜÊÇÒÔÏ 3 ÖÖÇé¿öµÄÒ»ÖÖ£º
u ÓÉϵͳ²úÉúµÄ´íÎó£¨& ......
×°ÁËSQL2000ºó°²×°SQL2005,ËäȻʹÓñðÃû¼ÓÒÔÇø±ðÁË£¬µ«·¢ÏÖ2005ÖÐûÓпɹ©·ÃÎʵÄÀàËÆÆóÒµ¹ÜÀíÆ÷£¬Ò»Ê±³å¶¯£¬Ð¶ÁË2000£¬ÍêÕû°²×°ÁË2005£¬·¢ÏÖ»¹ÊÇûÓÐÆóÒµ¹ÜÀíÆ÷£¬ËÑË÷¹ýºó²Å·¢ÏÖÐèÒª°²×°SQLServer2005_SSMSEE.msi£¨¼´SQLServerManagerStudioExpressEdition£©£¬ËüÌṩÁËÀàËÆÆóÒµ¹ÜÀíÆ÷µÄͼÐλ¯²Ù×÷½çÃæ¡£
×°ºÃºó£¬SQL ......