lyfz_repos/经典版源码/document/数据库新版本脚本/ADD_jdd.sql

--现金收入 添加字段jdd
IF NOT EXISTS (SELECT   O.NAME AS TabName,C.NAME AS ColName
FROM SYSOBJECTS O INNER JOIN SYSCOLUMNS C ON O.ID=C.ID 
WHERE O.NAME= 'gudingfeiyong' AND C.NAME   = 'jdd')
	ALTER TABLE gudingfeiyong ADD jdd nvarchar(50) null

--其它收入 添加字段jdd
IF NOT EXISTS (SELECT   O.NAME AS TabName,C.NAME AS ColName
FROM SYSOBJECTS O INNER JOIN SYSCOLUMNS C ON O.ID=C.ID 
WHERE O.NAME= 'singleincome' AND C.NAME   = 'jdd')
	ALTER TABLE singleincome ADD jdd nvarchar(50) null