一条SQL语句的存储过程,共享!!!
李洪喜 2004-09-06 02:40:09 CREATE PROCEDURE find_all
@pro_field varchar(20), ----要查找的字段
@find_condition varchar(20), ----要查找的内容,只是\针对字符型的
@table as varchar(50) ----要查找的数据表
AS
declare @SQLSTRING as nvarchar(4000)
select @SQLSTRING = '
select *
from '+@table+'
where '+ @pro_field+' like '+''''+'%'+ @find_condition + '%'+''''
print @SQLSTRING
exec sp_executesql @SQLString