zxcvb12zxcvb12的博客

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...

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...