May 7, 2014 at 12:11 am
hi
I want a mechanism that search the content of all files in my upload folder,then return the address of the file that contains that keyword
plz pay attention that the content of the files are not in the table,just the addresses are saved in table
May 7, 2014 at 12:26 am
This seems more the job for a .NET application.
An example:
File Content and Directory Search using Directory.GetFiles and PLINQ
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
May 7, 2014 at 12:42 am
SSIS + Script Task
or
Load to a table (SSIS/bcp/openrowset) and. search in SQL
or
Powershell...
or
External application
or
batch file + sqlcmd
or
....
😎
May 7, 2014 at 12:59 am
shima_khosravani (5/7/2014)
hiI want a mechanism that search the content of all files in my upload folder,then return the address of the file that contains that keyword
plz pay attention that the content of the files are not in the table,just the addresses are saved in table
Are you sure to do it in SQL ? As suggested by others that it is easier to do it in .net.Also may be you'll have better performance as well.
--rhythmk
------------------------------------------------------------------
To post your question use below link
https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help
🙂
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply