Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

Baseball Statistics Expand / Collapse
Author
Message
Posted Monday, June 23, 2014 3:53 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, June 24, 2014 8:08 AM
Points: 2, Visits: 1
I have been trying to download Lahman's database to my home SQL Server Express 2008 (we use 2008 at work), but no joy so far. Lahman's .SQL file seems set up for a different database - it has double quotes and uses ` instead of ' for literals so syntax errors. Editing the 50+ MB file seems to take forever, so that's not a good option either (my home machine might make a better boat anchor than computer). Any suggestions (other than SQL Server 2012 and a new machine) or success stories? Thanks.
Post #1585361
Posted Tuesday, June 24, 2014 6:35 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Today @ 7:58 AM
Points: 322, Visits: 1,009
bob.bell 82064 (6/23/2014)
I have been trying to download Lahman's database to my home SQL Server Express 2008 (we use 2008 at work), but no joy so far. Lahman's .SQL file seems set up for a different database - it has double quotes and uses ` instead of ' for literals so syntax errors. Editing the 50+ MB file seems to take forever, so that's not a good option either (my home machine might make a better boat anchor than computer). Any suggestions (other than SQL Server 2012 and a new machine) or success stories? Thanks.

David stated it was not SQL Server.
Post #1585487
Posted Tuesday, June 24, 2014 8:10 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, June 24, 2014 8:08 AM
Points: 2, Visits: 1
Thank you. Any tips on loading an Access file or .csv into SQL Server? Or would I be better off trying to edit the Lahman file to bring it into line?
Post #1585527
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse