Generate CLI-ready T-SQL for Microsoft Fabric Data Warehouse: first create table sales.orders with order_id, customer_id, order_date, and amount columns; then add a status column and create a primary key on order_id. Output in execution order with brief comments.

An executable T-SQL script to create and alter the table in the correct order.

Generate a Fabric Warehouse T-SQL loading script that ingests Parquet files from an ADLS path into dbo.fact_sales using COPY INTO, including basic error handling and row count checks before and after loading.

A data loading script with COPY INTO, validation steps, and basic fault handling.

Write T-SQL for a Fabric SQL endpoint to merge data from staging.customer_updates into dbo.customers using MERGE for inserts and updates. Include an explicit transaction, rollback on errors, and guidance for handling concurrency conflicts.

A complete script including MERGE, transaction control, rollback handling, and concurrency guidance.