Sql server
fenglong2010
这个作者很懒,什么都没留下…
展开
-
case语句判断为空否
<br />select A.ID,<br />(case B.Name when B.Name then B.Name else C.Name end )as 'Name', <br />.....<br />from A<br />left join B on A.ID=B.ID <br />left join C on A.ID=C.ID <br />......<br />where ...<br />group by ...<br /> <br原创 2010-07-13 19:27:00 · 799 阅读 · 0 评论 -
select语句 创建自增列
<br />select row_number() over (order by Detail_ProductID) as ClnID ,<br />....<br />from ...<br />where ...<br /> <br /> <br />用row_number() over (列名) 可以创建自增列原创 2010-07-13 19:36:00 · 584 阅读 · 0 评论