数据库中ROWCOUNT_BIG()的用法

  INSERT @TImmobility SELECT ImmobilityId,ImmobilityName,ImmobilityType, EditDate FROM Immobility.Bases
   WHERE ExpiredDate>=GETDATE() and QualifyType>=@QualifyType and CityId like @UserCity+'%'
  SET @COUNT = @COUNT + ROWCOUNT_BIG()

返回上一次操作的行数！放回的是插入上个表中的行数。

转载于:https://www.cnblogs.com/Minghao_HU/archive/2012/03/21/2410215.html