DECLARE
@html
varchar
(
max
),
@sql
nvarchar
(
max
),
@tablename
varchar
(
200
)
SET @tablename = ' member '
SET @html = ' <table><tr> '
SET @sql = ' SET @html = '''' ; ' ;
SET @sql = @sql + ' SELECT TOP 10 @html = @html + '' <tr> '' , '
/* 表头 */
SELECT
@html = @html + ' <th> ' + c.name + ' </th> ' ,
@sql = @sql + ' @html = @html + '' <td> '' + CAST( ' + c.name + ' AS varchar) + '' </td> '' , '
FROM sys.columns AS c
INNER JOIN sys.types AS t ON c.system_type_id = t.system_type_id
WHERE EXISTS
(
SELECT * FROM sys.tables
WHERE name = @tablename
AND c. object_id = object_id
)
SET @sql = @sql + ' @html = @html + '' </tr> '''
SET @sql = @sql + ' FROM ' + @tablename + ' ; '
DECLARE @out varchar ( max )
exec sp_executesql @sql ,N ' @html varchar(max) output ' , @out output
SET @html = @html + @out
SET @html = @html + ' </tr> '
SET @html = @html + ' </table> '
SELECT @html
SET @tablename = ' member '
SET @html = ' <table><tr> '
SET @sql = ' SET @html = '''' ; ' ;
SET @sql = @sql + ' SELECT TOP 10 @html = @html + '' <tr> '' , '
/* 表头 */
SELECT
@html = @html + ' <th> ' + c.name + ' </th> ' ,
@sql = @sql + ' @html = @html + '' <td> '' + CAST( ' + c.name + ' AS varchar) + '' </td> '' , '
FROM sys.columns AS c
INNER JOIN sys.types AS t ON c.system_type_id = t.system_type_id
WHERE EXISTS
(
SELECT * FROM sys.tables
WHERE name = @tablename
AND c. object_id = object_id
)
SET @sql = @sql + ' @html = @html + '' </tr> '''
SET @sql = @sql + ' FROM ' + @tablename + ' ; '
DECLARE @out varchar ( max )
exec sp_executesql @sql ,N ' @html varchar(max) output ' , @out output
SET @html = @html + @out
SET @html = @html + ' </tr> '
SET @html = @html + ' </table> '
SELECT @html