Database

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

mavii wrote:

how pictures are stored in a table column

Peterson Luiz wrote:

Is there any way to change the date format in sql server 2005 forever?? I mean, in a way that all connection use this format.

mavii wrote:

if i want to display only last entered 4 records from a table, then which query will be written

SELECT TOP 4 * FROM MyTable<br />
ORDER BY DateStamp DESC