Wednesday, January 22, 2014
Subscribe to:
Posts (Atom)
About Me
- Richard Trương
- I love information system such as ERP, CRM, SCM, HRM, Accounting, etc very much and would like to share my knowledge about ERP, CRM, HRM, SCM, ... which I knew to everyone.
Popular Posts
-
If you want to use a single query to replace multiple spaces with one on SQL Server, you can read the articles here http://www.sqlservercent...
-
Your company uses a SQL Server database to manage data on e-Commerse site. This database contains a trigger named tgInsertOrder, which fires...
-
Default: ASC SELECT ACCOUNT_ID, ACCOUNT_NAME FROM ACCOUNT ORDER BY ACCOUNT_ID; SELECT ACCOUNT_ID, ACCOUNT_NAME FROM ACCOUNT ORDER BY ACCOU...
-
1. Download ODBC Driver at this address http://www.postgresql.org/ftp/odbc/versions/msi/ Choose the suitable version with your PostgreSQL ...
-
Select the correct statement that records the space occupied by deleted or updated rows for later reuse, and also updates statistics. A. VAC...
-
The contact table contains these columns: First_Name VARCHAR2(25) Sales_Commission NUMBER(3,2) Evaluate this SQL statement SELECT firs...
-
What will be the output of the following script? SELECT RTRIM('TestxxXXxxx','x') FROM dual; A. Test B. TestxxXX C. Te...
-
The employee table contains these columns: LAST_NAME VARCHAR2(50) FIRST_NAME VARCHAR2(50) SALARY NUMBER(8, 2) You need to display the na...
-
SELECT datname "Database Name" , usename "User Name" , procpid "Process ID" , client_addr "Client ...
-
You want to display the details of all employees whose first names is Bill. But you are not sure in which case first names are stored. Which...
