![](https://img-blog.csdnimg.cn/20201014180756918.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
SQLSERVER
hello world**
shdkahdklasdlajsdkld
展开
-
convert(varchar(10),字段名,转换格式) convert 方法的使用
convert(varchar(10),字段名,转换格式)CONVERT(nvarchar(10),count_time,121) 常用 112 :例如:20180612SELECT product_name,create_time FROM tb_product AS pro WHERE CONVERT(VARCHAR(8),pro.create_time,112)='20...转载 2018-06-27 11:02:20 · 18430 阅读 · 0 评论 -
SQLserver 查询分页,多表连结查询
SELECT * FROM(SELECT row_number() OVER( ORDER BY a.price ASC )AS rowNum, COUNT(1) OVER() AS totalElements ,a.*FROM vProductSKU AS a WHERE a.sku_name LIKE '%名%' )AS tb WHERE rownum BETWEEN 1 AN...原创 2018-09-18 16:20:26 · 1543 阅读 · 0 评论