how to call marquees news from database ASP.NET C#

DECLARE @tempNews AS TABLE (ID INT IDENTITY(1,1), NewsDesc NVARCHAR(200), NewsUrl NVARCHAR(200))
INSERT INTO @tempNews (NewsDesc,NewsUrl) VALUES ('How Rahul Gandhi became Pappu of politics','https://in.news.yahoo.com/rahul-gandhi-became-apos-pappu-081800364.html')
INSERT INTO @tempNews (NewsDesc,NewsUrl) VALUES ('English bus driver praises Indian cricket professionalism','https://cricket.yahoo.net/news/english-bus-driver-praises-indian-113536193?isredir=true')
INSERT INTO @tempNews (NewsDesc,NewsUrl) VALUES ('40 Tips for Men Who Want To Lose Weight After 40','https://in.style.yahoo.com/40-tips-men-want-lose-160014489.html')
DECLARE @NewsDesc NVARCHAR(2000)
SELECT @NewsDesc = ''
SELECT @NewsDesc = @NewsDesc + ' + NewsUrl +'" target="_blank">'+ NewsDesc +''
FROM @tempNews ORDER BY ID ASC
SELECT @NewsDesc AS marqueeDesc

2 Replies

Know the answer? Post it — somebody with the same question will find it here.