7 Answered Questions for the topic Sql Server

Sql Server Sql Sas Transactions

04/20/19

Do I need to call rollback if I never commit?
I am connecting to a SQL Server using no autocommit. If everything is successful, I call commit. Otherwise, I just exit. Do I need to explicitly call rollback, or will it be rolled back... more
Follows • 1
Expert Answers •1
Sql Server Geography Sql C#

04/12/19

Insert Geography data into SQL Server 2008?
Can someone guide me to or give me an example on how would one go about insert/query Geography data in Sql Server 2008 ( Polygon with 4 points and Point in specific) using C# EF or Linq2Sql. I've... more
Follows • 1
Expert Answers •1
Sql Server Geography Sql

04/11/19

Geometry datatype to latitude /Longitude MS SQL Server?
I need to convert Sql Server geometry datatype to latitude /Longitude I have just imported a shapefile to my table (geometry) This query does not work:- select geom.Lat as [Latitude], ... more
Follows • 1
Expert Answers •1
Sql Server Geometry Geography Gis

03/27/19

Several questions about using spatial data?
1. If you have spatial data for SQL server, can you use the spatial data (both geometry and geography) in another application for instance ESRI ArcGIS? 2. Is spatial data a standard that every GIS... more
Follows • 1
Expert Answers •1
Sql Server Geometry Geography Sql

03/18/19

Trying to convert geometry to geography keep failing in MSSQL 2012?
In MSSQL I have LineString in Geometry type. When I try to convert it to geography using : ... more
Follows • 1
Expert Answers •1
Sql Server Geometry Geography Sql

03/18/19

Needing to find parent zip code of a bunch of missing zip codes in the US?
We're using MapPoint to export zip code / territory combinations. Unfortunately, the export doesn't include PO Box zip codes which mean that we're missing a lot of zip codes The PO Box zip codes... more
Follows • 1
Expert Answers •1
Sql Server Linux

02/19/14

create a view in sql server reading from a linux server informix database using ODBC connection
how can i create a view in sql server reading from a linux server informix database. I'm using an ODBC connection
Follows • 2
Expert Answers •1

Still looking for help? Get the right answer, fast.

Ask a question for free

Get a free answer to a quick problem.
Most questions answered within 4 hours.

OR

Find an Online Tutor Now

Choose an expert and meet online. No packages or subscriptions, pay only for the time you need.