ÖÕ¼¶½â¾öSQL Server 2005 δÕý³£Ð¶ÔØ£¬ÖØÐ°²×°ÎÊÌâ
ÔÚÐ¶ÔØVisual Studio 2008 ʱ£¬Ìí¼Ó/ɾ³ý³ÌÐò ÀïÃæÓÐÐí¶àµÄ°²×°Îļþ£¬´ËʱÈç¹ûûÓÐÏÈÐ¶ÔØSQL Server 2005 £¬
¶øÏÈÐ¶ÔØ.Net Framework£¨Ìáʾ£ºÐ¶ÔØ.net FrameworkµÄµÃ°²°æ±¾´Ó¸ßµ½µÍµÄ˳Ðò£©£¬
ÕâʱSQL Server 2005¾ÍÎÞ·¨Ð¶ÔØ,ɾ³ýProgram files ÏÂÃæµÄ Microsoft SQL Server Îļþ¼ÐҲûÓÐ×÷Óá£
ÖØÐ°²×°ÌáʾÊý¾Ý¿âʵÀýÒѾ´æÔÚ£¬ÇëÖØÐÂÑ¡ÔñÁíÒ»¸öʵÀýÃû³Æ¡£
¾¹ý×Ðϸ·ÖÎö£¬Òѽâ¾öÈçÉÏÎÊÌâ¡£½â¾ö²½ÖèÈçÏÂ:
1.Í£ÓÃWindows 2003 ϵÄÊý¾Ý¿â·þÎñ,ÓÒ¼üµã»÷ÎҵĵçÄÔ-->¹ÜÀí-->·þÎñ,Í£ÓÃSQL Server (MSSQLSERVER)¡¢SQL Server Agent (MSSQLSERVER)¡¢SQL Server FullText Search (MSSQLSERVER)¡¢SQL Server Browser¡¢SQL Server VSS WriterµÈSQL Server Ïà¹Ø·þÎñ.
2.½øÈë×¢²á±í(regedit)-->HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services £¬
ÕÒµ½²½Öè1ËùÍ£ÓõÄSQL ServerÏà¹Ø·þÎñ×¢²á±íÏ½«Æäɾ³ý¡£
3¡£½øÈë×¢²á±í(regedit)--
>HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft,
ÕÒµ½Microsoft SQL Server¡¢
Microsoft SQL Server 2005 Redist¡¢
MSSQLServer
×¢²á±íÏ½«Æäɾ³ý¡£
4¡£ÖØÐÂÆô¶¯µçÄÔ£¬°²×°SQL Server2005³É¹¦£¡
¸½£ºÈç¹û°²×°SQL Server2005 ÌáʾSQLXML4°²×°³ö´í£¬´Ëʱ¿É½øÈëÌí¼Ó/ɾ³ý³ÌÐò ½«ÒѰ²×°¹ýµÄSQLXML4ɾ³ý£¬ÔÙÖØÐ°²×°SQL Server 2005,ÎÊÌâ½â¾ö£¡(´ËÎÊÌâÊÇÒòΪ£¬SQL Server 2005Ëù´øµÄSQLXML4°æ±¾ÎÊÌâÒýÆðµÄ)£¡
Áí£ºÔø¾Åöµ½ÔÚWindow2003SP2ÏÂÎÞ·¨°²×°SQL Server 2005£¬Èç¹û³¢ÊÔÆäËüµÄ·½·¨¶¼ÎÞ·¨½â¾ö£¬ÄÇô´ËÎÊÌâºÜ¿ÉÄÜÊÇÒòΪ Winodws Installer MSXML 6.0 Parser[6.00.3883.8]ÒýÆðµÄ£¬´ó¼Ò¿Éµ½ÍøÉÏÏÂÔØWinodws Installer Clean Up À´Çå³ý´ËÏî.
×ÊÁÏÒýÓÃ:http://www.knowsky.com/533046.html
Ïà¹ØÎĵµ£º
Ô¶³ÌÁ´½Ó·þÎñÆ÷ÏêϸÅäÖÃ
--
½¨Á¢Á¬½Ó·þÎñÆ÷
EXEC
sp_addlinkedserver
'
Ô¶³Ì·þÎñÆ÷IP
'
,
'
SQL Server
'
--
±ê×¢´æ´¢
EXEC
sp_addlinkedserver
@server
=
'
server
'
,
--
Á´½Ó·þÎñÆ÷µÄ±¾µØÃû³Æ¡£Ò²ÔÊÐíʹÓÃʵÀýÃû³Æ£¬ÀýÈçMYSERVER\SQL1
@srvproduct
=
'
product_name
......
±¾ÎÄÑÝʾÁË SQL Server 2005 ·ÖÇø±í·ÖÇøÇл»µÄÈýÖÖÐÎʽ£º
1. Çл»·ÖÇø±íµÄÒ»¸ö·ÖÇøµ½ÆÕͨÊý¾Ý±íÖУºPartition to Table£»
2. Çл»ÆÕͨ±íÊý¾Ýµ½·ÖÇø±íµÄÒ»¸ö·ÖÇøÖУºTable to Partition£»
3. Çл»·ÖÇø±íµÄ·ÖÇøµ½ÁíÒ»·ÖÇø±í£ºPartition to Partition¡£
²¢Ö¸³öÁËÔÚ·ÖÇø±í·ÖÇøÇл»¹ý³ÌÖеÄ×¢ÒâÊÂÏî¡£
-- ´´½¨·ÖÇøº¯Ê ......
Ò»¡¢É¶ÊÇsql×¢Èë
Ëùνsql×¢Èë¼òµ¥Ëµ¾ÍÊDZ»ÈË×êÁËSQLµÄ¿Õ×ÓÏÂÃæ¾Ù¸ö×î¼òµ¥µÄÀý×Ó¡£
sql Ϊ£º"select * from users where username='"+userName+"' and password='"+password+"' "
1¡¢¹¥»÷ÕßÖ»ÒªÔÚ´«ÈëµÄuserName¼ÓÉÏ'--ÉÏÃæµÄsql±ã½« ......
ÔÚÊý¾Ý¿â¿ª·¢¹ý³ÌÖУ¬µ±Äã¼ìË÷µÄÊý¾ÝÖ»ÊÇÒ»Ìõ¼Ç¼ʱ£¬ÄãËù±àдµÄÊÂÎñÓï¾ä´úÂëÍùÍùʹÓÃSELECT INSERT Óï¾ä¡£µ«ÊÇÎÒÃdz£³£»áÓöµ½ÕâÑùÇé¿ö£¬¼´´Óijһ½á¹û¼¯ÖÐÖðÒ»µØ¶ÁȡһÌõ¼Ç¼¡£ÄÇôÈçºÎ½â¾öÕâÖÖÎÊÌâÄØ£¿ÓαêΪÎÒÃÇÌṩÁËÒ»ÖÖ¼«ÎªÓÅÐãµÄ½â¾ö·½°¸¡£
1.1 ÓαêºÍÓαêµÄÓŵã
ÔÚÊý¾Ý¿âÖУ¬ÓαêÊÇÒ»¸ö ......