一个有关sql语句的问题,在线等待

[antimicrosoft]

declare @dt_Time datetime

select @dt_Time = TBL_CodeSNum.dt_GetTime
from TBL_CodeSNum
where TBL_CodeSNum.vc_TableName='TBL_Xyz'

我想同时把在TBL_CodeSNum表中的n_CodeSNum列也同时select出来,sql语句该如何编写呀?

[pengdali]

declare @dt_Time datetime

select @dt_Time = TBL_CodeSNum.dt_GetTime
from TBL_CodeSNum
where TBL_CodeSNum.vc_TableName='TBL_Xyz'

select @dt_Time 时间

在delphi或其他语言或查询分析器中java: rs.execquery();delphi: query.open; .......
就OK了

[antimicrosoft]

????

[pengdali]

你同时select出来肯定不行
你的前台语言？？？？

select @dt_Time = TBL_CodeSNum.dt_GetTime
from TBL_CodeSNum
where TBL_CodeSNum.vc_TableName='TBL_Xyz';select @dt_Time 时间
----------------------------------------^^^在delphi query中要加;

[cxmcxm]

是什么需求?
是否
declare @dt_Time datetime,@n_CodeSNum int

select @dt_Time = TBL_CodeSNum.dt_GetTime,@n_codesnum=n_codesnum
from TBL_CodeSNum
where TBL_CodeSNum.vc_TableName='TBL_Xyz'

[zxdragon]

不会是指这种结果吧...

declare @dt_Time datetime

select @dt_Time = TBL_CodeSNum.dt_GetTime, n_CodeSNum
from TBL_CodeSNum
where TBL_CodeSNum.vc_TableName='TBL_Xyz'

[antimicrosoft]

问题已经顺利解决,谢谢各位了