新增文章
文章标题
分类
C#
云星空
K3 BOS
K3 功能
用友
Oracle
python
SQL
MySql
PHP
HTML
script
windows
Access
影视后期
财务
服务
生活
内容
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ -- 账套列表 KIS-Z-160 select a.FAcctID ,a.FVersion ,a.FAcctNumber,a.FAcctName ,a.FCompanyName,a.FDescription ,a.FServer ,a.FSysUser ,a.FDBName ,b.FileName ,a.FCreateTime,a.FDupTime ,a.FBackupTime ,a.FAutoBakTime from AcctCtl.dbo.t_ad_kdAccount_gl a left join master.dbo.Sysdatabases b on a.facctnumber = b.name order by a.FAcctName ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ -- 更新:版本号 update AcctCtl.dbo.t_ad_kdAccount_gl set FVersion = '3.0.03.10' where FAcctID = 26
返回
保存