Setting Identity to a Column of a Table in sql

Send Gifts

Daily Stars

Online Users

Show All

Tech Star

Weekly Toppers

Monthly Winners

Points

Top Earners

Daily Toppers

Inbox Compose

Utilities

Tech Games

Latest Discussions

Performance Analysis

by Hari Hara (Moderator) 0 replies.

ASP.NET page life cycle events

by kiran 1 replies.
XML in ASP.NET

by kiran 0 replies.
configuration files in SSIS..

by swapnika 1 replies.

configuration files in SSIS..

by swapnika 0 replies.

Last Points Earned

Tutorials

Tech Shatabdhi Radio

Birthday Techies

Techies Discussions

Re: How to read Cookies in Asp.Net ? - by - markspend1

Re: Play audio in HTML5 - by - markspend1

Re: Problem with updated panel - by - markspend1

Re: javascript - by - markspend1

Introduction - by - markspend1

Excellent Opportunity with CMC Ltd - by - csgajavelly

WPF Developers-3-8yrs-Vienna (Austria) - by - csgajavelly

Immediate Requirement for Dot net Professionals - by - csgajavelly

Opening of Dotnet Developer with Silverlight - by - csgajavelly

.Net Developer (Interview on 26th Jan, 2013) - by - csgajavelly

Opportunity for ".NET with Silverlight" @ TCS, Hyd - by - csgajavelly

Immediate opening for UI developers@Gurgaon/Noida - by - csgajavelly

Opening for .Net Developer with WPF_TCS_HYD_C2H - by - csgajavelly

Urgent Requirement for Dot Net-WCF WPF @ Accenture - by - csgajavelly

Urgent opening for Dotnet Developer with Artech - by - csgajavelly

C# with WCF OR WPF @ Hyderabad - by - csgajavelly

Dot Net,WPF,Silverlight,3.10 - 10 yrs, Bangalore - by - csgajavelly

Latest Updates

Interview Experiences module Added

Weekly toppers, star of the day modules added.

Added 100% compatibility to all mobile phones

Certificates and points sent to August Winners.

Win A Weekly Video Library Contest Started

Interview Experiences module Added

Weekly toppers, star of the day modules added.

Added 100% compatibility to all mobile phones

Certificates and points sent to August Winners.

Win A Weekly Video Library Contest Started

Interview Experiences module Added

Weekly toppers, star of the day modules added.

Added 100% compatibility to all mobile phones

Certificates and points sent to August Winners.

Win A Weekly Video Library Contest Started

Interview Experiences module Added

Weekly toppers, star of the day modules added.

Added 100% compatibility to all mobile phones

Certificates and points sent to August Winners.

Win A Weekly Video Library Contest Started

Interview Experiences module Added

Weekly toppers, star of the day modules added.

Added 100% compatibility to all mobile phones

Certificates and points sent to August Winners.

Win A Weekly Video Library Contest Started

Interview Experiences module Added

Weekly toppers, star of the day modules added.

Added 100% compatibility to all mobile phones

Certificates and points sent to August Winners.

Win A Weekly Video Library Contest Started

Interview Experiences module Added

Weekly toppers, star of the day modules added.

Added 100% compatibility to all mobile phones

Certificates and points sent to August Winners.

Win A Weekly Video Library Contest Started

Interview Experiences module Added

Weekly toppers, star of the day modules added.

Added 100% compatibility to all mobile phones

Certificates and points sent to August Winners.

Win A Weekly Video Library Contest Started

Interview Experiences module Added

Weekly toppers, star of the day modules added.

Added 100% compatibility to all mobile phones

Certificates and points sent to August Winners.

Win A Weekly Video Library Contest Started

Interview Experiences module Added

Weekly toppers, star of the day modules added.

Added 100% compatibility to all mobile phones

Certificates and points sent to August Winners.

Win A Weekly Video Library Contest Started

Interview Experiences module Added

Weekly toppers, star of the day modules added.

Added 100% compatibility to all mobile phones

Certificates and points sent to August Winners.

Win A Weekly Video Library Contest Started

Interview Experiences module Added

Weekly toppers, star of the day modules added.

Added 100% compatibility to all mobile phones

Certificates and points sent to August Winners.

Win A Weekly Video Library Contest Started

Interview Experiences module Added

Weekly toppers, star of the day modules added.

Added 100% compatibility to all mobile phones

Certificates and points sent to August Winners.

Win A Weekly Video Library Contest Started

Interview Experiences module Added

Weekly toppers, star of the day modules added.

Added 100% compatibility to all mobile phones

Certificates and points sent to August Winners.

Win A Weekly Video Library Contest Started

Interview Experiences module Added

Weekly toppers, star of the day modules added.

Added 100% compatibility to all mobile phones

Certificates and points sent to August Winners.

Win A Weekly Video Library Contest Started

Interview Experiences module Added

Weekly toppers, star of the day modules added.

Added 100% compatibility to all mobile phones

Certificates and points sent to August Winners.

Win A Weekly Video Library Contest Started

Welcome, Guest
Please Login or Register. Lost Password?

Hyderabad Techies Forum

SQL SERVER

Setting Identity to a Column of a Table in sql

(1 viewing) (1) Guest

Page: 1

TOPIC: Setting Identity to a Column of a Table in sql

Forum Tools

#12485

Setting Identity to a Column of a Table in sql 10 Months, 3 Weeks ago

Karma: 0

Hi friend,

I have a table Called Test which have 3 Column and already that table has some data.
Design of table is like this :

Fields datatype Allow null
------------------------------
ID int notnull
Name varchar null
Age int null

At the time of Creation of Table I forgot to set Identity to my ID column and I fill lot of data manually. Now I want to set Identity to my ID column. Can you please help me how to do that.

sharma.dhiraj87 (User)

Fresh Boarder

Posts: 14

Points: 17315

The administrator has disabled public write access.

#12486

Re:Setting Identity to a Column of a Table in sql 10 Months, 3 Weeks ago	Karma: -1
You can create one more new table with identity column set to ID and import old table.

kumar (User)

Gold Boarder

Posts: 262

Points: 189486

The administrator has disabled public write access.

#12487

Re:Setting Identity to a Column of a Table in sql 10 Months, 3 Weeks ago	Karma: 0
Thanks, For your reply. Can you please give a small example code for me, so that it will me more clear. Thanks

sharma.dhiraj87 (User)

Fresh Boarder

Posts: 14

Points: 17315

The administrator has disabled public write access.

#12518

Re:Setting Identity to a Column of a Table in sql 8 Months, 3 Weeks ago Karma: 0

Late reply

Code:



CREATE TABLE tbl (

ID INT not null,

Name VARCHAR null,

Age INT null

)

GO



INSERT INTO tbl 

SELECT 1 , 'A' , 25 UNION ALL

SELECT 2 ,'B' , 26 UNION ALL

select 3 , 'C' , 26

GO



select 'WITH OUT IDENTITY' FLAG, * from tbl 

GO



SELECT ID=IDENTITY(INT,1,1) , Name , Age 

INTO TBL1

From tbl 

GO



DROP TABLE tbl

GO



EXEC sp_rename 'TBL1' , 'tbl'

GO



SELECT 'WITH IDENTITY' FLAG,* FROM tbl 

GO