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
/*==========================================
Ïà¹ØÎĵµ£º
http://blog.csdn.net/iamstillzhang/archive/2007/04/01/1548377.aspx
ÓÃmysqlÔ´Âë½øÐÐSQL½âÎö
MysqlÊÇͨ¹ýyacc½øÐÐSQLÓï¾ä½âÎöµÄ£¬ÕâÀï½éÉÜÒ»ÏÂÈçºÎʹÓÃmysqlµÄÔ´Âë½øÐÐSQLÓï¾ä½âÎö¡£ÓÉÓÚMysqlµÄÔ´´úÂë×¢ÊͱȽÏÉÙ£¬¶øÇÒȱÉÙ×ÊÁÏ£¬ËùÓÐЩµØ·½Ñо¿²»¹»ÉîÈë¡£
1 Filed½éÉÜ
MY ......
ʹÓùý Access µÄÅóÓѶ¼ÖªµÀ£¬Access ÀïÓиö“ÊÇ/·ñ”Êý¾ÝÀàÐÍ£¬ÔÚ SQL Server ÖУ¬Ã»ÓÐÕâ¸öÃû³Æ£¬¶øʹÓà bit¡£ÔÚʹÓùý³ÌÖÐÓм¸µãÐèҪעÒâµÄ£º
£±¡¢bit Óë SQL Server µÄÕûÐͺÍÊý×ÖÊý¾ÝÏàËƵÄÊý×ÖÊý¾Ý£¬µ« bit ÁÐÖ»ÄÜ´æ´¢ 0 ºÍ 1¡£
£²¡¢ÔÚ²åÈë¡¢ÐÞ¸Ä bit Êý¾Ýʱ£¬Ê¹Óà 0 »ò 1 £¬¶ø²»ÊÇ false »ò true£¬bit ×Ö¶ ......
update CHELIANG_MINGDAN set clmd_yunxuzaizhong = cast(clmd_yunxuzaizhong/1000 as decimal(14,4)) where clmd_yunxuzaizhong is not null
update CHELIANG_MINGDAN set clmd_carweight = cast(clmd_carweight/1000 as decimal(14,4)) where clmd_carweight is not null ......
ÓÃSQLɾ³ýÖظ´¼Ç¼µÄNÖÖ·½·¨
2009-06-03 17:35
ÀýÈ磺
id name value
1 a &nbs ......
ORDER BY ÅÅÐò
ASC ÉýÐò(ĬÈÏ)
DESC ½µÐò
select * from s_emp order by dept_id , salary desc
²¿ÃźÅÉýÐò£¬¹¤×ʽµÐò
¹Ø¼ü×ÖdistinctÒ²»á´¥·¢ÅÅÐò²Ù×÷¡£
select * from employee order by 1; //°´µÚÒ»×Ö¶ÎÅÅÐò
NULL±»ÈÏΪÎÞÇî´ó¡£order by ¿ÉÒÔ¸ú±ðÃû¡£
select table_name ......