SQL queries of a multiversion view do not return edits posted to the default version, unless the dbo.set_current_version stored procedure is executed first. By default, queries of multiversion views execute on the default version, so running the stored procedure to set the current version to Default should be unnecessary. This applies to SQL Server 2005 and 2008 using ArcSDE 9.3.1. It is not reproducible in ArcSDE 10.
最後に公開された状態: August 25, 2014ArcSDE/Enterprise Geodatabase
Run stored procedure prior to executing SQL queries. This is not optimal for the customer, who wants non-GIS users to be able to query the spatial table without running any other procedures.