Saturday, 22 June 2013

How To Get The Row Number In Insert Order Only (Dnt Change The Order Of Data In The Table ) As New Cloumn





CREATE TABLE [dbo].[Rownumber](
[Name] [varchar](50) NULL
) ON [PRIMARY]

GO

INSERT [dbo].[Rownumber] ([Name]) VALUES ('Gaurav')
GO
INSERT [dbo].[Rownumber] ([Name]) VALUES ('Sudeep')
GO
INSERT [dbo].[Rownumber] ([Name]) VALUES ('Kishor')
GO
INSERT [dbo].[Rownumber] ([Name]) VALUES ('Santosh')
GO



I DNT WANT ABOVE OUT PUT, I WANT BELOW OUT PUT.....LETS TRY THIS


This is the Query for this output:

SELECT  Name,
                 ROW_NUMBER() OVER(ORDER BY (SELECT 0)) AS InsertOrderRowNumber
FROM     Rownumber



No comments:

Post a Comment