FIX: "???-yielding ????????" ?????? ?? ???? ?? ?? ?? ?? ?? ??? CONTAINSTABLE ?????? ?? ????? ???? ?? AND predicates SQL Server 2008 ??? ?? SQL Server 2008 R2 ???

???? ?????? ???? ??????
???? ID: 2344600 - ?? ???????? ?? ?????? ??? ?? ?? ???? ???? ???? ??.
Microsoft ?? downloadable ???? ?? ??? ??? Microsoft SQL Server 2008 ??????? ?????? ???? ??? ??????? ????? ???? ???, ??????? ?? ?? ?????? ??? ??? ?????????? ?? ?? ??? ??????? ??????? ????? SQL Server 2008 ?? ??? ????? ?? ?? ??? ???? ???Microsoft Microsoft SQL Server 2008 ?????? ???? ?? ?? ?? downloadable ???? ?? ??? ??? SQL Server 2008 R2 ?? ???? ??? ??????? ????? ???? ???, ??????? ?? ?? ?????? ??? ??? ?????????? ?? ?? ??? ??????? ??????? ????? SQL Server 2008 ?? SQL Server 2008 R2 ?? ??? ????? ?? ?? ??? ???? ???
??? ?? ??????? ???? | ??? ?? ??????? ????

?? ????? ??

?????

?? ???????? ?? ????? ????.:
  • ???? ??? ??? ?????-??? ??? ?????? ?? ????? ???? ?? ??CONTAINSTABLE?????? ?? ???? ?? ?????,, ??, ??predicates Microsoft SQL Server 2008 ??? ?? SQL Server 2008 R2 ??? ?????? ??? ??? ?????? ?? ???, ???? ????? 50 ??, ??????????:
    Declare @Keywords varchar(4000) = NULL
    
    set @Keywords= N'((((((((((((((((((((((((((((((((((((((((((((((((((((
    ("TOKarchitect" OR "architectural") 
    AND ("TOKengineer" OR "engineer")) 
    AND "gineer") AND ("TOKmechanical" OR "Mechanical")) 
    AND ("TOKengineer" OR "Engineering")) 
    AND ("TOKelectronic" OR "Electronics")) AND ("TOKengineer" OR "Engineer")) AND ("TOKelectronic" OR "Electronics")) AND ("TOKengineer" OR "Engineering")) AND ("TOKelectric" OR "Electrical")) AND ("TOKengineer" OR "Engineer")) AND ("TOKelectric" OR "Electrical")) AND ("TOKengineer" OR "Engineering")) AND ("TOKcontrol" OR "Control")) AND ("TOKsystem" OR "Systems")) AND ("TOKengineer" OR "Engineer")) AND ("TOKproject" OR "Project")) AND ("TOKmanager" OR "Manager")) AND ("TOKengineer" OR "Engineering")) AND "Scheme") AND ("TOKmanufacture" OR "Manufacturing")) AND ("TOKengineer" OR "Engineer")) AND ("TOKmetallurgist" OR "Metallurgy")) AND ("TOKmetallurgist" OR "Metallurgist")) AND ("TOKprocess" OR "Process")) AND ("TOKTechnology" OR "Technology")) AND ("TOKproduct" OR "Production")) AND ("TOKengineer" OR "Engineer")) AND ("TOKQuality" OR "Quality")) AND ("TOKengineer" OR "Engineer")) AND ("TOKQuality" OR "Quality")) AND ("TOKcontrol" OR "Control")) AND ("TOKengineer" OR "Engineer")) AND "Mechatronics") AND ("TOKcivil" OR "Civil")) AND ("TOKengineer" OR "Engineer")) AND ("TOKcivil" OR "Civil")) AND ("TOKengineer" OR "Engineering")) AND ("TOKdesign" OR "Design")) AND ("TOKengineer" OR "Engineering")) AND ("TOKdesign" OR "Design")) AND ("TOKengineer" OR "Engineer")) AND ("TOKgraduate" OR "Graduate")) AND ("TOKengineer" OR "Engineer")) AND ("TOKgraduate" OR "Graduate")) AND ("TOKengineer" OR "engineering")) AND ("TOKengineer" OR "Engineering")) AND ("TOKgraduate" OR "Graduate")) AND ") ANDNOT (") AND ("TOKRecruitment" OR "Recruitment")) AND ("TOKconsultant" OR "consultant")) AND ("TOKtrainee" OR "trainee")) AND ("TOKRecruitment" OR "recruitment"))'
    
    select * from CONTAINSTABLE(test_table, *, @keywords, 1000) 
  • ?? ?????? ??????
?? ???????? ???, ?? "???-yielding ????????" ?????? ?? ???? ??? ??? ??, SQL Server 2008 ?? SQL Server 2008 R2 ????????? ??? ??????? ??? ?? mini-dump ???? ????? ???? ??? ??, ?? SQL ????? ?????? ??? ????? ??? ????? ?????? ??? ???? ??? ??:
<time stamp=""></time>????? '4.0.5' 'dbghelp.dll' ??????? ?? ????? ????
<time stamp=""></time>????? *** spid 0 ?? ??? ????? ?????? ?? ??????? ???? ??? ??????
<time stamp=""></time>????? *
*******************************************************************************
<time stamp=""></time>????? *
<time stamp=""></time>????? * ??????? ????? ????:
<time stamp=""></time>????? *<time></time>SPID<spid></spid>
<time stamp=""></time>????? *
<time stamp=""></time>????? * ???-yielding ????????
<time stamp=""></time>????? *
<time stamp=""></time>????? *
*******************************************************************************
<time stamp=""></time>????? ???? ?? ??? ????? ????????? ?? 0x000000000000030D
<time stamp=""></time>????? ????? ???? ????????? ???? 0x20000001 ???? ????? ???? ????????? ?? ??? ?????? ???? ???
<time stamp=""></time>????? ????????? 0: 0: 0 (0xf94) 0x00000000817481A0 ???????? ?? ???-yielding ???????? 0 ?? ????? ???? ??? ??????? ??? ?????: 12925321224306? ????? Approx CPU Used: ?????? 62 ms ?????????? 75187 ms. ????????? ????? 98%? ?????? ????????? 0% ??? ??????: 76403 ms.
<time stamp=""></time>????? ????????? 0: 0: 0 (0xf94) 0x00000000817481A0 ???????? ?? ???-yielding ???????? 0 ?? ????? ???? ??? ??????? ??? ?????: 12925321224306? ????? Approx CPU Used: ?????? 125 ms ?????????? 145250 ms. ????????? ????? 98%? ?????? ????????? 0% ??? ??????: 148417 ms.
<time stamp=""></time>????? ????????? 0: 0: 0 (0xf94) 0x00000000817481A0 ???????? ?? ???-yielding ???????? 0 ?? ????? ???? ??? ??????? ??? ?????: 12925321224306? ????? Approx CPU Used: ?????? 171 ms ?????????? 205515 ms. ????????? ????? 98%? ?????? ????????? 0% ??? ??????: 209729 ms.
<time stamp=""></time>????? ????????? 0: 0: 0 (0xf94) 0x00000000817481A0 ???????? ?? ???-yielding ???????? 0 ?? ????? ???? ??? ??????? ??? ?????: 12925321224306? ????? Approx CPU Used: ?????? 218 ms ?????????? 266343 ms. ????????? ????? 98%? ?????? ????????? 0% ??? ??????: 271588 ms.
<time stamp=""></time>????? ????????? 0: 0: 0 (0xf94) 0x00000000817481A0 ???????? ?? ???-yielding ???????? 0 ?? ????? ???? ??? ??????? ??? ?????: 12925321224306? ????? Approx CPU Used: ?????? 234 ms ?????????? 325156 ms. ????????? ????? 97%? ?????? ????????? 0% ??? ??????: 333671 ms.
<time stamp=""></time>????? ????????? 0: 0: 0 (0xf94) 0x00000000817481A0 ???????? ?? ???-yielding ???????? 0 ?? ????? ???? ??? ??????? ??? ?????: 12925321224306? ????? Approx CPU Used: ?????? 296 ms ?????????? 386000 ms. ????????? ????? 97%? ?????? ????????? 0% ??? ??????: 396370 ms.

????

?? ?????? ???? ?? ??????? SQL Server 2008 ?? SQL Server 2008 R2 ???? ????? scheduler ?? ??? ???

????????

????? ?????? ???????

SQL Server 2008 R2

?? ?????? ?? ????? ????? ?????? 5 ??? ???? ?????? ???? ??? ??? SQL Server 2008 R2 ?? ??? ?? ????? ?????? ?????? ?? ??????? ???? ?? ??? ???? ???? ?? ???? ??? ???? ??????? ?? ??? Microsoft ???????? ??? ???? ????? ?? ??? ????? ???? ?????? ?? ????? ????:
2438347????? ?????? ?????? 5 SQL Server 2008 R2 ?? ???
???:Builds ????? ???? ???, ??????? ?? ?? ????? ?????? ??? ??? ?????????? ?? ?? ??? ??????? ??????? ????? SQL Server 2008 R2 ?? ??? ????? ?? ?? ??? ???? ??? ?? ??????? ???? ??? ?? ?? ????? ?????? ????? ?????? ?????? ?? ???????? ?? ???? ???? ?? ??? ??? ???? ??????? ?? ???, Microsoft ?????? ??? ??? ???? ????? ?? ??? ????? ???? ?????? ????? ????::
981356SQL Server 2008 R2 SQL Server 2008 R2 ?????? ???? ?? ??? ?????? ??? ?? ?? ????? ??

SQL Server 2008 ?????? ??? 1

?? ?????? ?? ????? SQL Server 2008 ?????? ??? 1 ?? ??? ????? ?????? 10 ??? ???? ?????? ???? ??? ??? ?? ????? ?????? ?????? ?? ???? ??? ???? ??????? ?? ??? Microsoft ???????? ??? ???? ????? ?? ??? ????? ???? ?????? ?? ????? ????:
2279604SQL Server 2008 ?????? ??? 1 ?? ??? ????? ?????? ?????? 10
???:Builds ????? ???? ???, ??????? ?? ?? ????? ?????? ??? ??? ?????????? ?? ?? ??? ??????? ??????? ????? SQL Server 2008 ?? ??? ????? ?? ?? ??? ???? ??? Microsoft ??????? ???? ?? ?? ?? ????? ?????? ????? ?????? ?????? ?? ???????? ?? ???? ???? ?? ??? ??? ???? ??????? ?? ???, Microsoft ?????? ??? ??? ???? ????? ?? ??? ????? ???? ?????? ????? ????::
970365SQL Server 2008 SQL Server 2008 ?????? ??? 1 ?? ?????? ???? ??? ?? ?? ??? ?????? ??? ?? ?? ????? ??
Microsoft SQL Server 2008 ?????????? ??????? SQL Server ?????? ??? ?? ??? ???? ???? ???? ?? SQL Server 2008 ?????? ??? 1 ?? ??????? ???? ?? ??? ??? SQL Server 2008 ?????? ??? 1 ???????? ?? ???? ???? ?????? ??? ???????? ??? ??, ???? ?? ???????? ???? SQL Server ?????? ??? ??? ?????? ???? ???? ?? ?? ???? SQL Server ?????? ??? ??? ????? ???

SQL Server 2008 ?????? ??? 2

?? ?????? ?? ????? ???? ?????? ???? ??? ?? ????? ?????? 1 ??? SQL Server 2008 ?????? ??? 2 ?? ???? ?? ????? ?????? ?????? ?? ???? ??? ???? ??????? ?? ??? Microsoft ???????? ??? ???? ????? ?? ??? ????? ???? ?????? ?? ????? ????:
2289254SQL Server 2008 ?????? ??? 2 ?? ??? ????? ?????? 1
???:Builds ????? ???? ???, ??????? ?? ?? ????? ?????? ??? ??? ?????????? ?? ?? ??? ??????? ??????? ????? SQL Server 2008 ?? ??? ????? ?? ?? ??? ???? ??? ?? ??????? ???? ??? ?? ?? ????? ?????? ????? ?????? ?????? ?? ???????? ?? ???? ???? ?? ??? ??? ???? ??????? ?? ???, Microsoft ?????? ??? ??? ???? ????? ?? ??? ????? ???? ?????? ????? ????::
2402659SQL Server 2008 SQL Server 2008 ?????? ??? 2 ?? ?????? ???? ??? ?? ?? ??? ?????? ??? ?? ?? ????? ??

????? ?????????

?? ?????? ?? ?? ???? ?? ??? predicate ?? ????????? ???? ?? ????????? ???? ?? ??? ??? ?????-??? ??? ?? ?????? ??????? ?? ????? ?????

??? ???? ?? ???, ?? ?????FORMSOF?? ??? ??????????????, ?? ???? ??? ??? ?????? ???????? ?? ??? ??? ???????

?????? ?? ??? ?? "?????" ??? ??? ????? ???? ??? ??, ????? ?? ????? ?????? ?? ??????? ???????:
Select * from test_table where Contains(*,'FORMSOF (THESAURUS,"architectural","engineer","Mechanical","Engineering","Electronics","Engineer","Electrical","Control","Systems","Project","Manager","Manufacturing","Metallurgy","Metallurgist","Process",?Design?,"Technology","Production","Quality","Control","Civil","Graduate","Recruitment","consultant","trainee","recruitment")')

??????

Microsoft ?? ?????? ?? ?? ?? ?? ?? Microsoft ???????? ??? ?? ?????? ?? ?? "???? ???? ???? ???" ?????? ???????? ???..

??????

?? ???? ??? ???? ??????? ?? ???CONTAINSTABLE?????? ?? ???, ????? Microsoft ?????? ??????? (MSDN) ??? ???? ?? ????:
CONTAINSTABLE ?????? ?? ???? ??? ??????? ???????
???? ??????? ?? ??? ????????? Servicing ???? SQL ????? ?? ???, Microsoft ???????? ??? ???? ????? ?? ??? ????? ???? ?????? ?? ????? ????:
935897?? ????????? Servicing ???? ?? SQL Server ??? ?? ??????? ?? ?? ???????? ?? ??? ?? ???????? ?? ?????? ???? ?? ??? ?????? ??
SQL ????? ?????? ?? ??? ?????? ?????? ?? ???? ??? ???? ??????? ?? ??? Microsoft ???????? ??? ???? ????? ?? ??? ????? ???? ?????? ?? ????? ????:
822499Microsoft SQL Server ?????????? ?????? ???????? ?? ??? ??? ?????? ??????
?????????? ?????? ???????? ?? ???? ??? ???? ??????? ?? ???, Microsoft ?????? ??? ??? ???? ????? ?? ??? ????? ???? ?????? ????? ????::
824684Microsoft ?????????? ???????? ?? ????? ???? ?? ??? ????? ?? ???? ???? ???? ???????? ?? ?????

???

???? ID: 2344600 - ????? ???????: 20 ??????? 2010 - ??????: 4.0
???? ???? ???? ??:
  • Microsoft SQL Server 2008 Developer
  • Microsoft SQL Server 2008 Enterprise
  • Microsoft SQL Server 2008 Service Pack 1
  • Microsoft SQL Server 2008 Standard
  • Microsoft SQL Server 2008 Standard Edition for Small Business
  • Microsoft SQL Server 2008 Workgroup
  • Microsoft SQL Server 2008 R2 Developer
  • Microsoft SQL Server 2008 R2 Enterprise
  • Microsoft SQL Server 2008 R2 Standard
  • Microsoft SQL Server 2008 R2 Standard Edition for Small Business
  • Microsoft SQL Server 2008 R2 Workgroup
??????: 
kbqfe kbfix kbsurveynew kbexpertiseadvanced kbmt KB2344600 KbMthi
???? ?????? ????????
??????????: ?? ???? ?? ???? ??????? ?? ????? ?? Microsoft ????-?????? ?????????? ?????? ?????? ???? ??? ??. Microsoft ???? ??? ????-???????? ?? ????-???????? ????? ?????? ?? ???? ???????? ???? ?? ???? ????? ????? ??? ?? ??? ?????? ?? ???? ???? ???? ??? ????? ??. ???????, ????-???????? ???? ????? ???? ???? ???? ???. ?????, ????????, ?????-???? ?? ??????? ?? ???????? ?? ???? ???, ???? ?? ??? ?????? ???? ???? ??? ????? ??? ?? ???? ??. Microsoft ??????? ??? ???? ?? ?????? ?? ??????????, ????????? ?? ??? ?????? ?? ???? ????? ?? ???? ???????? ?? ??? ???? ????? ?? ??? ????????? ???? ??. Microsoft ????-?????? ?????????? ?? ????? ?????? ?? ?? ??? ??.
?????????? ?? ??????? ????????? ??????? ??:2344600

??????????? ???

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com