金蝶K3数据库查询示例

要  点：

1，不可以对物理表进行修改、删除操作

2，不可以对数据库进行修改、删除操作

3，数据的暂时存储使用临时表

4，必须有一个要返回的查询语句

5，关键字只能做为查询条件

 

下述示例只做为参考使用

示例一：本期未记账单据

declare  @StartTime datetime,

         @EndTime datetime,

       @CurYear smallint,

         @CurPeriod smallint

 

SELECT @CurPeriod =CONVERT(smallint,FValue) FROM t_SystemProFile

WHERE FCategory='IC' AND FKey='CurrentPeriod'

SELECT @CurYear =CONVERT(smallint,FValue) FROM t_SystemProFile

WHERE FCategory='IC' AND FKey='CurrentYear'

EXEC GetPeriodStartEnd @CurYear,@CurPeriod ,@StartTime output,@EndTime output

SELECT t1.FInterID,

       t1.FDate AS '日期',

       t1.FBillNO as '单据号码',

       t3.FShortNumber as '物料编码',

       t3.FName as '物料名称',

       t4.FName as '单位',

       t2.FQty as '数量',

       t2.FPrice as '单价',

       t2.FAmount as '金额