如何将表A中的mod表达式返回值插入表B

Question

select all into result1 from (select mod(employee_id,2) as res from emp

Answer 1

这就是您想要的吗？

SELECT 
*,
res = e.employee_id % 2
INTO #dual
FROM
dbo.emp e;

Answer 2

试试这个：

INSERT INTO @dual (res )
select employee_i % 2 as res FROM emp

Answer 3

SELECT A.* INTO dual FROM (SELECT (col % 2) AS resp FROM tbl) A 

请注意，MOD在TSQL中是而不是。