Generate create, read, update, delete stored procedure for single table/table with prefix/schema in SQL SEREVR. This stored procedure generate six stored procedure for specified table. Insert Only, Update Only, Select Only (All or By ID), Delete Only, Insert/Update in one stored procedue, Get List (with pagination)
Examples
EXEC [dbo].[usp_GenerateCRUD] 'HumanResources.Employee','','Kamal Khanal' -- table name and author name
EXEC [dbo].[usp_GenerateCRUD] '','HumanResources', 'Kamal Khanal' --table name, prefix (all schema/table name start with HumanResources) and author name
EXEC [dbo].[usp_GenerateCRUD] 'HumanResources.Employee','', 'Kamal Khanal',1 --table name, prefix, author name with nolock hint
EXEC [dbo].[usp_GenerateCRUD] 'HumanResources.Employee','', 'Kamal Khanal',0,1 --table name, prefix, author name and execute
EXEC [dbo].[usp_GenerateCRUD] 'HumanResources.Employee_Temporal', '', 'Kamal Khanal'
