SQL³£Óú¯ÊýÖ®Èý REPLICATE () £¿
°´Ö¸¶¨´ÎÊýÖØ¸´×Ö·û±í´ïʽ¡£
Óï·¨
REPLICATE ( character_expression, integer_expression)
²ÎÊý
character_expression
×Ö·ûÊý¾ÝÐ͵Ä×ÖĸÊý×Ö±í´ïʽ£¬»òÕß¿ÉÒÔÒþʽת»»Îª nvarchar »ò ntext µÄÆäËûÊý¾ÝÀàÐ͵Ä×ÖĸÊý×Ö±í´ïʽ¡£
integer_expression
¿ÉÒÔÒþʽת»»Îª int µÄ±í´ïʽ¡£Èç¹û integer_expression Ϊ¸º£¬½«·µ»Ø¿Õ×Ö·û´®¡£
·µ»ØÖµ
nvarchar »ò ntext
1 £ºSelect Replicate('abc',2) ----------------abcabc
2 £ºSelect Replicate£¨'abc',-2) ----------------null
3 £ºSelect Replicate('abc',0)--------------- ÎÞ
Ïà¹ØÎĵµ£º
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Ï ......
Æô¶¯SQL Server (SQLEXPRESS)·þÎñʱÌáʾ´íÎó£¬Ê¼þ²é¿´Æ÷ÏÔʾÒÔÏÂÐÅÏ¢£¨ID 9003£©£º
´«µÝ¸øÊý¾Ý¿â 'master' ÖеÄÈÕ־ɨÃè²Ù×÷µÄÈÕ־ɨÃèºÅ (276:232:1) ÎÞЧ¡£´Ë´íÎó¿ÉÄÜָʾÊý¾ÝË𻵣¬»òÕßÈÕÖ¾Îļþ(.ldf)ÓëÊý¾ÝÎļþ(.mdf)²»Æ¥Åä¡£Èç¹û´Ë´íÎóÊÇÔÚ¸´ÖÆÆÚ¼ä³öÏֵģ¬ÇëÖØÐ´´½¨·¢²¼¡£·ñÔò£¬Èç¹û¸ÃÎÊÌâµ¼ÖÂÆô¶¯ÆÚ¼ä³ö´í£¬Çë´Ó± ......
À´Ô´:http://hi.baidu.com/czgblog/blog/item/3abd5aa911d51ff51f17a292.html
function OnFirstUIAfter()
STRING szTitle, szMsg1, szMsg2, szOpt1, szOpt2;
NUMBER bvOpt1, bvOpt2;
NUMBER bShowUpdateServiceDlg;
......
×î½üÔÚÕÒÒ»´Îsql²éѯµÄÎÞÏÞ·ÖÀà²éѯµÄÉè¼Æ£¬ÍøÉÏÕÒÁËÒ»ÏÂÕâ¸öÊý¾Ý±íµÄÉè¼ÆºÜÓÐÌØÉ«£¬
²»Óõݹ飬ÒÀ¿¿¸ö¼òµ¥SQLÓï¾ä¾ÍÄÜÁгö²Ëµ¥£¬¿´¿´Õâ¸öÊý¾Ý±íÔõôÉè¼ÆµÄ£¬²¢¶ÔÏÂÃæµÄÊý¾Ý±í½á¹¹µÄ²éѯ½øÐзÖÎö.
Êý¾Ý¿â×ֶδó¸ÅÈçÏ£º
-----------------------------------------------------------------------------------
id ......
declare @dfname varchar(50)
select @dfname=a.name
from sysobjects a
inner join syscomments b on a.id=b.id
inner join sysconstraints  ......