随笔分类 -  mssql

mssql语句的执行时间
摘要：set statistics time onselect describe from h where k = 1 order by adate descselect describe from h where k = 1 order by adate descselect ID from h whe... 阅读全文
posted @ 2015-02-27 16:51 atlanticD 阅读(274) 评论(0) 推荐(0)
mssql联合查询
摘要：table1表结构(用户名,密码)useridusernamepassword1user1pwd12user2pwd2table2表结构(用户积分,等级)useridscorelevel12033506第一:内联(inner join)如果想把用户信息,积分,等级都列出来.那么一般会这样写selec... 阅读全文
posted @ 2014-12-14 09:45 atlanticD 阅读(619) 评论(0) 推荐(0)