Subversion Repositories Integrator Subversion

SELECT * FROM sc_sec.sec_lancamento WHERE seq_modelo IS NOT NULL
SELECT * FROM sc_sec.sec_lancamento WHERE seq_modelo IS NULL

SELECT * FROM sc_sec.sec_produto WHERE dsc_produto LIKE '%D1 XT%'
SELECT * FROM sc_sec.sec_produto WHERE dsc_produto LIKE 'Acessório'


SELECT * FROM sc_sec.sec_lancamento WHERE seq_modelo IS NULL AND dsc_produto LIKE '%MOTO%'
SELECT * FROM sc_sec.sec_modelo WHERE dsc_modelo LIKE '%Razr i%'

UPDATE sc_sec.sec_lancamento
SET seq_modelo = 9
WHERE dsc_produto LIKE '%Razr i%'

"Tablet 7"

"Xperia ZQ"
"Xperia Z2"
"Xperia M"
"Xperia C"
"Xperia E1 D2004 D2005"

"Galaxy Ace 4"
"Galaxy S3 Slim G3812"
"Galaxy S4 i9500"
"Galaxy S5 Mini"
"Galaxy S5"
"Galaxy Win Duos i8552"
"Galaxy Gran Duos i9082"
"Galaxy Core 2"
"Galaxy Fame S6810"
"Galaxy Pocket Neo S5310"
"Galaxy Gran Prime"
"Galaxy Gran 2 Duos TV"
"Galaxy S Duos S7562"
"Galaxy Note III"
"Galaxy Core Plus TV G3502"

"iPhone 4S"
"iPhone 5"
"iPhone 5C"
"iPhone 6"

"Nokia Lumia 530"
"Nokia Lumia 630"
"Nokia Lumia 820"
"Nokia Lumia 1020"
"Nokia Lumia 1320"

"LG L4 II E470"
"LG Nexus 5"
"LG L5 II E455"
"LG L7 II P715"
"LG Optimus G E977"
"LG L90"
"LG G2 Mini"

UPDATE sc_sec.sec_lancamento
SET seq_modelo = (SELECT seq_modelo FROM sc_sec.sec_modelo WHERE dsc_modelo = 'Moto X')
WHERE dsc_produto LIKE '%Moto X X%';
SELECT * FROM sc_sec.sec_modelo WHERE dsc_modelo = 'Moto X'
SELECT * FROM sc_sec.sec_produto WHERE dsc_produto LIKE '%Moto X X%'

SELECT * FROM sc_sec.sec_lancamento