T-SQL Compatible Generations
SQL Server (MSSQL) uses T-SQL syntax which differs from MySQL and Postgres. This tool handles the specifics: using BIT for booleans, NVARCHAR(MAX) for large text, and UNIQUEIDENTIFIER for GUIDs. It also wraps identifiers in square brackets [Table] to follow Microsoft standards.
Identity Insert Support
The tool includes the proper T-SQL structure for bulk inserts, making it easy to paste into SQL Server Management Studio (SSMS) or Azure Data Studio.
Frequently Asked Questions
How do I handle primary keys in MSSQL?
You can choose to exclude the primary key column from the INSERT list if your table uses an IDENTITY property for auto-generation.
Are dates handled correctly for T-SQL?
Yes. We use the ISO 8601 format (YYYY-MM-DDTHH:MM:SS) which is the most reliable way to insert date-time values into SQL Server across different regional settings.