Recent content by JasonXie

Hi, All: Can anyone tell me which software or tool can be used to draw the EER diagram and finally convert them to a set of relation tables satisfying the normalization ? Many thanks in advance.

Many thanks.

Hummmmmm, moonhearts, hummmmm, OOOOOOOdd, Anyway, try to use a nested query. For example, If you have got these: Q1 : select sum(amount) as qtr1 from sales where date in (Jan, Feb, Mar) ( or something like this ) Q2: select sum(amount) as qtr2 from sales where date in (Apr, May, Jun) ...

Hello,All: I am playing Oracle Enterprise Edition 8.1.7 and want to get familiar with it espacially materialized views and query re-write. First, I used SQL-Plus and defined a materialized view by using the following : create materialized view first_summary pctfree 0 tablespace...

Hello,All: As we all know, a simple query S_q is of a standard form, i.e. select ... from ... where... group by ... having ... sorted by ... Actually, a nested query N_q may contain other simple queries with standard form (or even other nested queries) in the where clause/from clause/having...

Hello, All: These might be stupid questions. First: For a given table with 10 attributes, without knowing the type of the attributes, without knowing any specified requirements, how many queries can be generated on this single table by using as many combinations of SQL query keywords as...

I think you may want to create a script which can change the registry key such as adding key, changing value. If so, you can check the kix web site to get details. Cheers,

Hello, again : We have installed the OLAP Server on one server. However, we do worry about the server will crash under too many connections. Is it possible to limit the number of connections to the OLAP Server ? And How ? Many thanks in advance.

Hello, Can anyone point out whether there is a way to use a command/script to add users into OLAP Administrators Group ? Including adding "everyone" of the local machine into the group ? Many thanks in advance.

Hello, again : We have installed the OLAP Server on one server. However, we do worry about the server will crash under too many connections. Is it possible to limit the number of connections to the OLAP Server ? And How ? Many thanks in advance.

Hello, Can anyone point out whether there is a way to use a script to add users into OLAP Administrators Group ? Such as adding "everyone" of the local machine into the group ? Many thanks in advance.

All right . I fixed it. add switch -ntc- and everything is ok. Hopefully, this may help others.

The client PC used by students has three partition. One is the ghost boot partition, one is Windows2000 boot partition. The last is a temp partition which can be used to save students' work temporarily. I only need to create an image for the Windows2000 boot partition which is 10G with 50%...

Hello, All: The problem happened if the image was bigger than 2G and had to span. The ghost version is 6.51. The server platform is NT4 SP6a. The client platform is Windows 2000 professional. Is there anyone who met the same problem and fixed it? Many thanks in advance.

Hello All, I am running NT4.0 Server and Win2000 Server. I know how to use odbcad32.exe (GUI) to add DSNs one by one. It is really boring if you are going to add many many DSNs, isn't it ? I am wondering whether there is a way to use command lines to do that ,i.e., creat a batch file to add...