Will a single stored procedure generated dynamically for website work fine?

Question

Hi all Please suggest me on this.. If not should i create sp dor all the tables for a web application/website

Pravin More · Answer

it will work fine......i think it will be good if add begin end transaction commit and rollback in case of insertupdate delete. Thanks Pravin.

B M Suchitra · Answer

Hi I have created a SP like this: create procedure [dbo].[USP_InsertUpdateDelete] @Columns varchar(MAX) @ValueClause varchar(MAX) @SetClause varchar(MAX) @WhereClause varchar(MAX) @TableName varchar(MAX) @Case int AS BEGIN DECLARE @QRY varchar(MAX) if(@Case=1) BEGIN SET @QRY='insert into '+@TableName+'('+@Columns+')VALUES('+@ValueClause+')'; EXEC(@QRY) END IF(@Case=2) BEGIN SET @QRY='update '+@TableName+'SET'+@SetClause+'where '+@WhereClause+''; EXEC(@QRY) END IF(@Case=3) BEGIN SET @QRY='delete '+@TableName+' where '+@WhereClause+''; EXEC(@QRY) END END ========================================================== Can i use this single SP for the whole database? How will it impact my website?

Suthish Nair · Answer

Can you rephrase you question its difficult to understand what you asking here.