
Microsoft SQL samples - SQL Server | Microsoft Learn
Sep 29, 2024 · View information about the WideWorldImporters and AdventureWorks sample databases, Azure samples and templates, and code samples for Microsoft SQL products.
AdventureWorks sample databases - SQL Server | Microsoft Learn
Sep 4, 2024 · This article provides direct links to download AdventureWorks sample databases, and instructions for restoring them to SQL Server, Azure SQL Database, and Azure SQL Managed Instance. For more information about samples, see the Samples GitHub repository .
Sql.Database - PowerQuery M | Microsoft Learn
Mar 18, 2025 · Returns a table of SQL tables, views, and stored functions from the SQL Server database database on server server. The port may be optionally specified with the server, separated by a colon or a comma.
SELECT examples (Transact-SQL) - SQL Server | Microsoft Learn
Nov 22, 2024 · The code samples in this article use the AdventureWorks2022 or AdventureWorksDW2022 sample database, which you can download from the Microsoft SQL Server Samples and Community Projects home page. A. …
Bicep: Create a single database - Azure SQL Database
Sep 18, 2024 · Applies to: Azure SQL Database. Creating a single database is the quickest and simplest option for creating a database in Azure SQL Database. This quickstart shows you how to create a single database using Bicep. Bicep is a domain-specific language (DSL) that uses declarative syntax to deploy Azure resources. It provides concise syntax ...
Use sqlcmd - SQL Server | Microsoft Learn
Nov 22, 2024 · sqlcmd is a command-line utility for ad hoc, interactive execution of Transact-SQL (T-SQL) statements and scripts and for automating T-SQL scripting tasks. To use sqlcmd interactively, or to build script files for sqlcmd , you should understand T-SQL.
Use .NET to connect and query a database on Windows, Linux, or …
Sep 23, 2024 · This article shows you how to use .NET to create a program that connects to a database in Azure SQL Database, or Azure SQL Managed Instance, and queries it using Transact-SQL statements.
Databases - SQL Server | Microsoft Learn
Nov 22, 2024 · A database in SQL Server is made up of a collection of tables that stores a specific set of structured data. A table contains a collection of rows, also referred to as records or tuples, and columns, also referred to as attributes.
School Sample Database - EF6 | Microsoft Learn
Oct 14, 2020 · This topic contains the schema and data for the School database. The sample School database is used in various places throughout the Entity Framework documentation. Note
SQL Server Connection Strings for ASP.NET Web Applications
Jun 18, 2013 · The following example is for a SQL Server database using SQL Server security (log on to the server by using user credentials in the connection string). The example assumes that you are connecting to the default SQL Server instance on the server.