lyfz_repos/铂金版源码/DBFile/SQL/腾工(2015-09-11).sql

-------------------2015-09-05------------------------
if not exists
(select * from syscolumns where id=object_id('tb_ErpPrinterSet') and name='ps_SmallTicketPrintName')
begin
	alter table tb_ErpPrinterSet add ps_SmallTicketPrintName  nvarchar(200) NULL
end
IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_Description' , N'SCHEMA',N'dbo', N'TABLE',N'tb_ErpPrinterSet', N'COLUMN',N'ps_SmallTicketPrintName'))
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'小票打印机名称' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tb_ErpPrinterSet', @level2type=N'COLUMN',@level2name=N'ps_SmallTicketPrintName'
GO

if not exists
(select * from syscolumns where id=object_id('tb_ErpPrinterSet') and name='ps_SmallTicketPrintPath')
begin
	alter table tb_ErpPrinterSet add ps_SmallTicketPrintPath  nvarchar(200) NULL
end
IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_Description' , N'SCHEMA',N'dbo', N'TABLE',N'tb_ErpPrinterSet', N'COLUMN',N'ps_SmallTicketPrintPath'))
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'小票打印机路径' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tb_ErpPrinterSet', @level2type=N'COLUMN',@level2name=N'ps_SmallTicketPrintPath'
GO