SELECT * FROM @USE U LEFT JOIN (SELECT * FROM SUBINVENTORY WHERE SUBWAREHOUSE=@SUBWAREHOUSE) S ON U.ITEMNUM=S.ITEMNUM
SELECT * FROM @USE U LEFT JOIN SUBINVENTORY S ON U.ITEMNUM=S.ITEMNUM WHERE SUBWAREHOUSE=@SUBWAREHOUSE
这两条语句一样吗?
不一样。
SELECT * FROM @USE U LEFT JOIN SUBINVENTORY S ON U.ITEMNUM=S.ITEMNUM WHERE SUBWAREHOUSE=@SUBWAREHOUSE
这两条语句一样吗?
不一样。
--查询重复记录
select * from cardnumber
where ID in
(
select ID from cardnumber group by ID having(count(*))>1
)
--查看未关闭的数据库游标
select *
from master..syscursors
where status <> -1
--去掉GETDATE()的秒
select convert(varchar(16),getdate(),120)
--取当前时间的前一天
select getdate()-1
select convert(char(10),getdate()-1,120)
select * from cardnumber
where ID in
(
select ID from cardnumber group by ID having(count(*))>1
)
--查看未关闭的数据库游标
select *
from master..syscursors
where status <> -1
--去掉GETDATE()的秒
select convert(varchar(16),getdate(),120)
--取当前时间的前一天
select getdate()-1
select convert(char(10),getdate()-1,120)