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
Ïà¹ØÎĵµ£º
sql ²éѯÌõ¼þ×Ö¶ÎΪtext»òntextµÃ½â¾ö·½°¸ÒÔ¼°varchar(max)¡¢nvarchar(max)
1¡¢ÔÚMS SQL2005¼°ÒÔÉϵİ汾ÖУ¬¼ÓÈë´óÖµÊý¾ÝÀàÐÍ£¨varchar(max)¡¢nvarchar(max)¡¢varbinary(max) £©¡£´óÖµÊý¾ÝÀàÐÍ×î¶à¿ÉÒÔ´æ´¢2^30-1¸ö×Ö½ÚµÄÊý¾Ý¡£
Õ⼸¸öÊý¾ÝÀàÐÍÔÚÐÐΪÉϺͽÏСµÄÊý¾ÝÀàÐÍ varchar¡¢nvarchar ºÍ varbinary Ïàͬ¡£
΢ÈíµÄË ......
Sql´úÂë:Powered by chenjiazi
--²éѯµ±Ì죺
select * from info where DateDiff(dd,datetime,getdate())=0
--²éѯ24СʱÄÚµÄ:
select * from info where DateDiff(hh,datetime,getDate())<=24
--infoΪ±íÃû,datetimeΪÊý ......
1¡¢µÚÒ»²½£¬Ñ¡ÖÐÒªÇå³ýÈÕÖ¾µÄÊý¾Ý¿â——ÓÒ¼ü——ÊôÐÔ¡£
2¡¢µÚ¶þ²½£ºÔÚÑ¡ÏîҳѡÖГѡÏ¬»Ö¸´Ä£Ê½Ñ¡Ôñ“¼òµ¥”£¬µã»÷×îϱßÈ·¶¨°´Å¥¡£
3¡¢µÚÈý²½£¬ÔÙÑ¡ÖÐÊý¾Ý¿âÓÒ¼ü——ÈÎÎñ——ÊÕËõ——Êý¾Ý¿â¡£
4¡¢µÚËIJ½£¬µã»÷&ldq ......
1.·ÖÒ³·½°¸Ò»£º(ÀûÓÃNot InºÍSELECT TOP·ÖÒ³)
¡¡¡¡Óï¾äÐÎʽ£º
SELECTTOP10*fromTestTableWHERE(IDNOTIN¡¡¡¡¡¡¡¡¡¡(SELECTTOP20id¡¡¡¡¡¡¡¡fromTestTable¡¡¡¡¡¡¡¡ORDERBYid))ORDERBYIDSELECTTOPÒ³´óС*fromTestTableWHERE(IDNOTIN¡¡¡¡¡¡¡¡¡¡(SELECTTOPÒ³´óС*Ò³Êýid¡¡¡¡¡¡¡¡from±í¡¡¡¡¡¡¡¡ORDERBYid))ORDERBYID
¡¡¡¡2.·Ö ......