Detailed search in a large sql file

I have a sql file of about 7 gb and in this file I want to ‘Write more than one word in the search field and show the rows in which these two words I wrote at the same time’

what is this "sql file" ?

A very complex database

You can take a look at Full Text Catalog or use a simple query, it depends on your requirements and budget. This is a good starting point:

Full-Text Search - SQL Server | Microsoft Learn

1 Like