Results 1 to 4 of 4
  1. #1
    Join Date
    Apr 2007
    Posts
    20

    Unanswered: Struggling importing .sql table

    I have two tables I need to create in msSQL and I have the .sql files with the information in them, is it possible to insert them through enterprise manager?
    Or another way? Or are they meant for mySQL?

    cheers

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    could you please show a few lines of the .sql file?

    that will tell us which database the file is meant for
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    Apr 2007
    Posts
    20
    Code:
    USE [database1]
    GO
    /****** Object:  Table [dbo].[TBL_ACCOUNT]    Script Date: 6/14/2006 02:26:35 ******/
    SET ANSI_NULLS ON
    GO
    SET QUOTED_IDENTIFIER ON
    GO
    SET ANSI_PADDING ON
    GO
    CREATE TABLE [dbo].[TBL_ACCOUNT](
    	[FLD_LOGIN] [char](10) COLLATE Latin1_General_CI_AS NOT NULL,
    	[FLD_PASSWORD] [char](10) COLLATE Latin1_General_CI_AS NOT NULL,
    Cheers
    Last edited by Paul.; 04-03-07 at 12:43.

  4. #4
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    this .sql file is intended for microsoft sql server

    just open the file in Query Analyzer (or your front end app du jour) and run it
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •