Insert Data with Identity Column

To Insert data in identity column

set identity_insert table_name on
insert......
set identity_insert table_name off

How to alter a normal column into Identity column?

This really created a problem and I solved in the following fashion.

Just change the previous table as a different name and then create a new table with the name of the former table. But be careful that if the previous table has some PK-FK relationship , you have to use the Alter Table query to change the relationship

ALTER TABLE [dbo].[ITradeOrderItems] DROP CONSTRAINT
[FK__NAME]

Paul the Oracle Octopus

      In India, usually it has been observed that people keep their faith on supernatural entities and they believe in some form of powers which are inexplicable in terms of Science. It has often been told that people of western country don't believe these kind of things and they are often termed as these cultures are the byproduct of this part of the world and not the byproduct of western culture.
     But by giving importance to a octopus whom they termed as Oracle Octopus Paul , simply doesn't advertise their claim. The octopus was oracle as long as it was giving the favorable outcome for Germany i.e. Paul predicted Germany would win against Argentina and Paul was dear to Germans and for the reverse case even some of the German fan wanted to have a feast with Paul. Its more than sarcastic. Its really funny to see Spanish President wanted to give Paul a protection.
     To see all those, its tough to digest that we are living in a world of nanotechnology rather it confirms that quantum theory and quackery will go by hand in hand.