Posts

Showing posts from June, 2011

oracle demo tables

BEGIN TRANSACTION DROP TABLE EMP; DROP TABLE DEPT; DROP TABLE SALGRADE; CREATE TABLE EMP ( EMPNO INT , ENAME VARCHAR(10), JOB VARCHAR(9), MGR INT, HIREDATE DATETIME, SAL INT, COMM INT, DEPTNO INT ); INSERT INTO EMP VALUES(7369,'SMITH','CLERK',7902,'1980-12-17',800, NULL, 20); INSERT INTO EMP VALUES(7499,'ALLEN','SALESMAN',7698,'1981-02-20',1600,300,30); INSERT INTO EMP VALUES(7521,'WARD','SALESMAN',7698,'1981-02-22',1250,500,30); INSERT INTO EMP VALUES(7566,'JONES','MANAGER',7839,'1981-04-02',2975,NULL,20); INSERT INTO EMP VALUES(7654,'MARTIN','SALESMAN',7698,'1981-09-28',1250,1400,30); INSERT INTO EMP VALUES(7698,'BLAKE','MANAGER',7839,'1981-05-01',2850,NULL,30); INSERT INTO EMP VALUES(7782,'CLARK','MANAGER',7839,'1981-06-09',2450,NULL,10); INSERT INTO EMP VALUES(7788,'SCOTT','ANALYST&#

VS2010 Trial Activation Guidelines

Image
There are four ways to activate a trial version of Visual Studio 2010 (including those versions downloaded from the Microsoft Store, VLSC, or MSDN) once you have obtained a full product key. All four options are listed below. Please note that you only need to perform one of these listed options. Note: You can use any of the 4 options presented here to activate the product. We recommend using Option 1 for most cases. In each case setup will use the existing files without needing to copy anything else unless additional items are installed as part of options 2, 3 & 4. All screen shots in this document are from Visual Studio 2010 Professional running on Windows 7. Other combinations of Visual Studio editions and Windows versions may render slightly differently. Contents OPTION 1: Activate from within Visual Studio 2010 .......................................................................... 1 OPTION 2: Maintenance Mode via Control Panel ..............................................