通用的更新存储过程和删除存储过程

CREATE PROCEDURE [ProductSortDel]
(
@Id int,
@a_TableName Varchar(30)
)
AS
DECLARE @SQL VARCHAR(200)
SET @SQL='DELETE FROM ' +@a_TableName+ ' WHERE Id='+CAST(@Id AS VARCHAR)
EXEC( @SQL)
GO


CREATE PROCEDURE Product_SortUpdate
(
@Id int,
@Parentid int,
@a_TableName Varchar(30),
@DirectorName nvarchar(50)
)
AS
DECLARE @SQL VARCHAR(200)
SET @SQL='UPDATE '+@a_TableName+
' SET '+'DirectionName='''+@DirectorName+''','+
'Parentid='+CAST(@Parentid AS VARCHAR)+' '+
'WHERE Id='+CAST(@Id AS VARCHAR)
EXEC( @SQL)
GO