Shulou(Shulou.com)06/01 Report--

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

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.