简单查询不会了，帮帮忙！！在线等待

[asun112233]

我想在"select TbrName from tblKQRule where TbrCardNo='"+cardCode+"'"中where后面再加个条件当前系统日期（data=)该怎样写？

[sgtzzc]

convert(varchar(10),getdate(),120)

[sgtzzc]

或者

datediff(dd,data,getdate())=0

[jiangshun]

datediff(dd,Data,getdate())=0

[bancxc]

and  datediff(day,你的字段,getdate())=0
今天的

[nianran520]

select TbrName from tblKQRule where data = getdate()

[asun112233]

我想加载原先的语句后边！！！就是TbrCardNo与data之间用什么连接

[asun112233]

数据库时Sql Server

[nianran520]

[Quote=引用 6 楼 asun112233 的回复:]
我想加载原先的语句后边！！！就是TbrCardNo与data之间用什么连接
[/Quote]and

[jinjazzli]

select TbrName from tblKQRule where datediff(day,data ,getdate())=0

[smallmonkeychen]

and连接啊。。。。。。还有什么疑问啊

[claro]

。。

[tanshi]

[Quote=引用 6 楼 asun112233 的回复:]
我想加载原先的语句后边！！！就是TbrCardNo与data之间用什么连接
[/Quote]
不知道楼主说的是不是这个意思

select TbrName from tblKQRule where TbrCardNo='"+cardCode+"'" and data = getdate()

============================
就是用and

[--小F--]

select TbrName from tblKQRule where datediff(day,data ,getdate())=0

[gxjwqm]

"select TbrName from tblKQRule where TbrCardNo='"+cardCode+"' and datediff(day,data ,getdate())=0 "

[-狙击手-]

select TbrName from tblKQRule where TbrCardNo='"+cardCode+"'" and datediff(d,data , getdate()) = 0

[abcdef1111111]

[Quote=引用 15 楼 happyflystone 的回复:]
select TbrName from tblKQRule where TbrCardNo='"+cardCode+"'" and datediff(d,data , getdate()) = 0
[/Quote]UP

[cecedeng]

"select TbrName from tblKQRule where TbrCardNo='"+cardCode+"' and datediff(d,data , getdate()) = 0 "
14# right