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...
-
The contact table contains these columns: First_Name VARCHAR2(25) Sales_Commission NUMBER(3,2) Evaluate this SQL statement SELECT firs...
-
Select the correct statement that records the space occupied by deleted or updated rows for later reuse, and also updates statistics. A. VAC...
-
The employee table contains these columns: LAST_NAME VARCHAR2(50) FIRST_NAME VARCHAR2(50) SALARY NUMBER(8, 2) You need to display the na...
-
1. Download ODBC Driver at this address http://www.postgresql.org/ftp/odbc/versions/msi/ Choose the suitable version with your PostgreSQL ...
-
What will be the output of the following script? SELECT RTRIM('TestxxXXxxx','x') FROM dual; A. Test B. TestxxXX C. Te...
-
SELECT datname "Database Name" , usename "User Name" , procpid "Process ID" , client_addr "Client ...
-
The following query gets vtigerCRM Contact List SELECT t1.contact_no , t1.firstname , t1.lastname , t1.title , t4.accountname , ...
-
You have two SQL Server 2005 computers. One server is SQL1 and another is SQL2. You need to access SQL2 from SQL1. You have enough permissio...
