Sql Server¸ù¾Ý¼Ç¼¼¯ÅúÁ¿¸üÐÂÊý¾Ý¿â
update t1 set t1.value=t2.value from t2 where t1.id=t2.id
update jbsite_class set topicnum = count
from (select t2.classid,count from (
select distinct classid,count(*) as count
from jbsite_product
group by classid) t2
inner join jbsite_product on jbsite_product.id = t2.classid
) b where jbsite_class.id=b.classid
Ïà¹ØÎĵµ£º
µ±ÐÞ¸ÄÁ˵ǼÃÜÂëʱ£¬µ±Æô¶¯mssqlserverµÄʱºò»á³öÏÖerror 1069, means logon error. ÕâÊÇÓÉÓÚÒ»ÏÂ2¸öÔÒò1.sqlserverµÄÃÜÂëûÓÐͬ²½µÄÔÒò£¬ÐèÒªÔÚadministrator tools ->services-> right click mssqlserver -> property-> logon tab -> change passward to new one . 2.sqlserverµÄÆô¶¯Óû§²»¶Ô£¬ÐèÒªÔÚa ......
ÔÚSQL Server2005/2008ÖпÉÒÔʹÓÃÒ»ÏÂËĸöÃüÁîÀ´µ÷ÓÅsqlÓï¾äÒÔ¼°¼ì²éµ÷ÓŵĽá¹û
set
statistics time on
set
statistics IO on
set
statistics profile on
set
statistics xml on
......
ÈçºÎÈÃÄãµÄSQLÔËÐеøü¿ì(תÌù)
---- ÈËÃÇÔÚʹÓÃSQLʱÍùÍù»áÏÝÈëÒ»¸öÎóÇø£¬¼´Ì«¹Ø×¢ÓÚËùµÃµÄ½á¹ûÊÇ·ñÕýÈ·£¬¶øºöÂÔ
Á˲»Í¬µÄʵÏÖ·½·¨Ö®¼ä¿ÉÄÜ´æÔÚµÄÐÔÄܲîÒ죬ÕâÖÖÐÔÄܲîÒìÔÚ´óÐ͵ĻòÊǸ´ÔÓµÄÊý¾Ý¿â
»·¾³ÖУ¨ÈçÁª»úÊÂÎñ´¦ÀíOLTP»ò¾ö²ßÖ§³ÖϵͳDSS£©ÖбíÏÖµÃÓ ......
1.·ÖÒ³·½°¸Ò»£º(ÀûÓÃNot InºÍSELECT TOP·ÖÒ³)
¡¡¡¡Óï¾äÐÎʽ£º
SELECTTOP10*fromTestTableWHERE(IDNOTIN¡¡¡¡¡¡¡¡¡¡(SELECTTOP20id¡¡¡¡¡¡¡¡fromTestTable¡¡¡¡¡¡¡¡ORDERBYid))ORDERBYIDSELECTTOPÒ³´óС*fromTestTableWHERE(IDNOTIN¡¡¡¡¡¡¡¡¡¡(SELECTTOPÒ³´óС*Ò³Êýid¡¡¡¡¡¡¡¡from±í¡¡¡¡¡¡¡¡ORDERBYid))ORDERBYID
¡¡¡¡2.·Ö ......