Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Need new columns and random generating column

Author  Topic 

skumar
Starting Member

10 Posts

Posted - 2006-08-31 : 15:35:55
Hi,

i'm importing data from a txt file to Sql server table through a DTS package. the table is created dynamically.

i want three new cloumns added in the front and one of the columns should have a sequence number generation.

Please advice

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

7020 Posts

Posted - 2006-08-31 : 15:57:44
What are you asking for help with?



CODO ERGO SUM
Go to Top of Page

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2006-09-02 : 12:04:09
After creating the table, alter that table to create the columns you want

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page
   

- Advertisement -