Skip to content

Instantly share code, notes, and snippets.

@petelopez
petelopez / gist:2650606
Created May 10, 2012 02:31
SQL Geolocation
/* Change ZipTest to whatever database you want to store the ZipCodes table in */
USE ZipTest
GO
IF EXISTS (SELECT *
FROM sysobjects
WHERE id = OBJECT_ID(N'ZipTempTable')
AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
BEGIN
DROP TABLE ZipCodesTemp;
END