Skip to content

Instantly share code, notes, and snippets.

@fridim

fridim/ballarat.csv.sql

Created July 28, 2010 03:59
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save fridim/493330 to your computer and use it in GitHub Desktop.
Save fridim/493330 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
ballarat.csv.sql
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[ballarat]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[ballarat]
GO
CREATE TABLE [dbo].[ballarat] (
[id] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[streetname] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[suburb] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[postcode] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[precinct] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[honumber] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[specialinstructions] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[comments] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment