shilpig (7/23/2009)
Deepthi,This SP does not create update procedure for table, if primary key is identity column, which happens to be very common scenario usually. Can you update this accordingly. Thanks!!
More worryingly, if your PK is an identity the delete procedure does not specify a where clause!
/*-- =============================================
-- Author : dbo
-- Create date : Jul 23 2009 8:14AM
-- Description : Delete Procedure for testtable
-- Exec [dbo].[sp_testtable_delete]
-- ============================================= */
ALTER procedure [dbo].[sp_testtable_delete]
as
begin
delete from testtable
end
A nice idea though - writing boilerplate CRUD procedures can be tiresome.