gebeurtenis
31 mrt, 23 - 2 apr, 23
De grootste SQL-, Fabric- en Power BI-leerevenement. 31 maart – 2 april. Gebruik code FABINSIDER om $ 400 te besparen.
Zorg dat u zich vandaag nog registreertDeze browser wordt niet meer ondersteund.
Upgrade naar Microsoft Edge om te profiteren van de nieuwste functies, beveiligingsupdates en technische ondersteuning.
Applies to:
SQL Server
This topic shows how to create a table for storing FILESTREAM data.
When the database has a FILESTREAM filegroup, you can create or modify tables to store FILESTREAM data. To specify that a column contains FILESTREAM data, you create a varbinary(max) column and add the FILESTREAM attribute.
In SQL Server Management Studio, click New Query to display the Query Editor.
Copy the Transact-SQL code from the following example into the Query Editor. This Transact-SQL code creates a FILESTREAM-enabled table called Records.
To create the table, click Execute.
The following code example shows how to create a table that is named Records
. The Id
column is a ROWGUIDCOL
column and is required to use FILESTREAM data with Win32 APIs. The SerialNumber
column is a UNIQUE INTEGER
. The Chart
column is a FILESTREAM
column and is used to store the Chart
in the file system.
Notitie
This example refers to the Archive database that is created in Create a FILESTREAM-Enabled Database.
CREATE TABLE Archive.dbo.Records
(
[Id] [uniqueidentifier] ROWGUIDCOL NOT NULL UNIQUE,
[SerialNumber] INTEGER UNIQUE,
[Chart] VARBINARY(MAX) FILESTREAM NULL
);
GO
gebeurtenis
31 mrt, 23 - 2 apr, 23
De grootste SQL-, Fabric- en Power BI-leerevenement. 31 maart – 2 april. Gebruik code FABINSIDER om $ 400 te besparen.
Zorg dat u zich vandaag nog registreertTraining
Module
Create tables in Microsoft Dataverse - Training
Explore secure data management with Dataverse, learning how to create tables and import data into a cloud-based storage system.
Documentatie
Access FILESTREAM data with Transact-SQL - SQL Server
Learn how to use the Transact-SQL INSERT, UPDATE, and DELETE statements to access and manage FILESTREAM data.
Create a FILESTREAM-Enabled Database - SQL Server
Configure a database to support FILESTREAM by using the CONTAINS FILESTREAM clause when you create or alter the database.
Access FILESTREAM Data with OpenSqlFilestream - SQL Server
Find out how to access FILESTREAM data with OpenSqlFilestream. View examples demonstrating how to use this API to obtain a Win32 handle.