Re: Duplicate table



SELECT * INTO NewTable FROM OldTable


--
Andrew J. Kelly SQL MVP

"Omar Abid" <omar.abid2006@xxxxxxxxx> wrote in message
news:1181578846.356369.101240@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Hi,
In my program i need to duplicate a table in a current data base.
I'm thinkin' of reading the data base columns and then rows and so i
create another table
Is there any other easy and fast method with SQL Server 2005, because
my idea is so slow
I'm using VB 2005 Express with SQL Server 2005 Express
Thanks



.



Relevant Pages

  • Re: SQL Update: How do I get more error information
    ... The data base is a MS Access. ... // Record set for AccountJournalProject view ... // Write it back to the database - if it was changed ... , (SQL ...
    (microsoft.public.data.ado)
  • Delphi 7 and SQL/Sybase - tips?
    ... use) - but I am not familiar with SQL. ... I need to download data into a Sybase ... data base, and extract data from the same data base. ... I have a stringgrid or an array of array filled with ...
    (alt.comp.lang.borland-delphi)
  • Re: SQL Server 2005 with VB.net 2005
    ... What I want is to know the tables name of the current data base. ... Books Online for SQL Server 2005 athttp://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books ... ...
    (comp.databases.ms-sqlserver)
  • Re: SQL Server 2005 with VB.net 2005
    ... What I want is to know the tables name of the current data base. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (comp.databases.ms-sqlserver)
  • Re: [Full-disclosure] Solved -flaws in e-business designer (eBD)
    ... them to send querys against the data base with no need to use SQL ... SQL injection to obtain this, so we can not consider this as a security ... and seize control of the SQLManager tool you provided. ... "OK, since I know you have tools to create and manage requests for stuff, ...
    (Full-Disclosure)

Loading