question

AthulyaPillai-7025 avatar image
0 Votes"
AthulyaPillai-7025 asked pituach edited

SQL File Tables

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

  1. We will use this file table to read and write the contents of file in net core application.
    If I deploy this solution as docker container in linux, will I be able to read the contents of file in SQL file table. Please help


Thanks
Athulya


sql-server-transact-sql
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @AthulyaPillai-7025,
Has your problem been solved? If it is solved,please remember to accept the answers if they helped. This can help others who encounter similar problems..

Best Regards
Echo

0 Votes 0 ·
pituach avatar image
0 Votes"
pituach answered pituach edited

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:

https://docs.microsoft.com/en-us/sql/linux/sql-server-linux-editions-and-components-2019?view=sql-server-ver15#Unsupported

20804-image.png



image.png (34.4 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

EchoLiu-msft avatar image
0 Votes"
EchoLiu-msft answered pituach edited

Hi @AthulyaPillai-7025,

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




5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.