CREATE TABLE A ( NAME VARCHAR(5) ,PAY INT ); INSERT INTO A(NAME, PAY) VALUES...
select * into #A from (values ('1','2022','1') ,('2','2022','2') ,('3','2022','...
寫入資料 CREATE TABLE #TBL1 ( NAME NVARCHAR(10), NO NVARCHAR(10), AREA NVARCHAR(10),...
寫入原始資料表HISPAY的SQL CREATE TABLE [HISPAY]( [EMPNO] nvarchar(5), [SUBJECTNAME] nvar...