在查询结果中添加一列表示记录的行数的sql语句
复制代码 代码如下: DECLARE@tableTABLE([Values]varchar(10)) InsertINTO@tableSelect'AAA' UNIONALLSelect'CCC' UNIONALLSelect'EEE' UNIONALLSelect'DDD' UNIONALLSelect'BBB' Select[RowID]=IDENTITY(int,1,1),INTO#FROM@table SelectFROM# Dro
复制代码 代码如下: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 #
