摘要:
WITH temp AS ( SELECT Month FROM dbo.test GROUP BY MONTH ) SELECT RIGHT(CONCAT( '00',MONTH) , 2) FROM temp 原理就是先拼出满长度的字符串在用right或者left函数切成指定需要的字符串 用加号 阅读全文
摘要:
Like 参数:string strSql = "select * from Person.Address where City like '%@add%'";SqlParameter[] Parameters=new SqlParameter[1];Parameters[0] = new SqlP 阅读全文