Sr No display in Query

SELECT rank () over (order by <Column1>) as Sr_No,
Column1
FROM <TableName>

Use XML Path In SQL Server

SELECT  SUBSTRING(( SELECT DISTINCT ( ',' + Email )
                    FROM    TableName
                  FOR
                    XML PATH('')
                  ), 3, 1000) AS EmailList

Insert Data from TextFile to table

BULK INSERT dbo.User_MST
FROM 'c:\TestCSV.txt'
WITH
(
FIELDTERMINATOR =',',
ROWTERMINATOR='\n'
)
SELECT * FROM dbo.User_MST