select * from table1 where datediff(dd,CAST(REPLACE(REPLACE(REPLACE(indate,'年','-' ),'月','-'),'日','') AS DATETIME),getdate())=0 这样怎么连接多个表 但表的结构有点不同是否可以只返回一个结果集
select * from table1 where datediff(dd,CAST(REPLACE(REPLACE(REPLACE(indate,'年','-' ),'月','-'),'日','') AS DATETIME),getdate())=0什么意思,连接多个表就是和原来一样啊,有什么关系么,表结构不同,但使列数相同的话就可以返回一个结果集了
select * from table1 where datediff(dd,CAST(REPLACE(REPLACE(REPLACE(indate,'年','-' ),'月','-'),'日','') AS DATETIME),getdate())=0
SELECT A,'' FROM A UNION ALL SELECT '',B FROM B 你提的问题本来就没说清楚
通过年月日来连接
用datepart或者datename不就行了
from table1
where
datediff(dd,CAST(REPLACE(REPLACE(REPLACE(indate,'年','-' ),'月','-'),'日','') AS DATETIME),getdate())=0什么意思,连接多个表就是和原来一样啊,有什么关系么,表结构不同,但使列数相同的话就可以返回一个结果集了
from table1
where
datediff(dd,CAST(REPLACE(REPLACE(REPLACE(indate,'年','-' ),'月','-'),'日','')
AS DATETIME),getdate())=0
UNION ALL
SELECT '',B FROM B
你提的问题本来就没说清楚