SqlServerÖвéѯ10µ½20ÌõÖ®¼äµÄÊý¾Ý
²éѯnorthwindÊý¾Ý¿âÖÐordersÖеÄ10µ½20Ìõ¼Ç¼
select top 10 * from orders
where orderid > ( select max(orderid) from (select top 10 orderid from orders order by orderid) as t )
orders±íÖÐÒÑÓÐ×ÔÔö³¤µÄ±êʶÁÐorderid,
ÏȲé³ö±íÖÐǰʮÌõ¼Ç¼ÖеÄ×î´óorderid£¬
10ÌõÒÔºóµÄorderid¿Ï¶¨´óÓÚǰʮÌõµÄ×î´óid£¬ËùÒÔÔÙwhereÅжϼ´¿É¡£
ÁíÍ⣬Èç¹ûÒª²éѯµÄ±íûÓбêʶÁУ¬Ò²¿ÉÒÔʹÓÃÏÂÃæÕâÖÖ·½·¨£º
select top 20 identity(int ,1,1) as id * into #temp from table
select * from #temp where id>10
Ïà¹ØÎĵµ£º
²âÊÔµÄʱºò±È½ÏÖØÒª£¬ÎÒÃÇ¿ÉÒÔÖªµÀµ±Ç°½»Ò×Ó°ÏìÁËÄÄЩ±í
--ÓÃÓڼǼÓû§ÔÚµ±Ç°±íÉÏʲôʱºò¡¢×öµÄʲô²Ù×÷£ºupdate¡¢insert¡¢delete
create table TriggerRecord
(
operdt datetime, --´¥·¢Ê±¼ä
opertp varchar(10), --²Ù×÷ÀàÐÍ£ºupdate¡¢insert¡¢delete
opertb varchar(50) --±íÃû ......
Ïà¹ØÎÄÕÂ:
mysqlÊý¾Ý¿âËø
ORACLEÀXÖÖËøÄ£Ê½
ÍÆ¼öȦ×Ó: Pipboy
¸ü¶àÏà¹ØÍÆ¼ö
new Draggable("related_topics");
¶ÔËø»úÖÆµÄÑо¿Òª¾ß±¸Á½¸öÌõ¼þ£º
1£®Êý¾ÝÁ¿´ó
2£®¶à¸öÓû§Í¬Ê±²¢·¢
Èç¹ûȱÉÙÕâÁ½¸öÌõ¼þ£¬Êý¾Ý¿â²»ÈÝÒײúÉúËÀËøÎÊÌâ¡£Ñо¿ÆðÀ´¿ÉÄÜ»áʱ¶¹ ......
ÔÚSQLÓï¾äÖÐͨ¹ýϵͳ´æ´¢¹ýsp_addextendedproperty¿ÉΪ±í×Ö¶ÎÌí¼ÓÉ϶¯Ì¬µÄ˵Ã÷£¨±¸×¢£©ÏÂÃæÊÇSQL SERVER°ïÖúÎĵµÖжÔsp_addextendedproperty´æ´¢¹ý³ÌµÄÃèÊö
Óï·¨
sp_addextendedproperty
[ @name = ] { 'property_name' }
[ , [ @value = ] { 'value' }
&nbs ......
¡¡¾³£¿´¼ûÓÐÈËÎÊ£¬MSSQLÕ¼ÓÃÁËÌ«¶àµÄÄڴ棬¶øÇÒ»¹²»¶ÏµÄÔö³¤£»»òÕß˵ÒѾÉèÖÃÁËʹÓÃÄڴ棬¿ÉÊÇËüûÓÐÓõ½ÄÇô¶à£¬ÕâÊÇÔõôһ»ØÊ¶ùÄØ£¿
¡¡¡¡Ê×ÏÈ£¬ÎÒÃÇÀ´¿´¿´MSSQLÊÇÔõÑùʹÓÃÄÚ´æµÄ¡£
¡¡¡¡×î´óµÄ¿ªÏúÒ»°ãÊÇÓÃÓÚÊý¾Ý»º´æ£¬Èç¹ûÄÚ´æ×ã¹»£¬Ëü»á°ÑÓùýµÄÊý¾ÝºÍ¾õµÃÄã»áÓõ½µÄÊý¾ÝͳͳÈÓµ½ÄÚ´æÖУ¬Ö±µ½ÄÚ´æ²»×ãµÄʱºò ......
½ñÌìÒ»²»Àä¾²¾Í°ÑsqlserverÊý¾Ý¿â³õʼ»¯ÁË£¬ÔÚÍøÉÏÕÒÁ˰ëÌì·¢ÏÖÁ˼¸ÆªÌû×Ó£¬ÊÜÒæ·Çdz£¬¼Ç¼ÏÂ
DB2ÖпÉÒÔʹµÃÊý¾Ý¿â»Ø¸´µ½Ö¸¶¨µÄʱ¼äµã£¬SQL ServerÊý¾Ý¿âµÄRecovery ModelΪfull »òÕßBulk copyµÄʱºò£¬ÊÇ¿ÉÒÔ´ÓÈÕÖ¾À´»Ö¸´Êý¾Ý¿âµÄ¡£Êµ¼ÊÉÏÈÕÖ¾ÖмǼµÄÒ»ÌõÒ»ÌõµÄtransact sqlÓï¾ä£¬»Ö¸´Êý¾Ý¿âµÄʱºò»áredoÕâЩsqlÓï¾ä¡£&nb ......