½â¾ö°²×°SQL Server2000 Îļþ¹ÒÆð
1.²»ÓÃÍ˳öSQL2000°²×°³ÌÐò,Ö±½ÓÇл»µ½×ÀÃæ.
¡¡¡¡2.´ò¿ª×¢²á±í±à¼Æ÷£¨ÔÚ“ÔËÐДÖÐÇÃÈë“regedit”Ö®ºó»Ø³µ¼´¿É£©£¬¶¨Î»µ½×¢²á±íµÄHKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Session Manager½Úµã.
¡¡¡¡3.µ¥»÷“Session Manager”Õâ¸ö½Úµã£¬È»ºóÔÚÓÒ²àµÄ´°¿ÚÖÐÕÒµ½“PendingFileRenameOperations”Ñ¡Ï˫»÷´ò¿ª£¨»òÓÒ¼üµ¥»÷ºóÑ¡Ôñ“Ð޸ĔҲ¿ÉÒÔ£©£¬È»ºó£¬½«ÆäÏÂÃæ¿Õ°×À¸ÖеÄֵȥµô£¨Çå¿Õ£©¼´¿É
¡¡¡¡4.¹Øµô×¢²á±í±à¼Æ÷,Çл»»ØSQL2000°²×°³ÌÐò,ºóÍËÒ»²½,È»ºóÔÙµãÏÂÒ»²½¼´¿É½â¾ö!
Ïà¹ØÎĵµ£º
Ê×ÏÈÒªÌí¼Ó
using System.Data;
using System.Data.SqlClient;
½ÓÏÂÀ´£º
SqlConnection conn = new SqlConnection("server=QLPC\\SQL2005;uid=sa;pwd=£¨ÄãµÄÃÜÂ룩;database=£¨ÄãµÄÊý¾Ý±í£©"); &n ......
SQL×¢Èë¹¥»÷·À·¶¼¼ÇÉ
Ò»°ãµÄSQL×¢Èë¹¥»÷¶¼ÊÇͨ¹ý¹¹½¨Ò»Ìõ¸´ÔÓµÄsqlÓï¾ä£¬
ͨ¹ýÍøÒ³Â©¶´À´Ö´ÐÐsqlÓï¾ä£¬´ïµ½¹¥»÷Êý¾Ý¿âµÄÄ¿µÄ¡£
Èçͨ¹ýÎÄÕÂIDÀ´²éѯijһƪÎÄÕµÄÍøÒ³£¬
ͨ³£²ÉÓõÄsqlÓï¾äΪ£º
sql="select top 1 * from articles where articId="&request("id")
ÄÇô¿ÉÒÔ¼òµ ......
ÈçºÎ°ÑAccessת³ÉSQL ServerµÄ·½·¨½éÉÜ
ºÜ¶àÅóÓÑÏëÓÃSQL 2000Êý¾Ý¿âµÄ±à³Ì·½·¨£¬µ«ÊÇÈ´ÓÖ¿àÓÚ×Ô¼ºÊÇѧAccessµÄ£¬¶ÔSQLÖ»ÊÇÒ»µãµãµÄÁË½â¶øÒÑ£¬ÕâÀïÎÒ¸ø´ó¼ÒÌṩÒÔϲο¼---½«Accessת»¯³ÉSQL 2000µÄ·½·¨ºÍ×¢ÒâÊÂÏî¡£Ê×ÏÈ£¬ÎÒ˵µÄÊÇÔÚAccess 2000£¬SQL 2000Ö®¼äת»»£¬ÆäËûµÄÎÒÒ²»¹Ã»Óг¢ÊÔ¹ý£¬Ï£ ......
Èç¹ûÎÒÃǵÄSQL ServerÒª±£Ö¤¸ß¿ÉÓÃÐÔ£¬ÄÇô¿ÉÒÔ²ÉÓùÊÕÏ×ªÒÆÈº¼¯¡£×î¼òµ¥µÄ¹ÊÕÏ×ªÒÆÈº¼¯ÊÇÁ½Ì¨·þÎñÆ÷£¬Ò»Ì¨×ö»î¶¯µÄ·þÎñÆ÷£¬Áíһ̨×ö±¸Ó÷þÎñÆ÷£¬Õâ¾ÍÊÇAPģʽµÄCluster¡£ÁíÍâÒ»¸öģʽ¾ÍÊÇAAģʽ£¬Ò²¾ÍÊÇÁ½Ì¨·þÎñÆ÷¶¼ÊÇÔËÐÐSQL ServerʵÀý¡£
SQL Server²»ÏñOracleÒ»ÑùÓÐRAC£¬ËùÒÔ²»¿ÉÄÜ˵Á½Ì¨·þÎñÆ÷ͬʱÔËÐÐͬһ¸öʵÀý£¬Ïë ......
SQLÓï¾äµ¼Èëµ¼³ö´óÈ«
/******* µ¼³öµ½excel
EXEC master..xp_cmdshell ¡¯bcp SettleDB.dbo.shanghu out c:\temp1.xls -c -q -S"GNETDATA/GNETDATA" -U"sa" -P""¡¯
/*********** µ¼ÈëExcel
SELECT *
from OpenDataSource( ¡¯Microsoft.Jet.OLEDB.4.0¡¯,
¡¯Data Source="c:\test.xls ......