insert into table with primary key

Question

0.00/5 (No votes)

See more:

SQL-Server-2005

hi I have a table that I fill some fields of that,befor
BUT now I want fill another fields of that table with primary key

what do I do?

thanks

Posted 21-Jul-12 8:53am

veusk

Add a Solution

Comments

woutercx 21-Jul-12 15:01pm

I read your question, but it confuses me, I don't exactly understand what your problem is... Maybe you can clarify?
- Do you want to copy the primary key of the row in the same row to another column? I don't see why you would want to do that..
- Do you want to copy the primary key of the row into another table?

veusk 21-Jul-12 15:12pm

no.I want fill empty fields from records that before inserted some fields of them.
now I want fill empty fields by primary key

Member 7434378 21-Jul-12 15:13pm

Or do you want to update a row with a primary key?

woutercx 21-Jul-12 15:16pm

Maybe it will get clearer if you explain why you want to fill another field of that table with the primary key; what is your primary goal?

woutercx 21-Jul-12 15:17pm

Or do you mean something with "default values"?

veusk 21-Jul-12 15:21pm

I have a table that has 10 feilds like id (is PK) , name,family, tell
befor I fill id ,name and family
NOW
I want insert tell to related record,
what do I do?

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Member 7434378 · Accepted Answer · 2012-07-21T09:32:00

Solution 1

Try this.
UPDATE "your table name" SET
"Table field" = "what you want to add
WHERE ["The product key field"] = "The product key"

e.g

UPDATE tblProduct SET
[Product Name] = 'Shoe box'
WHERE [Product ID] = 1

Say you set the Product ID as the product key, and the Product ID is 1 you have to specify "where Product ID = the product key".

Posted 21-Jul-12 9:32am

Member 7434378

Comments

veusk 21-Jul-12 15:37pm

thank you very much