SELECT * INTO #A FROM ( VALUES ('001',N'王小明') ,('002',N'張小花') ,('003',N'李...
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...
may031556的鐵人檔案