General delete query statement stored procedure
ALTER PROCEDURE [dbo]. [sp_deletetable]
@ tablename nvarchar
@ condition nvarchar (500)
AS
BEGIN
DECLARE @ Sql nvarchar
SET @ Sql='delete from'+ @ tablename+''+ @ condition
-- PRINT @ Sql
EXEC (@ Sql)
END
General query statement stored procedure
ALTER PROCEDURE [dbo]. [sp_getdatabyCondition]
@ tablename nvarchar (50)
@ conlumns nvarchar
@ condition nvarchar
AS
BEGIN
DECLARE @ sql nvarchar 1000
SET @ sql='select'+ @ conlumns + 'from' + @ tablename+''+ @ condition
EXEC (@ sql)
END
