Database

SwatCats wrote:

Can anyone throw somelight on how efficient I can tune this sp??

Dr.PHP wrote:

But i can add timestamp field if u have any solution with it

if @v = '@p5'
Begin
    --Use @p5 variable here
End

declare @p1 nvarchar(20)

@declare @first_name nvarchar(20)

switch( @v )
{
  case '@p1' : @p1
  case '@p2' : @p2
  case '@p3' : @p3
  ...
  case '@p30' : @p30
  default NULL
}

void initialize()
{ p_val(1)= @p1;  p_val(2)= @p2; ... 
  p_ndx(1)='@p1'; p_ndx(2)='@p2' ...
}

variant get_p_value( string p_name )
{ int curr_ndx = 1;
  while( p_ndx( curr_ndx ) <> p_name ) curr_ndx++;
  return p_val( curr_ndx );
}

return_value = eval( @v );

SELECT val FROM myTable WHERE name=@v;

mindgameny wrote:

a sequence number will fill up the id column

create table myTable
(
  id number(10),
  name varchar2(20);
)
alter table myTable
add (constraint mytable_pk primary key (id));

create sequence myTable_seq;

create or replace trigger myTable_Insert
before insert on myTable
for each row
when (new.id is null)
begin
  select myTable_seq.NEXTVAL
  into :new.id
  from dual;
end;

INSERT INTO myTable(name) values ('Test');