Tech
Forums
Jobs
Books
Events
Videos
Conference
Annual Conference
Bcrypt
Ai Conference
Live
More
Interviews
Certification
Training
Career
Members
News
Blogs
Contribute
An Article
A Blog
A Video
An Ebook
An Interview Question
Register
Login
3
Answers
Add auto increment to newly added column which is null with
Ask a question
Ask a question
Upload Source Code:
Select only zip and rar file.
mohammed shamsheer
11y
1.3k
1
Reply
I have a table with 11 rows variable now i am need in id column and set as primary key and i want to number or auto increment the id column for 11 rows
eg :
id name address
null a b
null c d
.
.
11 records
i want ot output like that
id name address
1 a b
2 c d
.
.
.
11 z f
Post
Reset
Cancel
Answers (
3
)
Next Recommended Forum
Which query I use to fetch datetime column in SQL Server2000
how to use case in store proceedure?