Click here to Skip to main content
15,892,809 members

Welcome to the Lounge

   

For discussing anything related to a software developer's life but is not for programming questions. Got a programming question?

The Lounge is rated Safe For Work. If you're about to post something inappropriate for a shared office environment, then don't post it. No ads, no abuse, and no programming questions. Trolling, (political, climate, religious or whatever) will result in your account being removed.

 
AnswerRe: This code will self-destruct in... Pin
Phil J Pearson16-Oct-17 22:33
Phil J Pearson16-Oct-17 22:33 
AnswerRe: This code will self-destruct in... Pin
Marc Clifton17-Oct-17 1:55
mvaMarc Clifton17-Oct-17 1:55 
AnswerRe: This code will self-destruct in... Pin
Dan Neely17-Oct-17 2:55
Dan Neely17-Oct-17 2:55 
GeneralRe: This code will self-destruct in... Pin
Chris Maunder17-Oct-17 9:38
cofounderChris Maunder17-Oct-17 9:38 
GeneralRe: This code will self-destruct in... Pin
Dan Neely17-Oct-17 9:53
Dan Neely17-Oct-17 9:53 
AnswerRe: This code will self-destruct in... Pin
loctrice17-Oct-17 4:16
professionalloctrice17-Oct-17 4:16 
GeneralRe: This code will self-destruct in... Pin
Chris Maunder17-Oct-17 4:19
cofounderChris Maunder17-Oct-17 4:19 
AnswerRe: This code will self-destruct in... Pin
Bruce Patin17-Oct-17 4:29
Bruce Patin17-Oct-17 4:29 
We have views and stored procedures between the data and the applications. If I need to migrate a column to a different name or size, I
1. add the new column,
2. add code to the create and update procedures to update the new column as well as the old,
3. manually copy the old data to the new data,
4. change the views to use the new column (if adding new functionality rather than migrating, use ISNULL() as needed),
5. make new versions of the procedures (I add a number to the name for that purpose) to use the new column,
6. change the application in development and testing to use the new procedures,
7. deploy the new version of the application.
Later, after the data and application have been backed up or updated several times, I can delete the old versions of the procedures.
AnswerRe: This code will self-destruct in... Pin
Bassam Abdul-Baki17-Oct-17 4:45
professionalBassam Abdul-Baki17-Oct-17 4:45 
GeneralRe: This code will self-destruct in... Pin
Chris Maunder17-Oct-17 4:46
cofounderChris Maunder17-Oct-17 4:46 
GeneralRe: This code will self-destruct in... Pin
Bassam Abdul-Baki17-Oct-17 5:40
professionalBassam Abdul-Baki17-Oct-17 5:40 
AnswerRe: This code will self-destruct in... Pin
FredWah17-Oct-17 7:51
FredWah17-Oct-17 7:51 
AnswerRe: This code will self-destruct in... Pin
jschell17-Oct-17 8:03
jschell17-Oct-17 8:03 
AnswerRe: This code will self-destruct in... Pin
thewazz17-Oct-17 14:43
professionalthewazz17-Oct-17 14:43 
AnswerRe: This code will self-destruct in... Pin
S Douglas19-Oct-17 11:47
professionalS Douglas19-Oct-17 11:47 
GeneralRe: This code will self-destruct in... Pin
Chris Maunder19-Oct-17 14:13
cofounderChris Maunder19-Oct-17 14:13 
GeneralTerrible joke of the day PinPopular
Duncan Edwards Jones16-Oct-17 5:40
professionalDuncan Edwards Jones16-Oct-17 5:40 
GeneralRe: Terrible joke of the day Pin
den2k8816-Oct-17 5:44
professionalden2k8816-Oct-17 5:44 
GeneralRe: Terrible joke of the day Pin
megaadam16-Oct-17 5:46
professionalmegaadam16-Oct-17 5:46 
GeneralRe: Terrible joke of the day Pin
lopatir16-Oct-17 6:14
lopatir16-Oct-17 6:14 
GeneralRe: Terrible joke of the day Pin
megaadam16-Oct-17 7:01
professionalmegaadam16-Oct-17 7:01 
GeneralRe: Terrible joke of the day Pin
den2k8816-Oct-17 21:35
professionalden2k8816-Oct-17 21:35 
GeneralRe: Terrible joke of the day Pin
Rage16-Oct-17 7:30
professionalRage16-Oct-17 7:30 
GeneralRe: Terrible joke of the day Pin
Richard Deeming16-Oct-17 8:13
mveRichard Deeming16-Oct-17 8:13 
GeneralRe: Terrible joke of the day Pin
Jeremy Falcon16-Oct-17 9:09
professionalJeremy Falcon16-Oct-17 9:09 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.