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

it will work fine......i think it will be good if add begin end transaction, commit and rollback in case of insert,update delete.


Thanks,
Pravin.

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?