[P] 如下一存储过程：[/P][P] CREATE PROCEDURE dbo.Net_ReadDwPower@newdwid int,
@newdwmc nvarchar(15) ,
@xd nvarchar(2),
@mydwmc nvarchar(15),
@mydwid int
as
set nocount on
begin
select czlb,tj,sp into #t from PowerAp where dwmc=@mydwmc and dwid=@mydwid and xd=@xd
select czlb,tj,sp into #p from PowerAp where dwmc=@newdwmc and dwid=@newdwid and xd=@xd
select #t.*,#p.tj as tj1,#p.sp as sp1 from #t left join #p on #t.czlb=#p.czlb[/P][P] truncate table #t
drop table #t
truncate table #p
drop table #p[/P][P] return
end
GO[/P][P] 不用SqlDateReader可读到类似如下数据：[/P][P] czlb tj sp tj1 sp1[/P][P] 转出 on on on null[/P][P] 转入 on on on null[/P][P] 可为什么用SqlDateReader就读不到tj1和sp1列的信息呢？明明其值是"on",读取的却是空。搞了一天也没有搞明白，哪位有见过的帮忙分析一下？（运行环境:vs2008(C#)+SQL2000）[/P][P] [/P][P] [/P] | 
