C#调用C++的DLL函
细说Sql Serve
这也得记上一笔, 学习70-431时, 在我本机上运行 CREATE PARTITION FUNCTION 命令总是出错, 报告 "Incorrect syntax near 'PARTITION'".
找了半天才发现原来这语句只能在SQL SERVER ENTERPRISE 版本上使用. 这里放个使用的例子:
- CREATE PARTITION FUNCTION emps_partition (int)
- AS RANGE LEFT
- FOR VALUES (1, 100, 1000)
- CREATE PARTITION SCHEME emps_partition_schema
- AS PARTITION emps_partition ALL TO ([PRIMARY])
- CREATE TABLE empid_partition (Empid int, name char(25))
- ON emps_partition_schema (empid)
再记一下如何查看SQL SERVER的版本, 只要在SQL查询中运行一句就可以:
SELECT @@version
就会有非常详细的信息了, 比如这个:
Microsoft SQL Server 2000 - 8.00.2039 (Intel X86) May 3 2005 23:18:38 Copyright (c) 1988-2003 Microsoft Corporation Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 4)
或者:
Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86) Oct 14 2005 00:33:37 Copyright (c) 1988-2005 Microsoft Corporation Developer Edition on Windows NT 5.1 (Build 2600: Service Pack 3)
服务器上的:
Microsoft SQL Server 2005 - 9.00.3282.00 (Intel X86) Aug 5 2008 01:01:05 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 2)
