- 博客(2)
- 资源 (4)
- 收藏
- 关注
原创 字符串时间类型 转换
<br />SELECT id_order ,<br /> s3_16<br />FROM ord<br />WHERE 1 = 1<br /> AND buessID = 1<br /> AND CONVERT(DATETIME, SUBSTRING(id_order, 0, 11)) > CONVERT(DATETIME, SUBSTRING('2010-8-31',<br />
2010-09-02 16:42:00 279
原创 sql With ROW_NUMBER() 使用 生成查询行号
<br /> WITH a1 AS (SELECT * ,ROW_NUMBER() OVER (ORDER BY CLIENT_ID DESC,CNAME DESC ) AS a2<br /> FROM client)<br /> SELECT * FROM a1
2010-09-02 11:05:00 542
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人