tb_po_vnd_id_number.sql

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

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

create table PO_VND_ID_Number
(
  number int not null default 1,
  vendor_id varchar(8) not null
)
declare
@maxid int 
select @maxid = isnull(count(*),0)+1  from ven_cust_mst
--select @maxid

insert into PO_VND_ID_Number values(@maxid,'V0000'+convert(char(3),(@maxid-1)))