[导入]如何在查询结果中添加一列表示记录的行数?
如何在查询结果中添加一列表示记录的行数?
要求是增加一列显示行数
DECLARE @table TABLE ([Values] varchar(10)) Insert INTO @table Select 'AAA' UNION ALL Select 'CCC' UNION ALL Select 'EEE' UNION ALL Select 'DDD' UNION ALL Select 'BBB' Select [RowID] = IDENTITY (int, 1, 1), * INTO # FROM @table Select * FROM # Drop TABLE #
文章来源:http://Jorkin.Reallydo.Com/default.asp?id=422