--用存储过程
Create PROC p_test
@para1 varchar(10)=null,
@para2 varchar(10)=null,
@para3 varchar(10)=null,
@para4 varchar(10)=null,
@para5 varchar(10)=null
AS
SET NOCOUNT ON
DECLARE @sql varchar(8000)
SET @sql='SELECT * FROM V_TagName WHERE 1=1'
IF @para1 IS NOT NULL
SET @sql=@sql+' AND BelongJZ='''+@para1+''''
IF @para2 IS NOT NULL
SET @sql=@sql+' AND TagName='''+@para2+''''
IF @para3 IS NOT NULL
SET @sql=@sql+' AND Type='''+@para3+''''
IF @para4 IS NOT NULL
SET @sql=@sql+' AND Desc='''+@para4+''''
IF @para5 IS NOT NULL
SET @sql=@sql+' AND BeLongGraph='''+@para3+''''
EXEC(@sql)
GO
Exec P_Test '一号机组',null,null,null,null
---
在程序中调用存储过程就可以了!