SQL SERVER 2005 °²×°´íÎó½â¾öÁË~
½ñÌìÔÚһ̨Ðé»úÉÏ°²×° sql server 2005£¬¾ÓÈ»±¨1´íÁË£¨ÎÞÓïÁË£¬×°Õâ¸ö¶«Î÷¶¼Åª²»ºÃ%>_<%£©¿ªÊ¼ÒÔΪÊÇÒòΪADÓòµÄÔÒò£¬ºóÀ´É¾µôÓòÓÖÖؽ¨Óò£¬È»ºóÔÙ×°£¬ÓÖ±¨2´í£¬ÓÚÊÇÎʱðÈËËÑË÷µÈµÈ£¬ÕÒµ½ÔÒò˵ҪÖØÐÂ×¢²áinstaller£¬×îÖÕ°²×°³É¹¦ÁË£¬º¦ÎÒ¼Ó°àŪµÄ£¬¸ßÐ˵ÄÊÇ°²×°ºÃÀ²£¬¿ÉÊÇÎÒûÓÐŪÃ÷°×µ½µ×ÊÇɶÔÒòµ¼ÖÂsql°²×°²»ÁËÄØ£¿£¿£¿£¿
1´í£º
TITLE: Microsoft SQL Server 2005 Setup
------------------------------
SQL Server Setup was unable add user NT AUTHORITY\NETWORK SERVICE to local group SQLServer2005DTSUser$PCITC5-29.
For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.06&EvtSrc=setup.rll&EvtID=29512&EvtType=sqlca%5csqlsecurityca.cpp%40Do_sqlGroupMember%40Do_sqlGroupMember%40x56c
------------------------------
BUTTONS:
&Retry
Cancel
------------------------------
²éµ½µÄ
½â¾ö·½·¨1£º
Ò»¿ªÊ¼ÔÚ×°database serviceʱÌáʾ"SQL Server Setup was unable add user NT AUTHORITY\SYSTEM to local group SQLServer2005MSFTEUser$RICHIE$SQL2K5"£¬²éÁËÒ»ÏÂSQLServer2005MSFTEUser$RICHIE$SQL2K5Õâ¸ö×é¸ù±¾¾ÍûÓд´½¨£¬ÓÚÊÇÊÖ¹¤´´½¨×飬°ÑSYSTEMÕʺżӽøÈ¥£¬ÖØа²×°Ê±Õâ¸ö²½Öèµ¹ÊǹýÈ¥ÁË£¬ËæºóÊÇÁíÍâһϵÁеÄÆäËüÎÊÌâÁË£¬ÌáʾºÃÏñÊǶÔʲôÎļþûÓÐȨÏÞ²Ù×÷£¬ÎÞÂÛÔõôÉèÖÃÎļþ¡¢Ä¿Â¼µÄ°²È«ÐÔÎÞ¼ÃÓÚÊ¡£
½â¾ö·½·¨2£º
created SQLServer2005MSFTEUser$SANORAYA$MSSQLSERVER local group and added local account to the group
×îÖÕûÓвÉÈ¡Õâ¸ö¡£¡£¡£ÒòΪÔÚ “¼ÆËã»ú¹ÜÀí”ÖÐÕÒ²»µ½“Óû§ºÍ×é”ÁË¡£¡£¡£
2´í
The Windows Installer Service could not be accessed.This can occur if you are running Windows in
safe mode,or if the Windows Installer is not correctly installde.
²éµ½µÄ
½â¾ö·½·¨£º
http://support.microsoft.com/kb/319624/zh-cn
×îÖÕÖ»ÊÇ Õâô²Ù×÷ÁËһϾÍokÁË£º
µ¥»÷“¿ªÊ¼”£¬µ¥»÷“ÔËÐД£¬¼üÈë MSIEXEC /UNREGISTER£¬È»ºóµ¥»÷“È·¶¨”¡£Õâʱϵͳ¿ÉÄܲ»»áÓÐÈκη´Ó¦£¬¼´Ê¹ÄúµÄ²Ù×÷ÍêÈ«ÕýÈ·¡£
µ¥»÷“¿ªÊ¼”£¬µ¥»÷“ÔËÐД£¬¼üÈë MSIEXEC /REGSERVER£¬È»ºóµ¥»÷“È·¶¨”
Ïà¹ØÎĵµ£º
ÏàÐÅ´ó¼Ò¶¼ÔÚµ±ÐÄÊý¾Ý¿âµÄ¶ªÊ§£¬ÕâÒ²ÊÇÿ¸ö¿ª·¢ÕßÍ·Í´µÄÒ»¼þʼþ£¬ÒòΪÕýÔÚÔËÐеķþÎñÆ÷¼°Êý¾Ý¿âÒ²ÔÚÕą̂·þÎñÆ÷ÉÏ¡£Èç¹û·þÎñÆ÷±ÀÀ££¬ÄÇôËùÓеÄÊý¾Ý
¶¼²»´æÔÚÁË£¬¾ÍËãÊÇÄãÔÚÄãµÄ»ú×ÓÉÏ×öÁ˱¸·Ý£¬ÄÇÒ²ÊÇûÓÐÓõģ¬ÎªÊ²Ã´»áÕâÑù˵Ö÷ÒªÊÇÒòΪ±¾»úÊÇÏò»¥ÁªÍø¹«¿ªµÄ£¬ËùÒÔ³öʹʵĸÅÂʾͱȽϸߡ£×îÖÕÎÒÃÇ¿ÉÒÔÀû
ÓþÖÓò ......
SQL Server CE 2.0µÄÈ«ÃûÊÇSQL Server 2000 Windows CE Edition version 2.0¡£
Àý×Ó1£º¹«Ë¾ÅÉÈËÈ¥²Ö¿âÑé»õ¡¢µã»õ£¬¿ÉÒÔ°ÑÇ嵥ͬ²½µ½Pocket PCÉÏ£¬È»ºóÔÚ²Ö¿âÀïÃæÖ±½ÓÔÚPPCÉÏÃæupdate£¬»Øµ½¹«Ë¾Ò»Í¬²½¾Í¿ÉÒÔÁË¡£·ñÔò°´ÕÕÔÏÈ×ö·¨£¬ÐèÒªÏÈ´òÓ¡Ò»ÕÅÇåµ¥£¬»ØÀ´ÒÔºóÔÙ¼ÈëÒ»±é¡£
Àý×Ó2£ºÁªÏëÅÉÈËÉÏÃÅÀ´ÐÞµçÄÔ£¬ÒÔÇ°×ÜÊÇ´ ......
ת£ºhttp://blog.csdn.net/flyfranker/archive/2009/01/08/3733764.aspx
ASP±à³ÌÃż÷ºÜµÍ£¬ÐÂÊÖºÜÈÝÒ×ÉÏ·¡£ÔÚÒ»¶Î²»³¤µÄʱ¼äÀÐÂÊÖÍùÍù¾ÍÒѾÄܹ»±à³ö¿´À´±È½ÏÍêÃÀµÄ¶¯Ì¬ÍøÕ¾£¬ÔÚ¹¦ÄÜÉÏ£¬ÀÏÊÖÄÜ×öµ½µÄ£¬ÐÂÊÖÒ²Äܹ»×öµ½¡£ÄÇôÐÂÊÖÓëÀÏÊÖ¾ÍûÇø±ðÁËÂð£¿ÕâÀïÃæÇø±ð¿É¾Í´óÁË£¬Ö»²»¹ýÍâÐÐÈ˺ÜÄÑÒ»Ñ۾Ϳ´³öÀ´°ÕÁË¡£ÔÚ½ç ......
create PROCEDURE pagelist
@tablename nvarchar(50),
@fieldname nvarchar(50)='*',
@pagesize int output,--ÿҳÏÔʾ¼Ç¼ÌõÊý
@currentpage int output,--µÚ¼¸Ò³
@orderid nvarchar(50),--Ö÷¼üÅÅÐò
@sort int,--ÅÅÐò·½Ê½£¬1±íʾÉýÐò£¬0±íʾ½µÐòÅÅÁÐ
......