sql中查出数据后加一行

select   0   as  PlatformID, ' 官网 '   as  Name, cast ( null   as   bigint )  as  ParentID  union   select  PlatformID,Name, cast ( null   as   bigint )  as  ParentID  from  TB_Platform   where  IsDelete != 1   and  Status != 0

可以用这种方式来在数据表中加一行

http://203.208.37.104/search?q=cache:rSaB-ZOpmhEJ:sql.1keydata.com/cn/sql-union.php+sql+union&hl=zh-CN&ct=clnk&cd=1&gl=cn&st_usg=ALhdy28oEEpvdez2nuAoG4euh1KFKNwmDw

主要用于把多个SQL的结果组合起来

转载于:https://www.cnblogs.com/lishenglyx/archive/2009/02/03/1382934.html