Here, What I am trying to do is to display the data in
BOLD
name
backend
salary
conversion functions
CREATE TABLE #test(name VARCHAR(50), salary FLOAT)
INSERT INTO #test VALUES
('a', 1000),
('b', 5000)
DECLARE @sql VARCHAR(8000)
SET @sql = 'SELECT
''<b>'' + name + ''</b>'',
''<b>'' + salary + ''</b>''
FROM #test'
EXEC(@sql)
CREATE TABLE #test(name VARCHAR(50), salary INT)
INSERT INTO #test VALUES
('a', 1000),
('b', 5000)
DECLARE @sql VARCHAR(8000)
SET @sql = 'SELECT
''<b>'' + name + ''<b>'',
''<b>'' + CAST(salary AS VARCHAR(20)) + ''<b>''
FROM #test'
EXEC(@sql)