如何编写SQL查询中where where子句内的条件？

问题描述

推荐答案

select * from Doctorslist
where DoctorName = isnull(@Name,DoctorName)
and Country = isnull(@Country,Country)
and State = isnull(@State,State)

--@WhereStatement should be in format:
-- [Name] = 'SomeName'
--or  
-- [Speciality] = 'SomSpeciality'
--and so on...
CREATE PROCEDURE usp_GetDoctorDetails
    @WhereStatement VARCHAR(300) NULL
AS
BEGIN
    DECLARE @sql VARCHAR(MAX)

    SET @sql = N'SELECT * FROM DoctorsList '
    IF (NOT @WhereStatement IS NULL)
        SET @sql = @sql + @WhereStatement

    EXEC(@sql)
END

使用 []获取有关动态查询的更多详细信息。

Use SearchBox[^] to get more details about dynamic queries.

这篇关于如何编写SQL查询中where where子句内的条件？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！