Kevin Martin

icon indicating a website link https://kevinmartin.tech

icon location Minnesota icon location Data architect, developer and author of the open-source projects sp _CRUDGen and sp_Develop, used by database and software developers. Find them on GitHub.

Results 5 issues of Kevin Martin

Indent is not perfect for upsert & indate

The /*[INDENT SPACES]*/ on upsert generation is not correct based on @HasVersionStamp.

Not specifying JSON column schema

1 comment

**Describe the bug** When extracting the JSON parameter into the temp table only the Value is being extracted. There are articles written that says to specify the schema using the...

Create Delete Rule on Foreign Key Relationships

Currently, smarter and manually created delete and update stored procedures are recommended when the need for cascading, setting NULL or setting DEFAULT are required. Feature request: Create Delete generated stored...

Generate Temporal Table DIFF Logging Stored Procedure

This stored procedure could extract changes from temporal tables and compare with the current record. When there is a difference, a row can be entered into a log/note type table....

Add the ability to included linking joined tables

Currently tables that are created as linking (many-to-many) tables are not added for the searched stored procedure generation.