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
Ïà¹ØÎĵµ£º
ÕâÁ½ÌìÓиöÐèÇó£¬ÐèÒªÔÚÊý¾Ý¿âÖÐÅжÏ×Ö·û´®µÄ¸ñʽ£¬ÓÚÊÇ´ÓÍøÉÏËѼ¯ÁËһЩ×ÊÁÏ£¬ÕûÀíÁËһϡ£
ÏÂÃæÕâ¸öÊÇÒ»¸ö×Ô¶¨Ò庯Êý£¬Óû§¿ÉÒÔµ÷ÓÃÕâ¸öº¯ÊýÅжÏÖ¸¶¨µÄ×Ö·û´®ÊÇ·ñ·ûºÏÕýÔò±í´ïʽµÄ¹æÔò.
CREATE FUNCTION dbo.find_regular_expression
(
@source varchar(5000), --ÐèҪƥÅäµÄÔ´× ......
SELECT convert(char,ÈÕÆÚ×Ö¶Î,120) as date2 from table
mssqlĬÈÏÒÔϵͳʱ¼ä¸ñʽÊä³ö£¬Äã¿ÉÒÔµ÷ÕûϵͳµÄʱ¼ä¸ñʽÀ´½â¾ö
µ±È»ÊÇÔÚ³ÌÐòÀï½â¾ö±È½ÏÁé»î£¬convert(char,date,N)Êä³öµÄ¸÷ÖÖÑùʽ
N ÈÕÆÚÑùʽ
0 04& ......
1.SQLServerµÄ´´½¨½Å±¾ÈçÏ£º
USE [master]
GO
/****** Object: Database [test] Script Date: 10/29/2009 17:43:10 ******/
CREATE DATABASE [test] ON PRIMARY
( NAME = N'test', FILENAME = N'D:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\test.mdf' , S ......
sqlserver µÄntextÀàÐÍÔÚÊý¾Ý¿âÖÐÊÇ¿´²»µ½ÖµµÄ
Æð³õÎÒ»¹ÒÔΪÊý¾ÝûÓвåÈ룬ºóÀ´²ÅÖªµÀntextÀàÐÍÔÚÊý¾Ý¿âÖб¾À´¾Í¿´²»µ½µÄ£¨Êý¾Ý½Ï¶ÌµÄ¿ÉÒÔ¿´µ½£©£»
ÄÇÎÒÒªÏë¿´µ½ntextÊý¾ÝÔõô°ì£¿
ÔÚ²éѯ·ÖÎöÆ÷ÖпÉÒÔ¿´µ½£¨²éѯ·ÖÎöÆ÷ÖÐÒ²Ö»¿´µ½ÁËǰ¼¸Ê®¸ö×Ö·û£¬¡¡²»ÊÇÈ«²¿µÄ£© ......
¡¡¾³£¿´¼ûÓÐÈËÎÊ£¬MSSQLÕ¼ÓÃÁËÌ«¶àµÄÄڴ棬¶øÇÒ»¹²»¶ÏµÄÔö³¤£»»òÕß˵ÒѾÉèÖÃÁËʹÓÃÄڴ棬¿ÉÊÇËüûÓÐÓõ½ÄÇô¶à£¬ÕâÊÇÔõôһ»ØÊ¶ùÄØ£¿
¡¡¡¡Ê×ÏÈ£¬ÎÒÃÇÀ´¿´¿´MSSQLÊÇÔõÑùʹÓÃÄÚ´æµÄ¡£
¡¡¡¡×î´óµÄ¿ªÏúÒ»°ãÊÇÓÃÓÚÊý¾Ý»º´æ£¬Èç¹ûÄÚ´æ×ã¹»£¬Ëü»á°ÑÓùýµÄÊý¾ÝºÍ¾õµÃÄã»áÓõ½µÄÊý¾ÝͳͳÈÓµ½ÄÚ´æÖУ¬Ö±µ½ÄÚ´æ²»×ãµÄʱºò ......