View Full Version : Help me about Query???
SELECT COUNT(*) As totalrows FROM CONTAINSTABLE(docs, *,'vnn')
Ai vui lòng giải thích dùm xacuop câu query trên với. CONTAINSTABLE(docs, *,'vnn') có nghĩa là gì vậy? :helpsmili
sontinh2004
13-07-2004, 13:37
Xauop,
SQL Statement la de cho full-text search. No noi la
Dem cac rows trong table "docs", ma trong do bat cu column nao (*) co chu 'vnn'
Neu ban muon biet them chi tiet , xin vao day: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_ca-co_3syt.asp
Good luck!
Cám ơn sontinh nhá, mới vừa tìm ra xong.
sontinh có biết cái này nó execute ra sao ko? xacuop chạy thì nó báo lỗi vầy:
Execution of a full-text operation failed. Langauge database/cache file could not be found.
/SearchEngine/cgi-bin/search.asp, line 161
line 161 là recordset thực hiện câu query đó đó
sontinh2004
18-07-2004, 01:48
Xacuop thu rebuild lai full-text index/catalog di. Co the dung Enterprise Manager hay stored procedure co san (sp_fulltext_catalog, sp_fulltext_database, sp_fulltext_table, sp_fulltext_column, etc ...). Ban co the dung Help trong SQL Analyzer de biet them chi tiet.
Powered by vBulletin® Version 4.2.0 Copyright © 2024 vBulletin Solutions, Inc. All rights reserved.