sql-generate-insert
sql-generate-insert copied to clipboard
drumsta
INSERT statement(s) generator
It would be great to be able to filter the resulting insert statements to only those that fulfill a specific statement, by id could work for the start.
If you have more that 1000 record in script it will not be executed due to error: > The number of row value expressions in the INSERT statement exceeds the...
Table: sys.objects Column name: type - [ ] IT = Internal table - [ ] S = System base table - [x] IF = SQL inline table-valued function - [x]...
``` CREATE TABLE [HumanResources].[Employee]( [BusinessEntityID] [int] NOT NULL, [NationalIDNumber] [nvarchar](15) NOT NULL, [LoginID] [nvarchar](256) NOT NULL, [OrganizationNode] [hierarchyid] NULL, [OrganizationLevel] AS ([OrganizationNode].[GetLevel]()), [JobTitle] [nvarchar](50) NOT NULL, [BirthDate] [date] NOT NULL,...
Applies to: SQL Server 2016, Azure SQL Database, Azure SQL Data Warehouse, Parallel Data Warehouse. sys.objects.type = 'ET'
This PR fixes the bug I previously reported: https://github.com/drumsta/sql-generate-insert/issues/23 Thanks again!
# Thanks! First of all, the project is simple and extremely useful; thanks for that!!! Do you have a cafecito app, patreon or similar account? ## Describe the bug When...