易截截图软件、单文件、免安装、纯绿色、仅160KB

SQL Server 2008 Spatial, PostgreSQL/PostGIS 1.3

General Overview
FeatureSQL Server 2008 (RC0)MySQL 5.1/6PostgreSQL 8.3/PostGIS 1.3/1.4
OS
Windows XP, Windows Vista, Windows 2003, Windows 2008
Windows XP, Windows Vista, (haven't tested on 2008), Linux, Unix, Mac
Windows 2000+ (including Vista and 2003, haven't tested on 2008), Linux, Unix, Mac
Licensing
Commercial - Closed Source, Various levels of features based on version, Express version has full spatial support but limitation on database size and only use one processor.
Commercial Open Source (COSS), some parts GPL. Here is an interesting blog entry on the subject MySQL free software but not Open Source. The comments are actually much more informative than the article itself.
FLOSS (PostgreSQL is BSD, PostGIS is GPL Open Source - you can use for commercial apps but if you make changes to the core libraries of PostGIS, you need to give that back to the community)
Free GIS Data Loaders
shp dataloader for SQL Server 2008 developed by Morten Nielsen (doesn't yet work with RC0)
OGR2OGR, shp2mysql.pl script
included shp2pgsql, OGR2OGR, QuantumGIS SPIT, SHP loader for PostGIS also developed by Morten using SharpMap.NET various others
Commercial GIS Data Loaders
Manifold, Safe FME Objects, ESRI ArcGIS 9.3 (in a later service pack)
Safe FME Objects
Manifold, FME Objects, ESRI ArcGIS 9.3
Application drivers available specifically for spatial component
? Not yet - SharpMap.NET eventually and probably built into new ADO.NET 3.5+
GDAL C++, SharpMap via OGR, AutoCAD FDO
SharpMap.Net, JDBC postgis.jar included with postgis, JTS etc. tons for Java, GDAL C++, AutoCad FDO beta support
Free Object/Relational Mapping
NHibernateSpatial (this is a .NET object relational spatial mapper) - beta support
Hibernate Spatial - this is a java object relational mapper
NHibernateSpatial and HibernateSpatial
Free Desktop Viewers and Editors
Will be built into SQL Manager, but not available in RC0 and only useful for viewing
GvSig
OpenJump, QuantumGIS, GvSig, uDig


相关文档:

SQL Substring

 SQL 中的 substring 函数是用来抓出一个栏位资料中的其中一部分。这个函数的名称在不同的资料库中不完全一样:
MySQL: SUBSTR(), SUBSTRING()
Oracle: SUBSTR()
SQL Server: SUBSTRING()
最常用到的方式如下 (在这里我们用SUBSTR()为例):
SUBSTR(str,pos): 由<str>中,选出所有从第<pos>位置开始 ......

用SQL删除重复记录的N种方法

用SQL删除重复记录的N种方法
2009-06-03 17:35
例如:
id           name         value
1               a     &nbs ......

SQL 左外连接,右外连接,全连接,内连接

 联接条件可在   from   或   WHERE   子句中指定,建议在   from   子句中指定联接条件。WHERE   和   HAVING   子句也可以包含搜索条件,以进一步筛选联接条件所选的行。   
   
联接可分为以下几类:      ......

SQL Server 2000的JDBC连接问题解决方法

 经过好几天的奋战,JDBC终于成功连接了SQL Server 2000,期间走了不少弯路,在这里分享我的一点经验
一、我的环境
   Windows XP+JDK6u15+Microsoft SQL Server 2000(SP4)+JCreator
   我先在网上下载数据库驱动程序,目录下有三个包msbase.jar mssqlserver.jar msutil.jar
   1 ......

使用Oracle的DBMS_SQL包执行动态SQL语句

 在某些场合下,存储过程或触发器里的SQL语句需要动态生成。Oracle的DBMS_SQL包可以用来执行动态SQL语句。本文通过一个简单的例子来展示如何利用DBMS_SQL包执行动态SQL语句:
DECLARE
       v_cursor NUMBER;
       v_stat NUMBER;
  & ......
© 2009 ej38.com All Rights Reserved. 关于E健网联系我们 | 站点地图 | 赣ICP备09004571号