Good day,
Can we overwrite the file in a directory using update sql script. If yes, please help me with script
Yes. The update script is like any simple UPDATE script
Check the documentation: FileTables can also be queried and updated through normal Transact-SQL access. They are also integrated with SQL Server management tools, and features such as backup.
This is what make this feature so useful :-)
If I deploy this solution as docker container in linux...
Filetable and FILESTREAM are not supported on linux as describe in the documentation: