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
Categories
Access
(4)
Active Directory
(1)
Administration
(1)
Agile
(2)
Backup
(2)
Check
(1)
CLR
(2)
DB2
(1)
DBA Tasks
(44)
Domain Controller
(1)
EPM
(6)
FI
(1)
FICO
(1)
Fun
(1)
Gadget
(1)
linked server
(4)
Management
(1)
My OpenERP Setting
(3)
My Oracle Setting
(1)
MySQL
(44)
MySQL Query
(42)
MySQL Quiz
(2)
News
(1)
Online database
(1)
OpenERP
(7)
OpenERP:CRM
(1)
OpenERP:HRM
(3)
Oracle
(90)
Oracle Query
(86)
Oracle Test
(12)
PL/SQL
(78)
Pligg
(1)
PostgreSQL
(26)
PostgreSQL Query
(11)
PostgreSQL Quiz
(6)
PostgreSQL Tip
(15)
Project Management
(2)
Project Server 2007
(8)
psql
(1)
Python
(1)
Quiz
(3)
Restore
(1)
Salesforce
(1)
Salesforce Object Query Language
(2)
SAP
(1)
SCRUM
(2)
Security
(1)
SharePoint
(6)
SharePoint Designer
(3)
SOQL
(2)
SQL Server
(155)
SQL Server 2000
(21)
SQL Server 2005
(69)
SQL Server 2008
(26)
SQL Server Test
(83)
SQL Server Tip
(173)
SQL Tips
(5)
SQLite
(1)
T-SQL
(48)
Video
(3)
Virtual Machine
(1)
VirtualBox
(1)
vtigerCRM
(16)
YQL
(1)
Followers
Search This Blog
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...
-
What will be the output of the following scripts if you run them in SQL Server Management Studio? DECLARE @STR NTEXT SET @STR = REPLICATE ...
-
You need to create a report to display the issue date and total items issued of your warehouseissue table. If the item has not been issued y...
-
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...
-
You are creating a stored procedure that will delete data from the Contact table in a SQL Server 2005 database. The stored procedure include...
-
Have you ever used varchar(max) or varbinary(max) in your database? The maximum sizes of varchar(max) and varbinary(max) is the same in SQL...
-
What will be the value of @Today in the following script? DECLARE @Today VARCHAR(10) SET @Today = '02/02/2010' SET @Today = @Today +...
-
Your SQL Server database contains a lot of columns with data type nchar. Many of them contain preceding or trailing spaces. You need to imp...
-
Your company uses a SQL Server database to manage data on e-Commerse site. This database contains a trigger named tgInsertOrder, which fires...
Wikipedia
Search results
No comments:
Post a Comment