View Single Post
  #15 (permalink)  
Old 10-29-09, 12:59
r937 r937 is offline
SQL Consultant
 
Join Date: Apr 2002
Location: Toronto, Canada
Posts: 19,524
Quote:
Originally Posted by BettingSherlock View Post
So i'll get much bigger files, can live with that.
you are embedding the data into SQL statements? sort of like steganography?

you're dead from the outset

the first step would be the CREATE TABLE statement

you will be unable to come up with one SQL statement that can run on all databases

well, you might be able to, but you'll be using a very small subset of the broad range of datatypes that various database systems support

take TINYINT, for instance... in ANSI SQL this would have to be SMALLINT because there is no TINYINT

TEXT would be very problematic, as the ANSI SQL equivalent is CHARACTER LARGE OBJECT, but not every database system supports that syntax

and so on...

distributing a CSV would seem like a far simpler strategy -- users who have databases will know how to load it, and users who don't have databases (e.g. they have excel) can also use it
__________________
r937.com | rudy.ca
please visit Simply SQL and buy my book
Reply With Quote