Duplicate table

am 11.06.2007 18:16:19 von Omar Abid

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

Re: Duplicate table

am 11.06.2007 18:54:51 von Chris.CheneyXXNOSPAMXX

Omar Abid wrote in news:1181578579.728121.204320
@g4g2000hsf.googlegroups.com:

> 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
>
>

SELECT * INTO NewTable FROM OldTable

Re: Duplicate table

am 11.06.2007 22:09:53 von Omar Abid

On 11 juin, 18:54, "Chris.Cheney"
wrote:
> Omar Abid wrote in news:1181578579.728121.204320
> @g4g2000hsf.googlegroups.com:
>
> > 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
>
> SELECT * INTO NewTable FROM OldTable

Hi
Thx for your reply I'll try your code and submit the result to you
Omar Abid