We have following select result records.
And my desired output should be:
T-SQL
DECLARE @Table Table
(SQLForum VARCHAR(100))
INSERT INTO @Table
SELECT 'MSDN' UNION ALL
SELECT 'StackOverFlow' UNION ALL
SELECT 'SQLServerCentral' UNION ALL
SELECT 'SQLTeam'
SELECT ROW_NUMBER()OVER(ORDER BY(SELECT 1))AS 'SRNo',* FROM @Table
That’s It.
Enjoy Learning.
No comments:
Post a Comment