我想使用select语句来过滤表格数据,我的表格有四列,我也有四个文本框可以在每一列中启用搜索。我可以在任何一个或多个文本框中输入值,当我输入这些值时,我希望返回与我输入的值匹配的记录。如何做到这一点?
ALTER PROCEDURE dbo.test_search
(
@ID int,
@FirstName nvarchar(50),
@MiddleName nvarchar(50),
@LastName nvarchar(50)
)
AS
SELECT ID, FirstName, MiddleName, LastName
FROM StudentsInformation
WHERE (@ID IS NULL OR StudentsInformation.ID = @ID) AND
(@FirstName IS NULL OR StudentsInformation.FirstName = @FirstName )AND
(@MiddleName IS NULL OR StudentsInformation.MiddleName = @MiddleName )AND
(@LastName IS NULL OR StudentsInformation.LastName = @LastName )
RETURN