參考:
- https://docs.microsoft.com/zh-tw/sql/t-sql/statements/create-external-table-transact-sql?view=sql-server-ver15&tabs=dedicated
1.先建立連線
2.資料表語法
CREATE EXTERNAL TABLE [dbo].[MyTable]
(
[Id] [varchar](64) NULL,
[Name] [varchar](64) NULL
)
WITH (DATA_SOURCE = [MyDataSource])
GO