1.标准日期格式化yyyy-MM-dd
SELECT CONVERT(NVARCHAR(10),CAST(<datetime> AS DATETIME),120)
2.TABLESAMPLE样本行
select * from tbl_student tablesample system (20 percent);
1.标准日期格式化yyyy-MM-dd
SELECT CONVERT(NVARCHAR(10),CAST(<datetime> AS DATETIME),120)
2.TABLESAMPLE样本行
select * from tbl_student tablesample system (20 percent);