日期:2014-05-18 浏览次数:20466 次
create procedure [dbo].[DeleteData] ( @TableName nvarchar, @ListName nvarchar, @Sign nvarchar, @Param nvarchar ) as Declare @sql nvarchar set @sql = N'Delete from ' + @TableName + N' where ' + @ListName + N' ' + @Sign + N' ' + @Param select @sql exec @sql
create procedure [dbo].[DeleteData] ( @TableName nvarchar(30), @ListName nvarchar(50), @Sign nvarchar(20), @Param nvarchar(20) ) as Declare @sql nvarchar(8000) ......
------解决方案--------------------
exec (@sql)