how to create stored proc

[policarpio ventura]

i want to create stored proc and insert data in a table where controlno increment

CREATE TABLE table_agency (agencyCd varchar(12),agencyname varchar(100),controlNo varchar(12);

insert into table_agency(agencyCd,agencyName,controlNo) values
('OTH','fire','201301010001');

the output should like this:


agencyCd | agencyName | controlNo
OTH | FIRE | 201301010001
OTH | FIRE | 201301010002
OTH | FIRE | 201301010003
OTH | FIRE | 201301010004



Edited 1 time(s). Last edit at 05/23/2013 03:07AM by policarpio ventura.