³¹µ×ɾ³ýsql server 2005
1.Stop ËùÓзþÎñ
2.Óà Windows Install Clean Up ¹¤¾ßÐ¶ÔØSQL 2005×é¼þ
3.ÓÃSrvInstw.exeɾ³ýËùÓÐSQL·þÎñ
4.Çå³ý×¢²á±í
a. ½«HKEY_CURRENT_USER---Software----MicrosoftϵÄMicrosoft SQL ServerÎļþ¼ÐÈ«²¿É¾³ý
b. ½«HKEY_LOCAL_mACHINE---SOFTWARE---MicrosoftϵÄMicrosoft SQL Native Client ,Microsoft SQL Server, Microsoft SQL Server 2005 RedistÈ«²¿É¾³ý¡£
5.ɾ³ý²ÐÁôÎļþ
½«CÅÌ——Program FileϵÄMicrosoft SQL Server Îļþ¼Ðɾ³ý¡£
6.ÖØÆôµçÄÔ£¬ÖØÐ°²×°¡£
Ïà¹ØÎĵµ£º
ʾÀý
A. ʹÓôøÓи´ÔÓ SELECT Óï¾äµÄ¼òµ¥¹ý³Ì
ÏÂÃæµÄ´æ´¢¹ý³Ì´ÓËĸö±íµÄÁª½ÓÖзµ»ØËùÓÐ×÷Õߣ¨ÌṩÁËÐÕÃû£©¡¢³ö°æµÄÊé¼®ÒÔ¼°³ö°æÉç¡£¸Ã´æ´¢¹ý³Ì²»Ê¹ÓÃÈκβÎÊý¡£
USE pubs
IF EXISTS (SELECT name from sysobjects
WHERE name = 'au_info_all' AND type = 'P')
&nb ......
SQL Server Êý¾Ý¿âµÄÕûÀíÓÅ»¯µÄ»ù±¾¹ý³Ì£¨Ò»£©
¸ß½¨¸Õ
×÷ΪϵͳµÄÖØÒªÒ»¸ö²¿·Ö£¬Êý¾Ý¿âµÄÐÔÄÜÔÚϵͳµÄÔËÐйý³ÌÖÐÆðµ½Á˷dz£¹Ø¼üµÄ×÷Óã¬ÏµÍ³µÄÔËÐйý³ÌÖУ¬ÎÒÃǾ³£Óöµ½¿Í»§±§Ô¹ÏµÍ³ÔËÐеÄÌ«Âý£¬Í³¼ÆÒ»¸öÔµı¨±í¾³£»á³öÏÖ³¬Ê±µÄÇé¿ö£¬Ãæ¶ÔÕâЩÎÊÌ⣬ÎÒÃÇÓ¦¸ÃÈçºÎ´¦ÀíÄÄ£¿³ÌÐòÓÅ»¯ºÍÊý¾Ý¿âÓÅ»¯ÒªÍ¬²½½øÐУ¬³ÌÐò·½ÃæÓ ......
SQLº¯Êý left()¡¢charindex()µÄʹÓÃ
1¡¢left()
LEFT (<character_expression>£¬ <integer_expression>)
·µ»Øcharacter_expression ×óÆð integer_expression ¸ö×Ö·û¡£
2.charindex()
·µ»Ø×Ö·û´®ÖÐij¸öÖ¸¶¨µÄ×Ó´®³öÏֵĿªÊ¼Î»Öá£
CHARINDEX (<’substring_expression’>£¬ <expressio ......
¡¡¡¡Ò»¡¢Ê²Ã´ÊÇSQL×¢Èëʽ¹¥»÷?
¡¡¡¡ËùνSQL×¢Èëʽ¹¥»÷£¬¾ÍÊǹ¥»÷Õß°ÑSQLÃüÁî²åÈëµ½Web±íµ¥µÄÊäÈëÓò»òÒ³ÃæÇëÇóµÄ²éѯ×Ö·û´®£¬ÆÛÆ·þÎñÆ÷Ö´ÐжñÒâµÄSQLÃüÁî¡£ÔÚijЩ±íµ¥ÖУ¬Óû§ÊäÈëµÄÄÚÈÝÖ±½ÓÓÃÀ´¹¹Ôì(»òÕßÓ°Ïì)¶¯Ì¬SQLÃüÁ»ò×÷Ϊ´æ´¢¹ý³ÌµÄÊäÈë²ÎÊý£¬ÕâÀà±íµ¥ÌرðÈÝÒ×Êܵ½SQL×¢Èëʽ¹¥»÷¡£³£¼ûµÄSQL×¢Èëʽ¹¥»÷¹ý³ÌÀàÈ磺 ......
ÊÂÎñ¾ÍÊǸºÔð°ÑһϵÁвÙ×÷¿´×öÒ»¸ö¶ÀÁ¢µÄÂß¼µ¥Ôª£¬ÕâЩ²Ù×÷Ҫôͬʱ³É¹¦£¬ÒªÃ´Í¬Ê±Ê§°Ü¡£ÏÂÃæÊÇÒ»¸ö¾µäµÄÀý×Ó£º
create procedure TransferMoeny
(
@fromAccountNo varchar(50),-- ת³öÕ˺Å
@ToAccountNo varchar(50),--תÈëÕ˺Å
& ......