declare @dt_Time datetimeselect @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了
from TBL_CodeSNum
where TBL_CodeSNum.vc_TableName='TBL_Xyz'select @dt_Time 时间在delphi或其他语言或查询分析器中java: rs.execquery();delphi: query.open; .......
就OK了
你的前台语言????select @dt_Time = TBL_CodeSNum.dt_GetTime
from TBL_CodeSNum
where TBL_CodeSNum.vc_TableName='TBL_Xyz';select @dt_Time 时间
----------------------------------------^^^在delphi query中要加;
是否
declare @dt_Time datetime,@n_CodeSNum intselect @dt_Time = TBL_CodeSNum.dt_GetTime,@n_codesnum=n_codesnum
from TBL_CodeSNum
where TBL_CodeSNum.vc_TableName='TBL_Xyz'
from TBL_CodeSNum
where TBL_CodeSNum.vc_TableName='TBL_Xyz'