Which of the following T SQL features is supported in SQL Azure?

Question

You can export data from external storage (Azure data lake, Dataverse, Cosmos DB) into Azure data lake using CETAS. Yes, all Transact-SQL types are supported, except cursor, hierarchyid, ntext, text, and image, rowversion, Spatial Types, sql_variant, xml, and Table type.

Which of the following T-SQL feature is not supported on SQL Azure?

The CREATE TABLE and ALTER TABLE statements have FILETABLE and FILESTREAM options that can't be used on SQL Database because these features aren't supported.

What are the features of Azure SQL Database?

Top 5 SQL in Azure Database FeaturesScalability and Resource Management with Elastic Pools. Scalability monitors alert you to the need of growth or retraction with ease all with cost in mind. ... Performance Tuning. ... Security. ... Business Consistency Features. ... Scalability of Azure SQL Database.

What are the features of T-SQL?

Below are some major features.Procedural programming.Various computational, scalar and mathematical support functions.Data manipulation commands with FROM clause that can be used along with Join operations.BULK INSERT functionality to import large data file.

Can we use T-SQL to query SQL Azure?

Query editor (preview) is a tool to run SQL queries against Azure SQL Database in the Azure portal. In this quickstart, you connect to an Azure SQL database in the portal and use query editor to run Transact-SQL (T-SQL) queries.

Expert · Answer