mssql://user:password@host:1433/database
sqlserver://user:password@host:1433/database

-- Paginated results
SELECT *
FROM dbo.orders
ORDER BY order_id
OFFSET 0 ROWS FETCH NEXT 50 ROWS ONLY;

-- Row count estimate (fast, uses statistics)
SELECT SUM(p.rows) AS row_count
FROM sys.partitions p
JOIN sys.tables t ON p.object_id = t.object_id
WHERE p.index_id IN (0, 1)
  AND t.name = 'orders';

-- View definition
SELECT OBJECT_DEFINITION(OBJECT_ID('dbo.my_view'));

-- List all tables in the current database
SELECT TABLE_SCHEMA, TABLE_NAME
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_SCHEMA, TABLE_NAME;