文章分类 -  SQL Server

摘要：SQL Server分页查询是我们经常会用到的功能，下面就为你介绍SQL Server分页查询的相关语句，希望对您学习SQL Server分页查询方面能有所帮助。1. SQL Server2000SELECT TOP @pagesize * FROM TABLE_NAME WHERE id not in ( SELECT TOP @pagesize*(@page-1) id FROM TABLE_NAME ORDER BY id ) ORDER BY id 2. SQL Server 2005SQL Server分页查询方法一：SELECT ... FROM ... 阅读全文

摘要：序号类别SQLC#备注1整数bitBooleanTrue转换为1，False转换为02tinyintByteC#数据类型都位于System命名空间3smallintInt164intInt325bigintInt646smallmoneydecimal7moneydecimal8numericdecimal9decimaldecimal10浮点数floatdouble11realsingle12日期和时间smalldatetimedatetime13datetimedatetime14timestampdatetime15字符串charstring16textstring17varcharst 阅读全文