tb_gl_signature_library.sql

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

if object_id('GL_Signature_Library') is not null
drop table GL_Signature_Library
go

create table GL_Signature_Library
(
 userid CHAR(15) NOT NULL constraint pk_GL_user primary key,
 User_Desc      varchar(30) not null,
 Module_ID      char(10) not null default '2000',
 Signature_Img  image null,
 Block		bit null default 0,
 valid_dt       datetime not null default getdate(),
 Expire_dt      datetime not null default getdate()
)
go

insert into GL_signature_Library 
select userid,user_desc,'2000',signature_img,0,getdate(),'2008-12-01'
from user_signature_library

update GL_Signature_Library
	set signature_img = b.photo
from GL_Signature_Library a,signature_mstr b
where a.userid = b.userid