Microsoft SQL Server 2005 ÕûºÏ¡¢¼¯³ÉSP3·½·¨
½âѹ SQLServer2005SP3-KB955706-x86-CHS.exe Îļþ(ʹÓà WinRAR ¿ÉÖ±½Ó½âѹ,»òʹÓà /extract)
½âѹºóÎļþ¼Ð ËÑË÷ “*.msi *.msp” £¬È»ºó¸´ÖÆËùÓÐËÑË÷µ½µÄÎļþ ·Åµ½ D:\SQL2005\SP3 ÖÐ.
ÌáÈ¡ cs_sql_dev_all_dvd.iso(SQL Server 2005 ¿ª·¢°æ) ÖÐµÄ x86 °æ±¾£¬·Åµ½ D:\SQL2005\MSSQL ÖУ»´Ëʱ D:\SQL2005\MSSQL ÖÐÓ¦¸ÃÓÐÒÔÏÂÎļþºÍÎļþ¼Ð autorun.inf£¬Servers£¬Tools¡£
È»ºó°ÑÒÔÏ´úÂë´æΪD:\SQL2005\Install.cmd£¬²¢Ë«»÷ÔËÐС£
----------------------------------------------------------------------------------------------------
@ECHO OFF
ECHO /////////////////////////////////////////////////
ECHO // Microsoft SQL Server 2005 ÕûºÏ¡¢¼¯³ÉSP3
ECHO // Author : ÁøÓÀ·¨
ECHO // Date : 2008-12-19
ECHO // Modi : 2008-12-22
ECHO // Version : 1.1
ECHO // Web : http://www.yongfa365.com/
ECHO // URL : http://www.yongfa365.com/Item/Microsoft-SQL-Server-2005-With-SP3.html
ECHO /////////////////////////////////////////////////
ECHO ÔËÐдËÅú´¦ÀíÇ°£¬µÃ½¨Ä¿Â¼£ºD:\SQL2005,D:\SQL2005\SP3,D:\SQL2005\MSSQL
ECHO D:\SQL2005\MSSQL °ÑSQL Server 2005ÔDVD¹âÅÌÀïµÄX86Ŀ¼ÏµÄËùÓÐÎļþCopyµ½ÕâÀï
ECHO D:\SQL2005\SP3 °ÑÏÂÔØÀ´µÄSP3Îļþ½âѹ£¬²¢ËÑË÷"*.msi *.msp"¸´ÖÆÈ«²¿£¬È»ºó·Åµ½Õâ¸öĿ¼ÏÂ
ECHO ¸üÐÂServers»·¾³Îļþ
XCOPY /Y /H D:\SQL2005\SP3\*.msi D:\SQL2005\MSSQL\Servers\Setup\
RD /S /Q D:\SQL2005\SWAP
MD D:\SQL2005\SWAP
ECHO ÊÍ·ÅServersÎļþ ʱ¼ä±È½Ï³¤ ÇëÄÍÐĵȴý
msiexec /quiet /a D:\SQL2005\MSSQL\Servers\Setup\sqlrun_as.msi TARGETDIR=D:\SQL2005\SWAP /L*vx D:\SQL2005\Install.log
msiexec /quiet /a D:\SQL2005\MSSQL\Servers\Setup\sqlrun_dts.msi TARGETDIR=D:\SQL2005\SWAP /L*vx D:\SQL2005\Install.log
msiexec /quiet /a D:\SQL2005\MSSQL\Servers\Setup\sqlrun_ns.msi TARGETDIR=D:\SQL2005\SWAP /L*vx D:\SQL2005\Install.log
msiexec /quiet /a D:\SQL2005\MSSQL\Servers\Setup\sqlrun_rs.msi TARGETDIR=D:\SQL2005\SWAP /L*vx D:\SQL2005\Install.log
msiexec /quiet /a D:\SQL2005\MSSQL\Servers\Setup\sqlrun_sql.msi TARGETDIR=D:\SQL20
Ïà¹ØÎĵµ£º
Éϼ¯ÖÐ
//////////////////////////////////////////////////
select n5001 Ãŵê,n5002 ²¿ÃÅ,n5004 С·ÖÀà,n5019 ÉÌÆ·±àÂë,c01d21 ÉÌÆ·Ãû³Æ,
nvl(xse,0)-nvl(dzxs,0) ÏúÊÛ,
mle ëÀû,
nvl(xl,0)-nvl(dzsl,0) ÏúÁ¿
from
(select n5001,n5002,n5004,n5019,sum(n5011) xse,sum(n5016) mle,sum(n5023) xl
from ......
ÔÚ³ÌÐòÖÐÎÒÃÇ¿ÉÄܾ³£»áÓöµ½ÕâÖÖÇé¿ö£¬±ÈÈçҪȡһ¸ölistboxÀïÃæµÄÑ¡ÔñÏµÃµ½µÄ½á¹û¿ÉÄÜÊÇstring ID="id1,id2,id3,id4",È»ºóÎÒÃÇÒª°ÑÕâЩID²åÈëµ½Êý¾Ý¿âÖУ¬Í¬Ê±Ã¿¸öid¶ÔÓ¦µÄÊÇÒª²åÈëÒ»Ìõ¼Ç¼¡£ÊµÏֵķ½·¨Óкܶ࣬µ«ÊÇÈç¹ûÎÒÃÇͨ¹ýÏÂÃæÕâ¸öº¯Êý£¨RecurrentSplit£©¾ÍÄܼòµ¥µÄ´ïµ½ ......
http://kang275284.javaeye.com/blog/154331
Ò»¡¢ ÏȽéÉÜÒ»ÏÂoracle
µÄSGA£ºÊý¾Ý¿âµÄϵͳȫ¾ÖÇø£¬SGAÖ÷ÒªÓÉÈý²¿·Ö¹¹
³É£º¹²Ïí³Ø¡¢Êý¾Ý»º³åÇø¡¢ÈÕÖ¾»º³åÇø¡£
1¡¢ ¹²Ïí³ØÓÖÓÉÁ½²¿·Ö¹¹³É£º¹²ÏíSQL
Çø
ºÍÊý¾Ý×ֵ仺³åÇø¡£¹²ÏíSQL
ÇøרÃÅ´æ·ÅÓû§SQL
Ãü
Áoracle
ʹÓÃ×î½ü×îÉÙʹÓõÈÓÅÏȼ¶Ëã·¨À´¸üи²¸Ç£ ......
ÎÒÏëÃæÊÔ¹ýÈí¼þ¿ª·¢µÄÅóÓѶ¼»áÅöµ½sql·½ÃæµÄÃæÊÔÌ⣬Õâ¸ö¿ÉÒÔ˵ÊÇÃæÊԱؿ¼µÄ¡£ÕâÀïÄü¸¸öÀý×Ó¿ªÍØÒ»ÏÂ˼·¡£
1.
ÓÐÕâÑùÒ»Õűí
½ÌʦºÅ
ÐÇÆÚ
ÊÇ·ñÓпÎ
1
1
ÓÐ
2
3
ÓÐ
1
2
ÓÐ
1
2
ÓÐ
ÒªµÃ³öÕâÑùµÄÊý¾Ý£º
ÐÕÃû
ÐÇÆÚÒ»
ÐÇÆÚ¶þ
ÐÇÆÚÈý
ÐÇÆÚËÄ
ÐÇÆÚÎå
1
1
......