Script

Last Post 25 Apr 2002 06:00 AM by satya. 1 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
LACBA_SQL
New Member
New Member

--
24 Apr 2002 04:40 PM
how do i add a new field and insert a value into it?

I'm importing data from another table into a new one, but my source table has a char field and the target filed is (int) can I add a new field to the source file and add a value to it? and how?
I have in my source table a field call companyName that contains text and the target table has a companyId which is an INT.
If I create a field call companyId and add a value of '1'
How can I do that? I have to do this for 100 or more tables. Can I write a script that will do that for me?
does it make sence?
satya
New Member
New Member

--
25 Apr 2002 06:00 AM
The best option would be to use DTS and transform as per your requirement. Refer to BOOKS ONLINE for more information.
You are not authorized to post a reply.

Acceptable Use Policy