Automatism Generate Serial number...
来源:互联网 发布:人工智能的含义是什么 编辑:程序博客网 时间:2024/05/16 19:27
--Sql server2000 Environment
--Generate serial number for tbale tb_bh
--Section 1:
--Create a table,Table name:tb_bh
CREATE TABLE tb_bh(BH varchar(20))
--Section 2,Create a procedure as below.
IFEXISTS (SELECT name FROM sysobjects
WHERE name = N'proc_tb_bh'AND type ='P')
DROPPROCEDURE proc_tb_bh
GO
CREATE PROCEDURE proc_tb_bh
AS
insertinto tb_bh SELECTconvert(varchar(8),getdate(),112)+RIGHT(100001+ISNULL(RIGHT(MAX(BH),5),0),5) FROM tb_bh
GO
--Selection 2,Run the Procedure generate serial number
execute proc_tb_bh
select * from tb_bh
--Oracle9i Environment
Section 1
-- Create sequence
create sequence BH
minvalue 1
maxvalue 99999
start with 1
increment by 1
cache 20;
--Section 2
create or replace procedure proc_tb_bh
as
begin
insert into tb_bh values(bh.nextval);
commit;
end proc_tb_bh;
- Automatism Generate Serial number...
- generate alphanumeric serial number
- Automatically generate serial number in abap
- 读取 system serial number
- serial number status
- MindNode Pro serial number
- sqlite manager serial number
- Autocord serial number.
- Auto Generate Item Number
- 读取scsi磁盘serial number
- Serial Number Related Profiles/Options
- C# 获取硬盘序列号 Volume Serial Number
- Component Art 2006 /2007 Serial Number
- Get Volume Serial Number in C#
- delphi 2007安装 Invalid Serial Number 问题
- Serial Number Management In SAP SD
- Flex Builder serial number Beta 2
- delphi 2007安装 Invalid Serial Number 问题
- 最真实的2006年应届毕业生真实薪水
- 求助,怎么实现新闻自动采集并更新内容
- Vi 使用及Shell 编程
- JSP内建对象详解
- vi 使用手册
- Automatism Generate Serial number...
- 新版CCNA 640-801考试IOS命令大全
- 做子女的都该看看
- 嫁给玩《魔兽争霸》男人的10个理由
- 13h视频模式下的几个宏
- TreeView使用集锦
- .net关于企业Excel报表的生成
- 《“通用语”与“兽人语”互译手册》(全集)
- 注册客户端脚本的几个函数