110,500
社区成员
发帖
与我相关
我的任务
分享
SELECT id,bzcode,bzcode1 FROM [Table] WHERE (([bzcode] = @bzcode or len(@bzcode) =0 ) AND ([bzcode1] = @bzcode1 or len(@bzcode1) =0))
CREATE TABLE [dbo].[Table] (
[Id] INT IDENTITY (1, 1) NOT NULL,
[bzcode] NCHAR (10) NULL,
[bzcode1] NCHAR (10) NULL,
PRIMARY KEY CLUSTERED ([Id] ASC)
);
[/quote]
SELECT id,bzcode,bzcode1 FROM [Table] WHERE (([bzcode] = @bzcode or len(@bzcode) =0 ) AND ([bzcode1] = @bzcode1 or len(@bzcode1) =0))
CREATE TABLE [dbo].[Table] (
[Id] INT IDENTITY (1, 1) NOT NULL,
[bzcode] NCHAR (10) NULL,
[bzcode1] NCHAR (10) NULL,
PRIMARY KEY CLUSTERED ([Id] ASC)
);
SELECT id,bzcode,bzcode1 FROM [Table] WHERE (([bzcode] = @bzcode or len(@bzcode) =0 ) AND ([bzcode1] = @bzcode1 or len(@bzcode1) =0))
CREATE TABLE [dbo].[Table] (
[Id] INT IDENTITY (1, 1) NOT NULL,
[bzcode] NCHAR (10) NULL,
[bzcode1] NCHAR (10) NULL,
PRIMARY KEY CLUSTERED ([Id] ASC)
);
[/quote]
select * from table where (a=@a or ''=@a) and ( b=@b or''=@b )
能看明白我写的是什么吗?就是加一个你要传入的值=空的判断就可以实现都为空就查询全部了。
可视化配置好也不好,新的已经越来越简单容易了。但是便利性上还是不如标准版。