Life Quote: The difficulties, hardships and trials of life, the obstacles...are positive blessings. They knit the muscles more firmly, and teach self-reliance. ~ William Matthews
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
-
Default: ASC SELECT ACCOUNT_ID, ACCOUNT_NAME FROM ACCOUNT ORDER BY ACCOUNT_ID; SELECT ACCOUNT_ID, ACCOUNT_NAME FROM ACCOUNT ORDER BY ACCOU...
-
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...
-
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...
-
What will be the output of the following script? SELECT RTRIM('TestxxXXxxx','x') FROM dual; A. Test B. TestxxXX C. Te...
-
Your company uses a SQL Server database to manage data on e-Commerse site. This database contains a trigger named tgInsertOrder, which fires...
-
What will be the output of the following scripts if you run them in SQL Server Management Studio? DECLARE @STR NTEXT SET @STR = REPLICATE ...
-
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...
-
The employee table contains these columns: LAST_NAME VARCHAR2(50) FIRST_NAME VARCHAR2(50) SALARY NUMBER(8, 2) You need to display the na...
No comments:
Post a Comment