Alter PROCEDURE GetResInfo --注意数据类型
@BuildBasicID int =null,
@CompanyName VARCHAR(80)=null
AS
declare @sql varchar(8000)
set @sql=''
if @BuildBasicID is not null
BEGIN
SET @sql=@sql +' and BuildBasicID='+cast(@BuildBasicID as varchar(20))
END
if @CompanyName is not null
BEGIN
SET @sql=@sql +' and CompanyName='''+@CompanyName+''''
END
if @sql=''
SELECT * FROM dbo.CompanyInfo
else
begin
set @sql='SELECT * FROM CompanyInfo where 1=1 '+@sql
exec (@sql)
end
go
--执行SQL
exec GetResInfo 515,'北京佳亿天地商务服务有限责任公司'
转载于:https://www.cnblogs.com/VirtualLive/archive/2010/01/25/1655631.html