how to generate row no in sql server

Question

0.00/5 (No votes)

See more:

SQL-Server-2005

iam dynamically accessing tables from database now want to get row no with the datatable value
how can i use Row_number() function with the query
Select * from mytable

Posted 31-Jan-14 21:40pm

srilekhamenon

Add a Solution

3 solutions

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Snehasish_Nandy · Answer 1 · 2014-01-31T21:42:00

Solution 1

You can refer the below link

how-do-i-use-row-number[^]

Posted 31-Jan-14 21:42pm

Snehasish_Nandy

Comments

srilekhamenon 3-Feb-14 0:23am

Sir iam dynamically accessing the tables so i have query like Select * from table1, select * from table2 so i can not specify the column name to generate Row_number() now how can i generate Row_Number()

[no name] 3-Feb-14 0:30am

You can check this once
http://stackoverflow.com/questions/1646657/adding-row-numbers-to-a-select-query-result-in-sql-server-without-use-row-number

Abhinav S · Answer 2 · 2014-01-31T21:44:00

Solution 2

Try

SQL

SELECT ROW_NUMBER()
        OVER (ORDER BY a) AS Row,
    EmployeeId, EmployeeName, Salary
FROM Employees

Posted 31-Jan-14 21:44pm

Abhinav S

Comments

srilekhamenon 3-Feb-14 0:22am

Sir iam dynamically accessing the tables so i have query like Select * from table1, select * from table2 so i can not specify the column name to generate Row_number() now how can i generate Row_Number()

Sandeep Singh Shekhawat · Answer 3 · 2014-01-31T21:59:00

Solution 3

SQL

CREATE TABLE #Temp
(
Id int Identity(1,1),
Name nvarchar(100)
)

INSERT INTO #Temp(Name) VALUES('SANDEEP'),('RAVIENDER')

SELECT Name, ROW_NUMBER() OVER(ORDER BY Name) AS ROW From #Temp

DROP TABLE #Temp

Posted 31-Jan-14 21:59pm

Sandeep Singh Shekhawat

how to generate row no in sql server

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0

how to generate row no in sql server

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0

Existing Members

...or Join us