tb_gl_payment_mstr.sql

来自「工厂采购系统,DELPHI+SQL SERVER,三层技术」· SQL 代码 · 共 15 行

if object_id('dbo.GL_Payment_Mstr') is not null
drop table dbo.GL_Payment_Mstr
go

create table GL_Payment_Mstr
(
 item int identity(100,1) not null,
 Payment  varchar(120) not null,
 Language CHAR(2)  null default 'EN'
)

go
insert into GL_Payment_Mstr(payment,language)
select Payment_new ,'EN' from import_Payment
group by payment_new