两表查询结果合并
SELECT
x as name
FROM a
UNION
SELECT
x as name
FROM b
sql 生成uuid 去除 - ;
select replace(newid(),’-’,’’)
查询结果存放新表
insert into A
(replace(newid(),’-’,’’) as Id,UserCreate)
select Id,UserCreate from B where xxx
两表查询结果合并
SELECT
x as name
FROM a
UNION
SELECT
x as name
FROM b
sql 生成uuid 去除 - ;
select replace(newid(),’-’,’’)
查询结果存放新表
insert into A
(replace(newid(),’-’,’’) as Id,UserCreate)
select Id,UserCreate from B where xxx