SELECT * FROM dbo.TB WHERE (@id IS NULL OR id = @id)
if @id IS NULL select * from tb else select * from tb where id=@id
这个方法我知道,但是如果是多个条件呢? SELECT * FROM dbo.TB WHERE 1 = 1 AND (@id IS NULL OR id = @id) AND (@name IS NULL OR name = @name) AND (@age IS NULL OR age = @age)
这个方法我知道,但是如果是多个条件呢? SELECT * FROM dbo.TB WHERE 1 = 1 AND (@id IS NULL OR id = @id) AND (@name IS NULL OR name = @name) AND (@age IS NULL OR age = @age)非常感谢啊。。
FROM dbo.TB
WHERE (@id IS NULL OR id = @id)
if @id IS NULL
select * from tb
else
select * from tb where id=@id
这个方法我知道,但是如果是多个条件呢?
SELECT *
FROM dbo.TB
WHERE 1 = 1
AND (@id IS NULL OR id = @id)
AND (@name IS NULL OR name = @name)
AND (@age IS NULL OR age = @age)
这个方法我知道,但是如果是多个条件呢?
SELECT *
FROM dbo.TB
WHERE 1 = 1
AND (@id IS NULL OR id = @id)
AND (@name IS NULL OR name = @name)
AND (@age IS NULL OR age = @age)非常感谢啊。。