SQL Server

Use JdbcTemplate, method annotations, Mapper files, or the Builder API with SQL Server. The following pages cover database-specific configuration and usage.

Scenario	Usage
Key generation	IDENTITY; read sequences before insertion
Pagination	ROW_NUMBER() pagination
Insert conflicts	Insert or update with MERGE
Data backfill	Return written fields with OUTPUT

• Programmatic API: queries, writes, multiple results, and stored routine differences.
• Mapper API: annotations, Mapper reads and writes, and execution differences.
• Builder API: Supported operations, datasource-specific behavior, and usage.
• Pagination: Page queries and total counts.
• Insert Conflicts: Handle existing records during insertion.
• Cross-Database Table Mapping: Specify a database and schema.
• Name Sensitivity: Distinguish database name rules from result column matching.
• Key Generation: Configure and retrieve IDs.
• Data Backfill: Read values returned by a write.
• Type Support: Choose Java property types.
• Transaction Support: Roll back multiple writes on failure.