TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
mohammed shamsheer
NA
394
144.4k
Add auto increment to newly added column which is null with
Jul 26 2013 2:17 AM
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
Reply
Answers (
3
)
Which query I use to fetch datetime column in SQL Server2000
how to use case in store proceedure?