Not quiet on the fly then :-P but the select * into b from a works :-) thanx
> -----Original Message----- > From: Daniel Field [mailto:[EMAIL PROTECTED]] > Sent: 12 September 2002 15:16 > To: ActiveServerPages > Subject: RE: Cloning Tables with SQL > > > If its a access DB then just open the DB and copy and paste the table. > > Dan > > -----Original Message----- > From: Andy Hayman [mailto:[EMAIL PROTECTED]] > Sent: Thursday, September 12, 2002 15:18 > To: ActiveServerPages > Subject: RE: Cloning Tables with SQL > > > At the mo it is Access, so I could use > > Create to create the table and set the structure > Then select into to fill it? > > Excellent > > Thanx > > > -----Original Message----- > > From: David L. Penton [mailto:[EMAIL PROTECTED]] > > Sent: 12 September 2002 14:49 > > To: ActiveServerPages > > Subject: RE: Cloning Tables with SQL > > > > > > With MSSQL, use DTS > > > > You can also do: > > > > SELECT * INTO newTable FROM oldTable > > > > in many RDBMSes > > > > You can also generate the CREATE table and INSERT > statements (using a > > language of your choice) > > > > David L. Penton, Microsoft MVP > > JCPenney Application Specialist / Lead > > "Mathematics is music for the mind, and Music is > Mathematics for the > > Soul. - J.S. Bach" [EMAIL PROTECTED] > > > > Do you have the VBScript Docs or SQL BOL installed? If > not, why not? > > VBScript Docs: http://www.davidpenton.com/vbscript > > SQL BOL: http://www.davidpenton.com/sqlbol > > > > > > -----Original Message----- > > From: Andy Hayman [mailto:[EMAIL PROTECTED]] > > > > Hey all > > > > Is it possible to "clone" or copy an existing table, > basicly I want to > > copy a table with its structure and data on the fly, I know I can > > INSERT a table then copy the data by reading it then > writing it but is > > there a copy or clone command? > > > > > > --- > > Andy Hayman > > Kensington Computers > > Internet & Computers Systems Consultant > > Web <http://www.ken.co.uk> > > Email <mailto:[EMAIL PROTECTED]> > > Telephone 020 7835 1282 > > Fax: 020 7373 6900 > > > > > > --- > > You are currently subscribed to activeserverpages as: > [EMAIL PROTECTED] > > To unsubscribe send a blank email to %%email.unsub%% > > > > --- > You are currently subscribed to activeserverpages as: > [EMAIL PROTECTED] > To unsubscribe send a blank email to > %%email.unsub%% > > _____________________________________________________________________ > This e-mail has been scanned for viruses by the WorldCom > Internet Managed > Scanning Service - powered by MessageLabs. For further > information visit > http://www.worldcom.com > > > > _____________________________________________________________________ > This e-mail has been scanned for viruses by the WorldCom > Internet Managed Scanning Service - powered by MessageLabs. > For further information visit http://www.worldcom.com > > --- > You are currently subscribed to activeserverpages as: [EMAIL PROTECTED] > To unsubscribe send a blank email to > %%email.unsub%% > --- You are currently subscribed to activeserverpages as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED]
