摘要:
public List<GoodsConsumerRankModel> GetGoodsConsumerRankingsModelList(DateTime start, DateTime end) { List<GoodsConsumerRankModel> list = new List<Goo 阅读全文
摘要:
1 select ycsp.v_dd_no,dd.v_pai_no,ycsp.v_czzl_no,ycsp.v_czzl_name, 2 case when ycsp.i_goods_type=0 then '普通品项' 3 when ycsp.i_goods_type=1 then '套菜' 4 阅读全文
摘要:
2018.10.16:周二 --进阶 --别名 SELECT StuName,StuNum+','+StuClass+','+StuGender+','+StuPhone AS 信息 FROM Student; --删除主键约束 ALTER TABLE Student DROP CONSTRAINT 阅读全文
摘要:
2018.10.15:周一 -- 返回前5个数据 SELECT TOP 5 * FROM Student; -- 返回前50%的数据 SELECT TOP 50 PERCENT * FROM Student; -- 以"C"或"P"开头 SELECT * FROM Student WHERE Sub 阅读全文