Name Mobile 1 Sachin 8010023456 2 Kamal 9935463456
Name Mobile 1 Blank Blank 2 Sachin 8010023456 3 Kamal 9935463456
SELECT NULL AS [Name], NULL AS [Mobile] UNION ALL SELECT [Name], [Mobile] FROM TableName
select ROW_NUMBER()over(order by name), name,phone from ( select '' as name,'' as phone union all select name,phone from @t ) p
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)