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
Jitendra Patel
NA
149
0
Auto increment Number in SQL Server 2000?
Sep 3 2011 1:17 PM
Hello,
I have one query and it's out put is like this.
My database in SQL Server -2000 .
Select Name from table_name
Out Put
========
Name
======
Test1
Test2
Test3
Test4
But I want this types of out put.
Out Put
========
ID Name
=========
1 Test1
2 Test2
3 Test3
4 Test4
Reply
Answers (
6
)
How split row into multiple rows using sqlserver?
Can i pass more than two column names to split function?