exec usp_DBA_createSPs 'MyTable', 'tmp', 'col1, col2'
proc_tmp_MyTable_save - does update if row exists (based on key) and insert if none. returns ID of row updated/inserted
proc_tmp_MyTable_delete delete (based on key) with insert to deleted table
fTbl_tmp_MyTable_get - no paging, with "where" templates for each parameter type
fTbl_tmp_MyTable_list - provide paging
I have written this script while back. I have used one of the scripts I have found online.Sorry I do not remember where I've got script originally
It was changed by adding more logic to SP, adding functions, as well as fixing size limitation and other bugs.