我正在努力在SQL查询向导中创建临时表。如何从临时表中选择一列(或多列)数据?
如果我尝试从临时表中选择一列,则会出现"列表索引越界 (1)"错误。如果我尝试从临时表中选择两列,我会得到一个"越界列出索引 (2)"
:::
SELECT Arfile.PATIENT_NO Patient_no,
Arfile.CHARGE_NO Charge_no,
Arfile.CHARGE_SEQ Charge_seq,
Arfile.ADJUST_TYPE Adjust_type,
Arfile.AMOUNT Amount,
Arfile.CHARGE_AMOUNT Charge_amount,
Arfile.PAYMENT_AMOUNT Payment_amount,
Arfile.ADJUSTMENT_AMOUNT Adjustment_amount,
Arfile.PAYMENT_TYPE Payment_type
INTO #testing1
FROM dbo.ARFILE Arfile
Select *
from #testing1
drop table #testing1
::::
SELECT Arfile.PATIENT_NO Patient_no,
Arfile.CHARGE_NO Charge_no,
Arfile.CHARGE_SEQ Charge_seq,
Arfile.ADJUST_TYPE Adjust_type,
Arfile.AMOUNT Amount,
Arfile.CHARGE_AMOUNT Charge_amount,
Arfile.PAYMENT_AMOUNT Payment_amount,
Arfile.ADJUSTMENT_AMOUNT Adjustment_amount,
Arfile.PAYMENT_TYPE Payment_type
INTO #testing1
FROM dbo.ARFILE Arfile
Select Patient_no
from #testing1
drop table #testing1
您使用的是哪种 DBMS?数据存储在SQL服务器中,我正在使用一个名为QS Reporter的SQL编译器。
确切的错误消息是什么?我之前在这篇文章中列出了确切的错误消息。
这个"SQL查询向导"是什么东西?QS记者。
::::此查询收到错误::::
SELECT Arfile.PATIENT_NO
INTO #testing1
FROM dbo.ARFILE
Select *
from #testing1
drop table #testing1
::::此查询收到错误"列表索引越界 (4)" :
:::::SELECT Arfile.PATIENT_NO Patient_no,
Arfile.CHARGE_NO Charge_no,
Arfile.CHARGE_SEQ Charge_seq,
Arfile.ADJUST_TYPE Adjust_type
INTO #testing1
FROM dbo.ARFILE Arfile
Select *
from #testing1
drop table #testing1
::::此查询有效::::
SELECT Arfile.PATIENT_NO Patient_no,
Arfile.CHARGE_NO Charge_no,
Arfile.CHARGE_SEQ Charge_seq,
Arfile.ADJUST_TYPE Adjust_type,
Arfile.AMOUNT Amount
INTO #testing1
FROM dbo.ARFILE Arfile
Select *
from #testing1
drop table #testing1
如果我
没记错的话,你必须像Arfile.PATIENT_NO AS Patient_no和所有其他东西一样使用"AS"。