sqlÓï¾ä´íÎó - MS-SQL Server / »ù´¡Àà

select * from dbo.[Report] where ID like %1% or Report_num like %1% or ID like %ehs% or Report_num like %ehs% order by ID £»

ÏûÏ¢ 102£¬¼¶±ð 15£¬×´Ì¬ 1£¬µÚ 1 ÐÐ
'1' ¸½½üÓÐÓï·¨´íÎó¡£

---

select * from dbo.[Report] where ID like '%1% 'or Report_num like '%1% 'or ID like '%ehs% 'or Report_num like' %ehs%' order by ID

---

like '%1%'

---

'%1%'
ºóÃæµÄÄÇЩÌõ¼þÒ²¶¼Òª¼ÓÉÏÒýºÅ

---

...Êý¾Ý¿âÀïµÄ×Ö·û´®Òª¼ÓÒýºÅµÄѽ£¡

---

SQL code:
select *
from dbo.[Report]
where ID like '%1% 'or Report_num like '%1%'
or ID like '%ehs%' or Report_num like '%ehs%'
order by ID

---

SQL code:
select *
from dbo.[Report]
where ID like '%1%' or Report_num like '%1%'
or ID like '%ehs%' or Report_num like '%ehs%'
order by ID

LIKEºóÃæ¼ÓÒýºÅ£¬Í¬Ê±×¢ÒâÒýºÅÄÚ²»ÄÜÓпոñ£¬³ý·ÇÌØÊâÐèÒª¡£

---

¼ÓÉÏ''

---

Õâ¸öµ¥ÒýºÅÎÒºóÀ´×Ô¼ºÒ²ÕÒ³öÀ´ÁË£¬µ«ÏÖÔÚÊÇÎÒµÄÓï¾äÔÚÊý¾Ý¿âÀï¿ÉÒÔÔËÐУ¬ÔÚC#±àÒëÆ÷Àï¾Í²»ÐÐÁË¡£ÏêϸÓï¾ä¼ûÏ£º
select * from dbo.[Report] where ID like '%1%' or Report_num like '%1%' or ID like '%ehs%' or Report_num like '%ehs%' order by ID ;
ÔÚÊý¾Ý¿âûÎÊÌâ¡£ÔÚvs2005À´úÂëÈçÏ£º
C# code

---

Code highlighting produced by Actipro CodeHighlighter (freeware)
http://www