HJXia

在SqlServer中区分参数大小写的做法。 eg: select * from users where loginId=#loginId# collate Chinese_PRC_CS_AS_WS.

SQLServer: select * from ( select top @pageSize * from ( select top (@pageSize*@currentPage) * from page order by _id asc )t1 order by _id desc )t2 order by _id asc

Sql Server中的datetime类型不包括"dd/MM/yyyy"这种格式．

在查询分析器中输入以下内容： [size=large][color=red]set statistics profile on set statistics io on set statistics time on go 　　 go set statistics profile off set statistics io off set statistics time off...