Click here to Skip to main content
15,912,977 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
i am using new installed sql server 2008

i am trying to copy data from one table to another..i wrote query like this;

insert into Clr select * from Color_tbl
but this is showing error like this:

Invalid object name 'Clr'.

what i have to do? i have change any setting?

I used to copy data from one table to another table like this: but i dont know what happend after installing new Sql server??

any help is very appriciable
Posted
Updated 14-May-14 20:27pm
v2

Not how it works.
We do not do your work for you: if you want that you have to pay. I suggest you go to vWorker.com and ask there.
But be aware that you get what you pay for: pay peanuts, get monkeys.
 
Share this answer
 
please varify that 'Clr' table exists in your database.
 
Share this answer
 

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



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900