SQLÖÐÒÔÈÕÆÚΪÌõ¼þͳ¼Æ·½·¨
/*ͳ¼ÆÿÌìÊý¾Ý×ÜÁ¿ÈýÖÖ·½·¨£º
select convert(char(10),happentime ,120) as date ,count(1) from table1
group by convert(char(10),happentime ,120) order by date desc
select day(happentime) as date,count(*) from table1
group by day(happentime) order by date desc
SELECT left([happentime],5),count (1)
from [database].[dbo].[ table1]
group by left([happentime],5)
order by left([happentime],5)
˵Ã÷£ºhappentimeΪ±í×Ö¶ÎÃû;
´ó¼Ò·Ö±ð²âÊÔÏ left([happentime],20) Óë convert(char(10),happentime ,120) ¡¢day(happentime) Á½ÕßµÄÇø±ð£¬¶ÔÓÚÐÂÈËÀ´Ëµ£¬´Óleft([happentime],5) À´¿´½á¹ûÍùÍù¿´²»³öÀ´ÓëÆäËûÁ½¸öµÄ²»Í¬¡£
Èç¹û²»Ã÷°×Óï¾äÈçºÎд£¬Çë²Î¿¼ÈçÏÂ:
select convert(char(10),happentime ,120) from table1
SELECT left([happentime],5) from table1
SELECT left([happentime],5) from table1
Ïà¹ØÎĵµ£º
MMC ²»ÄÜ´ò¿ªÎļþ C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC¡£¿ÉÒÔÔÒòÊÇÎļþ²»´æÔÚ£¬²»ÊÇÒ»¸öMMC¿ØÖÆ̨£¬»òÕßÓúóÀ´MMC°æ±¾´´½¨£¬Ò²ÐíҲûÓзÃÎÊ´ËÎļþµÄ×㹻ȨÏÞ¡£
½â¾ö·½·¨£º
ÖØд´½¨´ËÎļþ£¬ÔËÐжԻ°¿òÖÐÊäÈë:mmc
1) ¿ØÖÆ̨-->Ìí¼Ó/ɾ³ý¹ÜÀíµ¥Ôª-->Ìí¼ ......
1 :ÆÕͨSQLÓï¾ä¿ÉÒÔÓÃExecÖ´ÐÐ
Àý: Select * from tableName
Exec('select * from tableName')
& ......
½ñÌìÔÚÐÞ¸ÄÒÔÇ°¿ª·¢µÄÒ»¸öÍøÕ¾µÄʱºòÓöµ½Ò»¸öÎÊÌ⣬ÒòΪ¹¦ÄܵÄÐèÒª£¬ÒÔÇ°µÄÒ»¸öÊý×ÖÀàÐÍ×ֶθıäΪÎı¾×ֶΣ¬ÒòΪÕâ¸ö×Ö¶ÎÐèÒª°üº¬¶à¸öÀà±ðµÄID£¬ÒÔÇ°Õâ¸ö×Ö¶ÎÖ»¶ÔÓ¦Ò»¸öIDµÄ¡£
ÍøÕ¾ÊÇASP VBÓïÑԵģ¬Êý¾Ý¿âʹÓõÄÊÇAccess
ÐÞ¸ÄÊý¾ÝÀàÐÍÖ®ºóǰ̨µÄ²éѯ´úÂë¾Í²»ÄÜʹÓÃÖîÈçxID=1ÕâÖÖÌõ¼þÁË¡£ÓÉÓÚÏÖÔÚ¸Ã×ֶαäΪÎı¾ÀàÐ ......
2009-11-18 12:51:46
ÏÞ¶¨´¦Àí¼Ç¼µÄµ¥Î»£¬rowcount=100±íʽÿ´Î´¦Àí100ÌõÊý¾Ý¡£Êµ¼Ê´¦ÀíµÄ¼Ç¼ÊýÓÉrowcountºÍwhere×Ó¾ä¾ö¶¨¡£Èç¹û·ûºÏwhereµÄ¼Ç¼Êý´óÓÚrowcount,ÔòÓÐrowcount¾ö¶¨£¬Èç¹ûСÓÚrowcount£¬ÔòÓÉwhere¾ö¶¨¡£
create table tb(id int identity(1,1),num int)
insert into tb
values(1)
while @@ ......
參¿¼: http://blog.sina.com.cn/s/blog_59b11d010100af1n.html
ÈçºÎ»Ö¸´/ÐÞ¸´MS SQLÊý¾Ý¿âµÄMDFÎļþ
Èç¹û±¸·ÝµÄÊý¾Ý¿âÓÐ2¸öÎļþ£¬·Ö±ðÊÇ.LDF ºÍ .MDF£¬´ò¿ªÆóÒµ¹ÜÀíÆ÷£¬ÔÚʵÀýÉÏÓÒ»÷---ËùÓÐÈÎÎñ--¸½¼ÓÊý¾Ý¿â£¬È»ºóÑ¡ÔñÄǸö.MDFÎļþ£¬¾Í¿ÉÒÔÁË¡£
¡¡¡¡»òÕßÔÚ²éѯ·ÖÎöÆ÷ÖÐÊäÈ룺
¡¡¡¡sp_attach_db "Êý¾Ý¿âÃû³Æ" ......