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

È«ÎÄË÷ÒýÔ­Àí¼°ÆäʾÀý£¨sqlserver£©

È«ÎļìË÷ÊǶԴóÊý¾ÝÎı¾½øÐÐË÷Òý£¬ÔÚ½¨Á¢µÄË÷ÒýÖжÔÒª²éÕҵĵ¥´Ê½øÐнøÐÐËÑË÷£¬¶¨Î»ÄÄЩÎı¾Êý¾Ý°üÀ¨ÒªËÑË÷µÄµ¥´Ê¡£Òò´Ë£¬È«ÎļìË÷µÄÈ«²¿¹¤×÷¾ÍÊǽ¨Á¢Ë÷ÒýºÍÔÚË÷ÒýÖÐËÑË÷¶¨Î»£¬ËùÓеŤ×÷¶¼ÊÇΧÈÆÕâÁ½¸öÀ´½øÐеġ£ÏÂÃæ¾ÍÖð¸ö½éÉÜ¡£
¡¡¡¡½¨Á¢È«ÎÄË÷ÒýÖÐÓÐÁ½Ïî·Ç³£ÖØÒª£¬Ò»¸öÊÇÈçºÎ¶ÔÎı¾½øÐзִʣ¬Ò»Êǽ¨Á¢Ë÷ÒýµÄÊý¾Ý½á¹¹¡£·Ö´ÊµÄ·½·¨»ù±¾ÉÏÊǶþÔª·Ö´Ê·¨¡¢×î´óÆ¥Åä·¨ºÍͳ¼Æ·½·¨¡£Ë÷ÒýµÄÊý¾Ý½á¹¹»ù±¾ÉϲÉÓõ¹ÅÅË÷ÒýµÄ½á¹¹¡£
¡¡¡¡·Ö´ÊµÄºÃ»µ¹Øϵµ½²éѯµÄ׼ȷ³Ì¶ÈºÍÉú³ÉµÄË÷ÒýµÄ´óС¡£ÔÚÖÐÎÄ·Ö´Ê·¢Õ¹ÖУ¬ÔçÆÚ¾­³£Ê¹Ó÷ִʷ½Ê½ÊǶþÔª·Ö´Ê·¨£¬¸Ã·½·¨µÄ»ù±¾Ô­ÀíÊǽ«°üº¬ÖÐÎĵľä×Ó½øÐжþÔª·Ö¸î£¬²»¿¼Âǵ¥´Êº¬Ò壬ֻ¶Ô¶þÔªµ¥´Ê½øÐÐË÷Òý¡£Òò´Ë¸Ã·½·¨Ëù·Ö³öµÄµ¥´ÊÊýÁ¿½Ï¶à£¬´Ó¶ø²úÉúµÄË÷ÒýÊýÁ¿¾Þ´ó£¬²éѯÖлὫÎÞÓõÄÊý¾Ý¼ìË÷³öÀ´£¬ºÃ´¦ÊÇËã·¨¼òµ¥²»»á©µô¼ìË÷µÄÊý¾Ý¡£Ö®ºóÓÖ·¢Õ¹³ö×î´óÆ¥Åä·Ö´Ê·½·¨£¬¸Ã·½·¨ÓÖ·ÖΪÕýÏò×î´ó·Ö´ÊºÍÄæÏò×î´ó·Ö´Ê¡£ÆäÔ­ÀíºÍ²é×ÖµäÀàËÆ£¬¶Ô³£Óõ¥´ÊÉú³ÉÒ»¸ö´Êµä£¬·ÖÎö¾ä×ӵĹý³ÌÖÐ×î´óµÄÆ¥Åä×ÖµäÖеĵ¥´Ê£¬´Ó¶ø½«¾ä×Ó²ð·ÖΪÓÐÒâÒåµÄµ¥´ÊÁ´¡£×î´óÆ¥Åä·¨ÖÐÕýÏò·Ö´Ê·½·¨¶ÔÆ«Õýʽ´ÊÓïµÄ·Ö±æÈÝÒײúÉú´íÎ󣬱ÈÈç“Ê×Êκͷþ×°”»á½«“ºÍ·þ”×÷Ϊµ¥´Ê·Ö³ö¡£´ïÃÎÊý¾Ý¿â²ÉÓõÄÊǸĽøµÄÄæÏò×î´ó·Ö´Ê·½·¨£¬¸Ã·Ö´Ê·½·¨½ÏÕýÏòÕýÈ·ÂÊÓÐËùÌá¸ß¡£×îΪ¸´ÔÓµÄÊÇͨ¹ýͳ¼Æ·½Ê½½øÐзִʵķ½·¨¡£¸Ã·½·¨²ÉÓÃÒþʽÂí¶û¿Æ·òÁ´£¬Ò²¾ÍÊǺóÒ»¸öµ¥´Ê³öÏֵĸÅÂÊÒÀ¿¿ÓÚÇ°Ò»¸öµ¥´Ê³öÏֵĸÅÂÊ£¬×îºóͳ¼ÆËùÓе¥´Ê³öÏֵĸÅÂʵÄ×î´óΪ·Ö´ÊµÄÒÀ¾Ý¡£Õâ¸ö·½·¨¶ÔÐÂÃû´ÊºÍµØÃûµÄʶ±ðÒªÔ¶Ô¶¸ßÓÚ×î´óÆ¥Åä·¨£¬×¼È·¶ÈËæ×ÅÈ¡ÑùÎı¾µÄÊýÁ¿µÄÔö´ó¶øÌá¸ß¡£
¡¡¡¡¶þÔª·Ö´Ê·½·¨ºÍͳ¼Æ·½·¨ÊDz»ÒÀÀµÓڴʵäµÄ£¬¶ø×î´óÆ¥Åä·¨·Ö´Ê·½·¨ÊÇÒÀÀµÓڴʵäµÄ£¬´ÊµäµÄÄÚÈݾö¶¨·Ö´Ê½á¹¹µÄºÃ»µ¡£
¡¡¡¡È«ÎļìË÷µÄË÷Òý±»³ÆΪµ¹ÅÅË÷Òý£¬Ö®ËùÒÔ³ÉΪµ¹ÅÅË÷Òý£¬ÊÇÒòΪ½«Ã¿Ò»¸öµ¥´Ê×÷ΪË÷ÒýÏ¸ù¾Ý¸ÃË÷ÒýÏî²éÕÒ°üº¬¸Ãµ¥´ÊµÄÎı¾¡£Òò´Ë£¬Ë÷Òý¶¼Êǵ¥´ÊºÍΨһ¼Ç¼Îı¾µÄ±êʾÊÇÒ»¶Ô¶àµÄ¹Øϵ¡£½«Ë÷Òýµ¥´ÊÅÅÐò£¬¸ù¾ÝÅÅÐòºóµÄµ¥´Ê¶¨Î»°üº¬¸Ãµ¥´ÊµÄÎı¾¡£
ÄæÏò·Ö´ÊµÄ¹ý³Ì˵Ã÷
¡¡¡¡²½Öè1£©¶ÁÈ¡Ò»ÕûÌõ¾ä×Óµ½±äÁ¿strÖУ¬×ªµ½²½Öè2
¡¡¡¡²½Öè2£©´Ó¾ä×ÓµÄβ¶Ë¶ÁÈ¡1¸ö×Öµ½±äÁ¿wordÖУ¬×ªµ½²½Öè3
¡¡¡¡²½Öè3£©ÔÚ×Öµä²éÕÒwordÖб£´æµÄµ¥´Ê¡£Èç¹û´æÔÚÔò±£´æword£¬×ªµ½²½Öè4£¬·ñÔòתµ½²½Öè5£©
¡¡¡¡²½Öè4£©Èç¹ûÊÇ×ÖµäÖÐ×î´óµ¥´Ê»òÕß³¬¹ý×î´óµ¥´ÊÊý£¨È϶¨ÎªÐ´ʣ©£¬´Ó¾äβȥµô¸Ãµ¥´Ê£¬·µ»Ø²½Öè2
¡¡¡¡²½Öè5


Ïà¹ØÎĵµ£º

ÈçºÎ»ñµÃsqlserverÊý¾Ý¿âÖÐÕ¼ÓøßcpuÓû§µÄ»î¶¯ÄÚÈÝ


ÈçºÎ»ñµÃsqlserverÊý¾Ý¿âÖÐÕ¼ÓøßcpuÓû§µÄ»î¶¯ÄÚÈÝ
1¡¢´Ó΢ÈíÕ¾µãÉÏÏÂÔØqslice_setup.exe
2¡¢´ò¿ªQuery Analyzer£¬ÔËÐÐÒÔÏÂÓï¾ä£º
declare @a int
while (1<2)
begin
select @a=1
end
½«»á·¢ÏÖcpuÂíÉÏ´ïµ½100%
3¡¢´ò¿ªqlice.exe£¬½«·¢ÏÖsqlserver.exeµÄcpuÕ¼ÓÃÂʺܸߣ¬Ë«»÷½øÈ룬³öÐÐsqlserver.exeÖоßÌåÏß³ ......

sqlServer,oracleÖÐcase¹Ø¼ü×ÖµÄÓ÷¨

    ÔÚдSQLʱ£¬ÓÐʱҪ¸ù¾ÝÒÑÓеÄÁÐÖµ¹¹ÔìеÄÁÐÖµ£¬Õâʱ¾ÍÒªÓõ½µÄSQLÖеÄcase¹Ø¼ü×Ö¡£ÈçÏÂËùʾ²éѯ¸ºÔðÈËÐÅÏ¢±í£¨T_MS_CustomerCrmInfoDutyPerson£©ÖеÄÊÇ·ñÊÇÖ÷Òª¸ºÔðÈË£¨isMainDuty£©×ֶΣ¬µ«ÊÇÕâ¸ö×ֶεÄÖµÊÇÒÔö¾ÙµÄ·½Ê½´æ´¢µÄ£¬´æ´¢0±íʾÊÇ·ñ£¬1±íʾÊÇ£¬·ñÔò±íʾδÅжϡ£Õâʱֱ½Ó²éѯ³öµÄÖµ²»ÊÇ ......

Microsoft SqlServer 2005 ͨÓ÷ÖÒ³ ´æ´¢¹ý³Ì

±¾À´ÎÒÊDz»ÔÞ³ÉʹÓÃͨÓô洢¹ý³ÌµÄ£¬Ö÷ÒªÊÇÒòΪ¸ù¾Ý±í½á¹¹À´¶¨ÖÆ·ÖÒ³²éѯ²»Óö¯Ì¬µÄÆ´SQL£¬ÕâÑù²ÅÊÇÕæÕýµÄ¸ßЧ£¬¶øÇÒֻҪд¹ýÒ»¸ö£¬ÄÇôÔÙÓÐÐÂÐèÇóµÄʱºò£¬Ð¡·¶Î§¸Ä¶¯¼¸´¦¾ÍokÁË¡£
µ«×ÜÊÇÓÐÈËÏòÎÒÌÖÒª»òÕßÌÖÂÛͨÓô洢¹ý³Ì£¬Ã»°ì·¨£¬±»±ÆÎÞÄΣ¬Á¼ÐÄÉ¥ÓëÀ§¾³¡£
ľÓÐÕÒµ½T-SQL´úÂë±à¼­Æ÷
-- ============================= ......

һЩSqlServerÓï¾ä

Ò»¡¢»ù´¡
1¡¢ËµÃ÷£º´´½¨Êý¾Ý¿â
CREATE DATABASE database-name
2¡¢ËµÃ÷£ºÉ¾³ýÊý¾Ý¿â
drop database dbname
3¡¢ËµÃ÷£º±¸·Ýsql server
--- ´´½¨ ±¸·ÝÊý¾ÝµÄ device
USE master
EXEC sp_addumpdevice 'disk', 'testBack', 'c:\mssql7backup\MyNwind_1.dat'
--- ¿ªÊ¼ ±¸·Ý
BACKUP DATABASE pubs TO testBack
4¡¢Ëµ ......

sqlserver FOR XML PATH Óï¾äµÄÓ¦ÓÃ

´úÂëÈçÏÂ:

DECLARE
@TempTable table(UserID int , UserName nvarchar(50));
insert into
@TempTable (UserID,UserName) values (1,'a')
insert into @TempTable
(UserID,UserName) values (2,'b')

select UserID,UserName
from @TempTable FOR XML PATH
ÔËÐÐÕâ¶Î½Å±¾£¬½«Éú³ÉÈçϽá¹û£º
¸´ÖÆ´úÂë ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ