Results 1 to 3 of 3
  1. #1
    Gold Lounger
    Join Date
    Jan 2004
    Location
    Italy
    Posts
    3,245
    Thanks
    0
    Thanked 0 Times in 0 Posts

    copy dbase from the same server sql express (2000 and vb 6.0)

    I use a free sql express to store my database, and use vb 6.0 for connection.
    I dont know if is possible:
    Copy from the database (for example DB_PAST_DUE) the table SPORTELLI (with column, data, setting filed..) and past in the same database with new name SPORTELLI_1... is possible via Sql Command in Sql Express Management studio Express or directlly from a Vb code, admit i just have a connection opened?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: copy dbase from the same server sql express (2000 and vb 6.0)

    You could use the SQL string

    SELECT * INTO SPORTELLI_1 FROM SPORTELLI

    This will create a new table SPORTELLI_1 and copy all records from SPORTELLI into it.
    It will not copy any indexes or triggers into the new table.

  3. #3
    Gold Lounger
    Join Date
    Jan 2004
    Location
    Italy
    Posts
    3,245
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: copy dbase from the same server sql express (2000 and vb 6.0)

    TKS... work fine naturally!

Posting Permissions

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