Hi @Athulya Pillai ,
You can use the update statement to update directly:UPDATE (Transact-SQL)
As pituach said,Linux does not currently support Filetable.
If you have any question, please feel free to let me know.
Best Regards
Echo
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Hello team,
We are planning to use SQL FIle table. I ahve two queries
1.Can we overwrite the file in a directory using update sql script. If yes, please help me with script
Thanks
Athulya
Hi @Athulya Pillai ,
You can use the update statement to update directly:UPDATE (Transact-SQL)
As pituach said,Linux does not currently support Filetable.
If you have any question, please feel free to let me know.
Best Regards
Echo
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: