DotNetShoutout

Welcome!

DotNetShoutout is a place where you can find the latest Microsoft .NET stories to increase your skills and share your opinions.

Enjoy participating in this community and see which other people in our industry are getting Shoutouts.

faq »

2
Shouts

Shout it

SQL SERVER – Working with FileTables in SQL Server 2012 – Part 3 – Retrieving Various FileTable Properties « SQL Server Journey with SQL Authority

published 392 days, 20 hours, 8 minutes ago posted by

pinaldave 398 days, 17 hours, 50 minutes ago

Read Part 1 Working with FileTables in SQL Server 2012 – Part 1 – Setting Up Environment Read Part 2 Working with FileTables in SQL Server 2012 – Part 2 – Methods to Insert Data Into Table In this third part of the series, we will see how we can retrieve various information from the FileTable database.Identify Directory or File You can run following query which will give details if query is file or directory. USE FileTableDB

GO SELECT [name] ,[filetype] ,CAST([filestream] AS VARCHAR) FileConte...

category: Data | clicked: 48 | | source: blog.sqlauthority.com | show counter code

Border color:

Shout it Backcolor:

Shout it Forecolor:

Count Backcolor:

Count Forecolor:

Preview

update reset

DotNetShoutout

Welcome!

SQL SERVER – Working with FileTables in SQL Server 2012 – Part 3 – Retrieving Various FileTable Properties « SQL Server Journey with SQL Authority

No comments yet, be the first one to post comment.

Open ID Login

Standard Login

Forgot Password?

Sign up