Home  • Database • Microsoft SQL Server

SQL Server full text query from multiple tables

SQL Server 1. First enable fulltext with the following query:
SELECT SERVERPROPERTY('IsFullTextInstalled')
sp_fulltext_database 'enable'
2. Then make a following query:
select id, code, name, photo_file_name, category_name category from item_master where  contains((search,barcode),'*atta*') order by name OFFSET 0 ROWS FETCH NEXT 5 ROWS ONLY

Comments 0


Share

Copyright © 2024. Powered by Intellect Software Ltd