Installing IIS on Window Vista ,WindowXp , Window Server 2008/2003 Part1

Windows XP and Windows Server 2003



You install IIS through the Add or Remove Programs section, which you can access through the control panel or by choosing Start ➪ Run and then entering appwiz.cpl. When you’re in the Add or Remove Programs dialog box, you need to click the Add/Remove Windows Components button at the left side of the dialog box to bring up the Windows Component Wizard, shown in Figure 18-7.


Figure 18-7

On Windows XP you should see the Internet Information Services (IIS) item directly in the list with components.


For Windows Server 2003, click Application Server first and then click the Details button.


On Windows Server 2003, check the ASP.NET item. For both Windows XP and Windows Server 2003, verify


that Internet Information Services (IIS) is selected and then click the Details button. Check at least the


following items:


❑ Common Files


❑ Internet Information Services Snap-In (called Internet Information Services Manager on


Windows Server 2003)


❑ World Wide Web Service








Note:-Please comment and reply me.

Read More

A NOCYCLE sequence

 A NOCYCLE sequence

SQL> -- A NOCYCLE sequence
SQL>
SQL>
SQL> CREATE SEQUENCE StudentNumSeq
  2 INCREMENT BY 50000
  3 START WITH 50000
  4 MAXVALUE 99999
  5 NOCACHE
  6 NOCYCLE;

Sequence created.

Read More

A CYCLE sequence

 A CYCLE sequence

SQL> -- A CYCLE sequence
SQL>
SQL>
SQL> CREATE SEQUENCE StudentNumSeq
  2 INCREMENT BY 50000
  3 START WITH 50000
  4 MAXVALUE 99999
  5 NOCACHE
  6 CYCLE;

Sequence created.

SQL>
SQL>
SQL> select studentNumSeq.nextVal from dual;

  NEXTVAL
----------
  50000

SQL> select studentNumSeq.nextVal from dual;

  NEXTVAL
----------
  1

SQL> select studentNumSeq.nextVal from dual;

  NEXTVAL
----------
  50001

SQL>
SQL>
SQL> drop sequence studentNumSeq;



Note:-Please comment and reply me.

Read More

Merge Statement Example in Orcale

merge [ hints ] into table-name-1 | view-name-1 [ alias-1 ]
using table-name-2 | view-name-2 | subquery [ alias-2 ]
on ( condition )
[ merge-update-clause ] [ merge-insert-clause ] [ error-logging-clause ];
 

 create table table_dest (
  id number primary key,
  txt varchar2(20)
);

insert into table_dest values (1,'one');
insert into table_dest values (3,'three');
insert into table_dest values (5,'five');

commit;

create table table_source (
  id number primary key,
  txt varchar2(20)
);

Read More