SQLTeam.com | Weblogs | Forums

Comparing doc or pdf Files from Using SQL Server

sql2008r2
tsql
sql2012
sql2014
sql2008

#1

hi friends
i have very interesting qeustion
can we comparing two another files with sql server
for example
in varbinary column have a pdf format file
in inserting new data in this table first i need compare
files with another files in my table
have this file in this table or not
and
can we compare files finding text from inserting file data
thanks


#2

are you using FileTables or FILESTREAM?

If so, then the files are actually stored as files on the file system which should help your searching