我正在尝试从一个选择语句中向表中插入数据,并像下面这样添加额外的参数到行中:
SELECT
Appt_ID,
Pracitioner_ID,
Appt_Book_ID,
Start_Time,
UR_NO,
[Type],
[Description]
FROM @TempWaiting,
@EndTime,
@PatientID,
@Title,
@FirstName,
@LastName,
@Surname,
@DOB
INTO PS_WAITING_LIST(Appt_ID,
Pracitioner_ID,
Appt_Book_ID,
Start_Time,
UR_NO,
[Type],
[Description],
End_Time,
Patient_ID,
Title,
First_Name,
Middle_Name,
Surname,
DOB)
这段代码在存储过程中,执行后只显示INTO之后的错误信息。
我也尝试将其重写为 -
insert into PS_WAITING_LIST (
Appt_ID,
Pracitioner_ID,
Appt_Book_ID,
Start_Time,
UR_NO,
[Type],
[Description],
End_Time,
Patient_ID,
Title,
First_Name,
Middle_Name,
Surname,
DOB)
SELECT
Appt_ID,
Pracitioner_ID,
Appt_Book_ID,
Start_Time,
UR_NO,
[Type],
[Description]
FROM @TempWaiting,
@EndTime,
@PatientID,
@Title,
@FirstName,
@LastName,
@Surname,
@DOB
这会引发一个错误,提示选择值的数量必须与插入列的数量相匹配。显然事实并非如此。
我还尝试了Insert into table (col1, col2..) Select * from (select (...), col3, col9)