2019年11月2日
DATEADD (Transact-SQL)
摘要： DATEADD (Transact-SQL) This function adds a specified number value (as a signed integer) to a specified datepart of an input date value, and then retu 阅读全文
posted @ 2019-11-02 14:55 ChuckLu 阅读(188) 评论(0) 推荐(0)
how does SELECT TOP works when no order by is specified?
摘要： how does SELECT TOP works when no order by is specified? There is no guarantee which two rows you get. It will just be the first two retrieved from th 阅读全文
posted @ 2019-11-02 11:11 ChuckLu 阅读(158) 评论(0) 推荐(0)
把业务逻辑写在存储过程中有哪些缺点和优点？
摘要： https://segmentfault.com/q/1010000000251484 我的观点：这么设计的目的并不能方便随时修改业务逻辑，只是方便熟悉存储过程的开发人员，能够随时修改业务逻辑。对于后续的业务逻辑越趋于复杂，修改就越困难，存储过程中的重复代码就越多；重复代码越多，系统的坏味道就越散发 阅读全文
posted @ 2019-11-02 10:10 ChuckLu 阅读(1713) 评论(0) 推荐(0)