
AdventureWorks Sample Databases - SQL Server | Microsoft Learn
Oct 28, 2025 · You have two options for viewing sample SQL Database data. You can use a sample when you create a new database, or you can deploy a database from SQL Server …
Microsoft SQL samples - SQL Server | Microsoft Learn
Sep 12, 2025 · View information about the WideWorldImporters and AdventureWorks sample databases, Azure samples and templates, and code samples for Microsoft SQL products.
Create a stored procedure - SQL Server | Microsoft Learn
The example stored procedure in this article uses the sample AdventureWorksLT2022 (SQL Server) or AdventureWorksLT (Azure SQL Database) database. For instructions on how to get …
GRANT Database Permissions (Transact-SQL) - SQL Server
Nov 22, 2024 · The most specific and limited permissions that can be granted on a database are listed in the following table, together with the more general permissions that include them by …
Invoke-Sqlcmd (SqlServer) - SQL Server PowerShell
The commands supported are Transact-SQL statements and the subset of the XQuery syntax that is supported by the database engine. This cmdlet also accepts many of the commands …
Database files and filegroups - SQL Server | Microsoft Learn
Jul 22, 2024 · Learn about database files and how to create filegroups in SQL Server for allocation and administrative purposes. View examples, rules, and recommendations.
CREATE TRIGGER (Transact-SQL) - SQL Server | Microsoft Learn
Sep 29, 2025 · The following example uses a DDL trigger to print a message if any CREATE DATABASE event occurs on the current server instance, and uses the EVENTDATA function …
SQL Database Tutorial - Ingest Sample Data and Create Objects …
Feb 20, 2025 · You can input data into the SQL database in Fabric using Transact-SQL (T-SQL) statements, and you can also import data into your database using other Microsoft Fabric …
What are Power BI samples - Power BI | Microsoft Learn
Nov 17, 2015 · Get access to built-in samples and apps, downloadable .pbix and .pbit files, Excel workbooks, and SQL sample databases — all with direct download links and links to articles …
Queries - SQL Server | Microsoft Learn
Nov 22, 2024 · Data Manipulation Language (DML) is a vocabulary used to retrieve and work with data in SQL Server and SQL Database. Most also work in Azure Synapse Analytics and …