1、存储过程:
create proc lbtPro
(@param varchar(100))
as
begin
declare @count int
select @count=COUNT(*) from dbo.LbtProjectInfo
where LbtProjectInfo.ProjectName like @param
return @count
end
执行:
declare @param varchar(200)
declare @count int
set @param='武汉%'
exec @count=lbtPro @param
print @count
打印出结果:58