Tags » SQL

Setting/Editing the MySQL root password on Mac OSX

Bonjour,

As usual, the task is a very easy one which involves very simple steps.

1. Open Terminal and goto mysql/bin. You can go to this path by running the following command: 130 more words

MAC LIFE!

SQL vs VBA code in Access

I have not had much experience writing SQL code, I as taught VBA code in school, but not SQL.  At least in Access it seems to be different but less involved. 58 more words

SQL

Oracle SQL String Concatenation

SELECT Column1 || ‘, ‘ || Column2 FROM Table …

Microsoft CEO unveils new data strategy

Microsoft CEO Satya Nadella has presented at an event in San Francisco’s new data strategy of his company. On the “Accelerate Your Insights” he spoke of “ambient intelligence” and a new culture data, require changes in any organization. 7 more words

SQL tips: Failsave Inserts - never mix up column orders again!

Imagine you have an Insert statement like this:

INSERT INTO target_table
    (measure_id,
     value_01,
     value_02,
     value_03,
     value_04,
     value_05,
     value_06,
     value_07)
SELECT load_id * 100 AS measure_id,
       val_1 AS value_01,
       CASE
           WHEN val_2 < 10 THEN 1
           WHEN val_2 < 100 THEN 2
           WHEN val_2 < 1000 THEN 3
           ELSE 4 
       END  AS value_02,
       val_3 AS value_03,
       val_4 AS value_04,
       CASE
           WHEN val_5 = 1 THEN 1
           WHEN val_5 = 2 THEN 20
           WHEN val_5 > 2 THEN 300
           ELSE null
       END AS value_05,
       CASE
           WHEN val_5 IN (1, 5, 7, 9, 11) THEN 21
           WHEN val_5 IN (2, 3) THEN 22
           WHEN val_5 IN (4, 6, 8, 10) THEN 23
           ELSE 24
        END AS value_06,
       val_6 * 100 + val_1 AS value_07
  FROM measure_table
 WHERE load_day > trunk(sys_date);
… 373 more words
Oracle

T-SQL

Today’s class project was about the use of several functions.

AVG
MAX
MIN
SUM

Using transaction table with 2300 rows 41 more words

SQL

#Microsoft Infrastructure-as-a-Service Fabric Architecture Guide #CloudOS #SCVMM #Hyperv #Azure

The goal of the Infrastructure-as-a-Service (IaaS) product line architecture (PLA) is to help organizations develop and implement private cloud infrastructures quickly while reducing complexity and risk. 160 more words

HyperV