SQL Server 2008 R2：准备动态WHERe子句

这就是所谓的全部查询，它基本上是这样的：

CREATE PROCEDURE spTest    @Name varchar(20) = '',    @Address varchar(100) = '',    @City varchar(50) = '',    @Pin varchar(50) = ''AS    SELECt *     FROM Test_Table     WHERe (@Name = '' OR Name = @Name)    AND (@Address = '' OR Address = @Address)    AND (@City = '' OR City = @City)    AND (@Pin = '' OR Pin = @Pin);GO