tb_po_vnd_id_number.sql

工厂采购系统,DELPHI+SQL SERVER,三层技术

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)))