½âÎöMicrosoft Sql ServerÖеÄlikeÓï¾ä
ʹÓà LIKE µÄģʽƥÅä
µ±ËÑË÷ datetime ֵʱ£¬ÍƼöʹÓà LIKE£¬ÒòΪ datetime Ïî¿ÉÄܰüº¬¸÷ÖÖÈÕÆÚ²¿·Ö¡£ÀýÈ磬Èç¹û½«Öµ 19981231 9:20 ²åÈëµ½ÃûΪ arrival_time µÄÁÐÖУ¬Ôò×Ó¾ä WHERE arrival_time = 9:20 ½«ÎÞ·¨ÕÒµ½ 9:20 ×Ö·û´®µÄ¾«È·Æ¥Å䣬ÒòΪ SQL Server ½«Æäת»»Îª 1900 Äê 1 Ô 1 ÈÕÉÏÎç 9:20¡£È»¶ø£¬×Ó¾ä WHERE arrival_time LIKE '%9:20%' ½«ÕÒµ½Æ¥Åä¡£
likeÖ§³Ö ASCII ģʽƥÅäºÍ Unicode ģʽƥÅä¡£µ±ËùÓвÎÊý£¬°üÀ¨ match_expression¡¢pattern ºÍ escape_character£¨Èç¹ûÓУ©¶¼ÊÇ ASCII ×Ö·ûÊý¾ÝÀàÐÍʱ£¬½«Ö´ÐÐ ASCII ģʽƥÅä¡£Èç¹ûÆäÖÐÈκβÎÊýÊôÓÚ Unicode Êý¾ÝÀàÐÍ£¬ÔòËùÓвÎÊý½«±»×ª»»Îª Unicode ²¢Ö´ÐÐ Unicode ģʽƥÅä¡£µ±¶Ô Unicode Êý¾Ý£¨nchar »ò nvarchar Êý¾ÝÀàÐÍ£©Ê¹Óà LIKE ʱ£¬Î²Ëæ¿Õ¸ñÊÇÓÐÒâÒåµÄ¡£µ«ÊǶÔÓÚ·Ç Unicode Êý¾Ý£¬Î²Ëæ¿Õ¸ñûÓÐÒâÒå¡£Unicode LIKE Óë SQL-92 ±ê×¼¼æÈÝ¡£ASCII LIKE Óë SQL Server µÄÔçÆÚ°æ±¾¼æÈÝ¡£
ÏÂÃæµÄһϵÁÐʾÀýÏÔʾ ASCII LIKE ģʽƥÅäÓë Unicode LIKE ģʽƥÅäËù·µ»ØµÄÐÐÖ®¼äµÄ²îÒ죺
-- ASCII pattern matching with char column
CREATE TABLE t (col1 char(30))
INSERT INTO t VALUES ('Robert King')
SELECT *
from t
WHERE col1 LIKE '% King' -- returns 1 row
-- Unicode pattern matching with nchar column
CREATE TABLE t (col1 nchar(30))
INSERT INTO t VALUES ('Robert King')
SELECT *
from t
WHERE col1 LIKE '% King' -- no rows returned
-- Unicode pattern matching with nchar column and RTRIM
CREATE TABLE t (col1 nchar (30))
INSERT INTO t VALUES ('Robert King')
SELECT *
from t
WHERE RTRIM(col1) LIKE '% King' -- returns 1 row
˵Ã÷ Èç¹ûʹÓà LIKE ½øÐÐ×Ö·û´®±È½Ï£¬Ä£Ê½×Ö·û´®ÖеÄËùÓÐ×Ö·û¶¼ÓÐÒâÒ壬°üÀ¨Æðʼ¿Õ¸ñ»òÎ²Ëæ¿Õ¸ñ¡£
ʹÓà % ͨÅä·û
Èç¹ûÖ¸¶¨ LIKE '5%'£¬SQL Server ½«ËÑË÷ºóÃæ´øÓÐÁã¸ö»ò¶à¸öÈÎÒâ×Ö·ûµÄÊý×Ö 5¡£
ÀýÈ磬´Ë²éѯ½«ÏÔʾÊý¾Ý¿âÖÐËùÓеÄϵͳ±í£¬ÒòΪËüÃǶ¼ÒÔ×Öĸ sys ¿ªÊ¼£º
SELECT TABLE_NAME
from INFORMATION_SCHEMA.TABLES
WHERE TABLE_NAME LIKE 'sys%'
˵Ã÷ Çë×¢Ò⣺ϵͳ±í¿ÉÒÔËæ°æ±¾²»Í¬¶ø¸ü¸Ä¡£ÍƼöʹÓÃÐÅÏ¢¼Ü¹¹ÊÓͼ»òÊÊÓõĴ洢¹ý³Ì´¦Àí SQL Ser
Ïà¹ØÎĵµ£º
¡¡Ò»¡¢±¸·ÝÊý¾Ý¿â
¡¡¡¡1¡¢´ò¿ªSQLÆóÒµ¹ÜÀíÆ÷£¬ÔÚ¿ØÖÆÌ¨¸ùĿ¼ÖÐÒÀ´Îµã¿ªMicrosoft SQL Server
¡¡¡¡2¡¢SQL Server×é-->Ë«»÷´ò¿ªÄãµÄ·þÎñÆ÷-->Ë«»÷´ò¿ªÊý¾Ý¿âĿ¼
¡¡¡¡3¡¢Ñ¡ÔñÄãµÄÊý¾Ý¿âÃû³Æ£¨ÈçÂÛ̳Êý¾Ý¿âForum£©-->È»ºóµãÉÏÃæ²Ëµ¥ÖеŤ¾ß-->Ñ¡Ôñ±¸·ÝÊý¾Ý¿â
¡¡¡¡4¡¢±¸·ÝÑ¡ÏîÑ¡ÔñÍêÈ«±¸·Ý£¬Ä¿µÄÖеı ......
¡¾SQL SERVER Êý¾Ý¿âʵÓÃSQLÓï¾ä¡¿
1.°´ÐÕÊϱʻÅÅÐò:
Select * from TableName Order By CustomerName Collate Chinese_PRC_Stroke_ci_as
2.·ÖÒ³SQLÓï¾ä
select * from(select (row_number() OVER (ORDER BY tab.ID Desc)) as rownum,tab.* from ±íÃû As tab) As t where rownum between ÆðʼλÖà And ½áÊøÎ»ÖÃ
......
¿Î³ÌÁù ÔËÐÐʱӦÓñäÁ¿
¡¡¡¡
¡¡¡¡±¾¿ÎÖØµã£º
¡¡¡¡
¡¡¡¡1¡¢´´½¨Ò»¸öSELECTÓï¾ä£¬ÌáʾUSERÔÚÔËÐÐʱÏȶԱäÁ¿¸³Öµ¡£
¡¡¡¡
¡¡¡¡2¡¢×Ô¶¯¶¨ÒåһϵÁбäÁ¿£¬ÔÚSELECTÔËÐÐʱ½øÐÐÌáÈ¡¡£
¡¡¡¡
¡¡¡¡3¡¢ÔÚSQL PLUSÖÐÓÃACCEPT¶¨Òå±äÁ¿
¡¡¡¡
¡¡¡¡×¢Ò⣺ÒÔÏÂʵÀýÖбêµã¾ùΪӢÎİë½Ç
¡¡¡¡
¡¡¡¡Ò»¡¢¸ÅÊö£º
¡¡¡¡
¡¡¡¡±äÁ¿¿É ......