473,320 Members | 1,707 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

How to load the generated column data into table?

while loading the PK COLUMN data into table I am getting the duplicate key in a table because of PK COLUMN having auto increment.
My requirement is what ever data having the ORIGINAL TABLE
that data i want to load into table..
Could please tell me the how to load the this type of data & which options i mentioned while loading?
Jan 3 '11 #1
0 1399

Sign in to post your reply or Sign up for a free account.

Similar topics

3
by: Jurgen Haan | last post by:
Hi Can I convert a plain integer column (non-key) in a table to a generated column using the ALTER TABLE .. ALTER COLUMN statement? If not, should I use the ALTOBJ statement? -R-
1
by: Kevin Myers | last post by:
Hello, I'm an experienced application developer in some languages (including various SQL dialects), but have very little experience with MS Access or VBA, and am having trouble figuring out how...
0
by: adjuster11 | last post by:
Bear with me, Noob question. I'm not a programmer, but a proprietary software program, Xactimate 24 property estimate, is forcing me to be one. I've tried multiple installs of their program on a new...
5
by: kma | last post by:
Dear All, I need to transfer data between two databases on two different SQL servers(both SQL server 2000). I have a script that selects data from three tables on server1 and organises into the...
0
by: blitzenn | last post by:
I am attempting to use triggers to add some simple auditing to my database structure (SQL Server 2005). I am running an ASP with this so I have many databases (dozens) with identical structure. My...
1
by: Manuel Jaen | last post by:
Hi everybody, I'm starting up with those generated columns of the DB2, but all the examples that I come up are simple, and as far as I've read the thing I want to do is not possible. Can someone...
1
by: Jal | last post by:
I want a generated column which will have the current date as well as a running number concatenated yyyymmddxxxxxx where xxxxxx is a running sequence. Can I use a SQL query to generate the...
3
by: hellboss | last post by:
Hi Everyone ! im using SQL SERVER 2005, My problem is, i am inserting a set of values into a table using a subquery, the problem occurs when i tried to get the auto generated column in the table...
2
by: brazil.mg.marcus.vinicius.lima | last post by:
Hi, I'm constructing a query that will performs a lot o datetime calculumns to generate columns. All that operations are dependent of a base calculum that is performed on the query and its...
1
by: gkinu | last post by:
Application-Generated Column Values in DataGridView on New Record I have a DataGridView which I am using to enter new records to a table with 5 columns/fields. However, values for two of the...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.