Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

ÈçºÎÐ¶ÔØSQL Server 2005

Ð¶ÔØSQL Server 2005µÄ·½·¨Ö®Ò»£¬·ÅÔÚÕâ¶ùÖ»ÊÇΪÁ˼Çס£º
1£º°ÑSQL Server2005µÄ°²×°ÅÌ£¨°²×°Îļþ£©·ÅÈëµ½¹âÇý¡£
2£º´ò¿ªÈçÏ·¾¶£º¿ªÊ¼/ÔËÐУ¬ÊäÈ룺cmd
3£ºÊäÈëÏÂÁÐÃüÁ
 
Start /wait \setup.exe /qb REMOVE=ALL INSTANCENAME=£º¹ÜÇøÅÌ·û£¬ÀýÈ磺G£º¡¢H£ºµÈ£»£º°²×°µÄSQLServerʵÀýÃû³Æ£¬Ä¬ÈÏֵΪ£º¹¦ÄÜ£ºÐ¶ÔØSQL Server 2005 ²¿¼þ¡£
 
4£ºÊäÈëÏÂÁÐÃüÁStart /wait msiexec /qb /X \Setup\sqlncli.msiµÄ½âÊÍÈçÉÏ¡£¹¦ÄÜ£ºÐ¶ÔØMicrosoft SQL Native Client¡£
5£ºÊäÈëÏÂÁÐÃüÁStart /wait \redist\2.0\dotnetfx.exe /q:a /c:"install /qu"ÈçÉÏ¡£¹¦ÄÜ£ºÐ¶ÔØMicrosoft .NET Framework¡£
 
 
 
 
 
 
´ÓSQL Server 2005 ExpressÉý¼¶¶øÀ´µÄʵÀý£¬ÓÃÆðÀ´×ܸоõ¹Ö¹ÖµÄ£¬ºÜ¶à¹¦ÄܺÃÏñ¶¼Í£ÁôÔÚExpress°æ±¾ÉÏ¡£Òò´ËÏë°ÑSQL Server 2005ÍêÈ«Ð¶ÔØºóÔÙ֨װ¡£
²Î¿¼ÎÄÕ£ºÈçºÎÊÖ¶¯Ð¶ÔØ SQL Server 2005 ʵÀý£¬ ´íÎó´úÂë-2147024893
²½Öè 1£ºÈ·±£ Microsoft SQL Server °²×°Ö§³ÖÎļþ×é¼þÒѰ²×°
ÔÚ“Ìí¼Ó»òɾ³ý³ÌÐò”ÖУ¬È·±£“Microsoft SQL Server °²×°Ö§³ÖÎļþ”³öÏÖÔÚÒѰ²×°µÄ³ÌÐòÁбíÖС£Èç¹û“Microsoft SQL Server °²×°Ö§³ÖÎļþ”³öÏÖÔÚ¸ÃÁбíÖУ¬Çëתµ½“²½Öè 2£ºÔËÐÐÃüÁîÒÔÐ¶ÔØ SQL Server ×é¼þ”Ò»½Ú¡£
Èç¹û“Microsoft SQL Server °²×°Ö§³ÖÎļþ”ûÓгöÏÖÔÚ¸ÃÁбíÖУ¬ÇëÏȰ²×°¸Ã×é¼þ£¬È»ºóÔÙ¼ÌÐø¡£Òª°²×°¸Ã×é¼þ£¬Çë°´ÕÕÏÂÁв½Öè²Ù×÷£º
ÕÒµ½Ô­Ê¼µÄ SQL Server 2005 °²×°½éÖÊ¡£
Òª°²×°Ö§³ÖÎļþ£¬ÇëË«»÷“Servers\setup\sqlsupport.msi”Îļþ¡£
×¢Ò⣺ÔÚ“²½Öè 5£ºÐ¶ÔØ Microsoft SQL Server °²×°Ö§³ÖÎļþ×é¼þ”Ò»½ÚÖУ¬½«Ð¶ÔظÃ×é¼þ¡£
²½Öè 2£ºÔËÐÐÃüÁîÒÔÐ¶ÔØ SQL Server ×é¼þ
×¢Òâ£ºÐ¶ÔØReporting Servicesʱ¿ÉÄܳöÏÖµÄÎÊÌ⣬°²×°³ÌÐòÎÞ·¨¶ÁÈ¡ IIsMimeMap ±í
½â¾ö·½·¨
1.Í£Ö¹IIS Admin·þÎñºÍWord Wide Web Publishing·þÎñ
2.½«IIS AdminµÄÆô¶¯ÀàÐ͸ÄΪ“½ûÓÔ£¨²»È»µÄ»°£¬Ð¶Ôعý³ÌIIS Admin»á±»Ð¶ÔسÌÐòÆô¶¯ÆðÀ´£¬»¹»á³öÏÖͬÑùµÄÎÊÌ⣩
ÔÚÃüÁîÌáʾ·ûÏ£¬ÔËÐÐÏÂÃæµÄÃüÁ
"%ProgramFiles%\Microsoft SQL Server\90\Setup Bootstrap\ARPWrapper.exe /Remove"
¹´Ñ¡ÄãҪɾ³ýµÄ×é¼þ¡£
×¢Ò⣺“Ìí¼Ó»òɾ³ý³ÌÐò”»¹»áʹÓÓ/Remove”Ñ¡ÏîÔËÐÐ ARPWrapper.exe ³ÌÐ


Ïà¹ØÎĵµ£º

´Ó¸÷ÖÖλÖýØÈ¡×Ö·û´®µÄSQLÓï·¨

Öª: ×Ö¶ÎA='F:\photo\Winter Leaves.jpg'  
ÒªÇó:·Ö¶Î½ØÈ¡Ã¿¶Î×Ö·û[×Ö¶ÎA²»ÄÜΪTEXTÀàÐÍ,·ñÔò±¨´í]
½â¾ö·½·¨:
---½ØÈ¡×Ö·û´®AµÄµÚÒ»¸ö\×ó±ßµÄ×Ö·û´®
select left(A,charindex('/',A)-1)
Êä³ö½á¹û£ºF:
---½ØÈ¡\ÖмäµÄ×Ö·û´®
select  left(stuff(A,1,charindex('/',A),''),charindex('/',stuff(A,1,c ......

sqlÓï¾ä

select gztzid,
       gztztt,
       gztzbt,
       gztznr,
       fslxmc,
       decode(fsfs, '0', 'ÎÞÐè»Ø¸´', '1', 'ÐèÒª»Ø¸´') fsfs,
 &nb ......

oracle 10g pl/sql ѧϰ

Ñ¡Ôñ10gÊÇÒòΪ¶ÔÍø¸ñ¼¼Êõ±È½ÏºÃÆæ£¬ºÃÏñ»¹Ã»µÃµ½¹ã·ºÓ¦Óã¬Ò²¾ÍÎÞËùνÓëÇ°Ãæ°æ±¾ÓкܴóÇø±ðÁË¡£
ÔÚѸÀ×ÉÏÏÂÁ˸öÈí¼þ£¬ÔËÐÐsqlplusw£¬È»ºóÕÕ×ÅÊ飬¿ñÇÃÁËÒ»·­£¬ÓÐÔÚÍøÉÏÏÂÁ˸öÊÓÆµ½Ì³Ì£¨MLDNħÀֿƼ¼_Oracle¿ÎÌã©£¬½²µÃͦºÃµÄ£¬¾ÍÊÇʱ¼ä³¤Á˵㣬²»Èç¿´ÊéÀ´µÃ¿ì¡£·´ÕýÏÖÔÚÖ»ÊÇÏëÊìϤһÏ»ù±¾Óï¾ä¡£
¿´ÁËÁ½ÌìÊéÁË¡£Á˽âÁËÒ» ......

SQL Server CLRÈ«¹¦ÂÔÖ®¶þ

´ÓÕâÒ»½Ú¿ªÊ¼ÄØ£¬ÎÒÃǾÍÒª¿ªÊ¼CLRµÄ±à³ÌÖ®ÂÃÁË¡£ÔÚÕâ֮ǰ£¬ÎÒÏȰѱ¾½ÚÖÐÐèÒªÁ˽âµÄÁ½¸öÐÂÀàSqlDataRecordºÍSqlMetaData£¬¼°Îå¸öз½·¨SqlContext.Pipe.SendResultsStart£¬SqlContext.Pipe.SendResultsRow£¬SqlContext.Pipe.SendResultsEnd£¬SqlContext.Pipe.SendºÍSqlContext.Pipe.ExecuteAndSend½øÐÐһϱØÒªµÄ˵Ã÷£¬·½±ã´ ......

SQL×¢Èëʽ¹¥»÷

Ò»¡¢Ê²Ã´ÊÇSQL×¢Èëʽ¹¥»÷£¿
ËùνSQL×¢Èëʽ¹¥»÷£¬¾ÍÊǹ¥»÷Õß°ÑSQLÃüÁî²åÈëµ½Web±íµ¥µÄÊäÈëÓò»òÒ³ÃæÇëÇóµÄ²éѯ×Ö·û´®£¬ÆÛÆ­·þÎñÆ÷Ö´ÐжñÒâµÄSQLÃüÁî¡£ÔÚijЩ±íµ¥ÖУ¬Óû§ÊäÈëµÄÄÚÈÝÖ±½ÓÓÃÀ´¹¹Ô죨»òÕßÓ°Ï죩¶¯Ì¬SQLÃüÁ»ò×÷Ϊ´æ´¢¹ý³ÌµÄÊäÈë²ÎÊý£¬ÕâÀà±íµ¥ÌرðÈÝÒ×Êܵ½SQL×¢Èëʽ¹¥»÷¡£³£¼ûµÄSQL×¢Èëʽ¹¥»÷¹ý³ÌÀàÈ磺
¢Å ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ