Catégories
SQL

Postgresql – Sélectionner les champs d’une colonne commençant par un chiffre

Aide mémoire La table adresse présentée ci-dessous est à remettre en forme en remettant les valeurs dans les bons champs. Quelques valeurs de libellevoie sont mal formées. Il est donc nécessaire préalablement d’identifier les champs commençant par un nombre afin de reventiler les données. adresses Pour les sélectionner les champs débutant par un nombre, la requête est :
select * from origine 
where left(libellevoie, 1) ~ '^[0-9]*
Cette requête est utilisable ensuite dans un script d’update de la table. On peut ainsi réaffecter les valeurs dans numvoie, puis dans typevoie en une seule passe.
Catégories
Tech

Débloquer la clé d’activation d’office 2010

Vous avez été nombreux à acquérir un nouvel ordinateur doté du tout nouveau Windows et de la suite bureautique Microsoft Office.

Inconvénient. Autant vous avez la licence pour votre système d’exploitation Windows, autant vous ne disposez que de la clé d’évaluation pour microsoft office . Et votre période d’essai n’est valable que 180 jours.

Ce qui est bête, c’est que 180 jours à partir de maintenant, ça va faire court.

Aussi, pour parer au plus pressé, en attendant d’aller régulariser la situation , je vous renvoie vers cette possibilité de hack. Ce serait bête de ruiner vos études pour si peu ?

NB : Vous avez aussi cette alternative pour déverrouiller la clé office.

Catégories
Musique

Cities in dust – Siouxies and the Banshees

Le 18 octobre 1985 sort le single Cities in Dust de Siouxies and The Banshees , une espèce d’ode à Pompéï, annonçant leur album à venir.

Tinderbox, le 7eme album du groupe punk canadien rejoint les bacs en 1986, quelques mois plus tard.

Water was running children were running
You were running out of time
Under the mountain, a golden fountain
Were you praying at the Lares shrine?
But oh your city lies in dust, my friend
Oh, oh your city lies in dust, my friend

We found you hiding we found you lying
Choking on the dirt and sand
Your former glories and all the stories
Dragged and washed with eager hands

But, oh oh your city lies in dust, my friend
Oh oh your city lies in dust, my friend
Your city lies in dust

Water was running children were running
We found you hiding we found you lying
Water was running children were running
We found you hiding we found you lying

Your city lies in dust, my friend
Oh oh your city lies in dust, my friend

Hot and burning in your nostrils
Pouring down your gaping mouth
Your molten bodies blanket of cinders
Caught in the throes

Oh oh your city lies in dust, my friend
Oh your city lies in dust, my friend

Oh oh your city lies in dust, my friend
Oh your city lies in dust, my friend

Your city lies in dust, my friend
Oh your city lies in dust, my friend

Paroliers : Peter Clarke / Steven Bailey / Susan BallionParoles de Cities in Dust
© BMG Rights Management, Domino Publishing Company

Catégories
Musique

Nick Kershaw – Wouldn’t it be good

Ecrite, composée et interprétée par Nik Kershaw, la chanson Wouldn’t It Be Good extraite de l’album Human Racing rencontre à sa sortie un succès immédiat qui propulse le titre dans le top 10 des charts d’un bon paquet de pays dont le Royaume-Uni et la France.

Le titre sort le 21 janvier 1984.

Le clip est signé Storm Thorgerson, un pote photographe de Roger Waters et de Syd Barrett de chez les Pink Floyd, fondateur de Hipgnosis, un collectif de graphistes brittaniques.

Paroles :

I got it bad
You don’t know how bad I got it
You got it easy
You don’t know when you’ve got it goodIt’s getting harder
Just keeping life and soul together
I’m sick of fighting
Even though I know I shouldThe cold is biting
Through each and every nerve and fibre
My broken spirit is frozen to the core
I don’t wanna be here no moreWouldn’t it be good to be in your shoes
Even if it was for just one day?
Wouldn’t it be good if we could wish ourselves away?Wouldn’t it be good to be on your side?
The grass is always greener over there
Wouldn’t it be good if we could live without a care?You must be joking
You don’t know a thing about it
You’ve got no problem
I’d stay right there if I were youI got it harder
You couldn’t dream how hard I got it
Stay out of my shoes
If you know what’s good for youThe heat is stifling
Burning me up from the inside
The sweat is coming through each and every pore
I don’t wanna be here no more
I don’t wanna be here no more
I don’t wanna be here no moreWouldn’t it be good to be in your shoes
Even if it was for just one day?
Wouldn’t it be good if we could wish ourselves away?
Ooh-oohWouldn’t it be good to be on your side?
The grass is always greener over there
Wouldn’t it be good if we could live without a care?I got it bad
You don’t know how bad I got it
You got it easy
You don’t know when you’ve got it good
It’s getting harder
Just keeping life and soul together
I’m sick of fighting
Even though I know I should
I don’t wanna be here no more

Catégories
Musique

Pointer Sisters – Automatic

Le 13 Janvier 1984, les Pointer Sisters sortent, sur le label « Planet », le second single de leur album « Break Out » sorti en 1983. Le titre, Automatic.

Un carton

https://www.youtube.com/watch?v=KNi8aW8Nf6s

Paroles :

Look what you’re doing to me
I’m utterly at your whim
All of my defenses downYour camera looks through me
With its X-ray vision
And all systems run agroundAll I can manage to push from my lips
Is a stream of absurdities
Every word I intended to speak
Winds up locked in the circuitry
No way to control it
It’s totally automatic
Whenever you’re around
I’m walking blindfolded
Completely automatic
All of my systems are down
Down, down, down
Automatic (automatic)
Automatic (automatic)
What is this madness
That makes my motor run
And my legs too weak to standI go from sadness
To exhilaration
Like a robot at your commandMy hands perspire and shake like a leaf
Up and down goes my temperature
I summon doctors to get some relief
But they tell me there is no cure
They tell me
No way to control it
It’s totally automatic
Whenever you’re around
I’m walking blindfolded
Completely automatic
All of my systems are down
Down, down, down
Automatic (automatic)
Automatic (automatic)Automatic
Automatic
Automatic
AutomaticLook what you’re doing to me
I’m utterly at your whim
All of my defenses downYour camera looks through me
With its X-ray vision
And all systems run agroundAll I can manage to push from my lips
Is a stream of absurdities
Every word I intended to speak
Winds up locked in the circuitry
No way to control it
It’s totally automatic
Whenever you’re around
I’m walking blindfolded
Completely automatic
All of my systems are down
Down, down, downNo way to control it
It’s totally automatic
Whenever you’re around
I’m walking blindfolded
Completely automatic
All of my systems are down
Down, down, downNo way to control it
It’s totally automatic

Catégories
Musique

Chaka Khan – Fate

Le 15 avril 1981, Chaka Khan sort le titre Fate tiré de l’album What Cha’ Gonna Do for Me.

Ce titre ne remporte pas le succès attendu, eu égard à la célébrité de la chanteuse à l’époque. What Cha’ Gonna Do For Me est un pur album studio dans lequel Rufus ne trempe pas. Ceci explique peut-être cela.

Toujours est-il que ce titre présente un petit potentiel puisqu’il sera partiellement réexploité en 1998 par Stardust, le groupe d’un des Daft Punk, pour Music Sounds Better With You qui y trouve son get down.

Paroles :

When you walked into my lonely life tonight
I saw my destiny, I saw eternity tonight
And the moment I held you I knew it
What we do is decided before we do itFate, this could only be
Fate, I never thought I’d believe in
Fate, now I understand
It’s part of the plan
I was meant to be your womanTime stood still, and we lost on words to say
And though the people stared, they seemed a million miles away
Oh we knew it was love we were feeling
We were destined to give it a whole new meaningFate, this could only be
Fate, I never thought I’d believe in
Fate, now I understand
It’s part of the plan
I was meant to be your womanIn my heart I feel I’ve loved you all my life
I was in the dark, but now I think I’ve seen the light
I rang like a bell with your laughter
Something tells me I’ll love you forever and everFate (this could only be)
It was fate (this could only be)
It’s part of the plan
I was meant to be your woman
(It’s part of the plan)
I’ll love you forever and ever

La reprise du sample :