SQL连接字符串
摘要：两种连接字符串@"Data Source=192.168.0.106\ARROWSQLSERVER;Initial Catalog=SIG;Integrated Security=True";@"Data Source=192.168.0.106\ARROWSQLSERVER;Initial Catalog=SIG;User ID=sa;Password=19820202";Connection Timeout=30，默认值为15秒使用SqlCommand查询SqlConnection con = new SqlConnection(ConStr);Sq
阅读全文
posted @
2013-12-20 22:58
Arrow.Lu
编辑
【技巧】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 ...
阅读全文
posted @
2012-05-23 19:54
Arrow.Lu
编辑
[转载]Microsoft SQL Server 2005 数据类型
摘要：序号类别SQLC#备注1整数bitBooleanTrue转换为1，False转换为02tinyintByteC#数据类型都位于System命名空间3smallintInt164intInt325bigintInt646smallmoneydecimal7moneydecimal8numericdecimal9decimaldecimal10浮点数floatdouble11realsingle12日期和时间smalldatetimedatetime13datetimedatetime14timestampdatetime15字符串charstring16textstring17varcharst
阅读全文
posted @
2012-01-21 14:42
Arrow.Lu
阅读(136)
推荐(0) 编辑
