Click here to Skip to main content
15,388,979 members
Home / Discussions / Database
   

Database

 
GeneralRe: Get date not exist Pin
Mycroft Holmes12-May-15 14:11
professionalMycroft Holmes12-May-15 14:11 
QuestionDatabase Pin
Member 116493918-May-15 19:14
MemberMember 116493918-May-15 19:14 
QuestionRe: Database Pin
Richard MacCutchan8-May-15 21:40
mveRichard MacCutchan8-May-15 21:40 
AnswerRe: Database Pin
Richard Andrew x649-May-15 6:16
professionalRichard Andrew x649-May-15 6:16 
Questionupdate query not updating Pin
turnerdavid7-May-15 3:55
Memberturnerdavid7-May-15 3:55 
AnswerRe: update query not updating Pin
ZurdoDev7-May-15 4:12
professionalZurdoDev7-May-15 4:12 
GeneralRe: update query not updating Pin
turnerdavid7-May-15 8:08
Memberturnerdavid7-May-15 8:08 
GeneralRe: update query not updating Pin
ZurdoDev7-May-15 8:12
professionalZurdoDev7-May-15 8:12 
Don't put it in the where clause. Use the SELECT statement as a preview of what you want the update to do.

For example:
SQL
SELECT file, file_link, Replace([file_link],'\52qjkl-as-04v\CE_Data\CE\CEC\oce_drawings','F:\CE\CE\CE Drawings') AS NewFile
FROM JobTicket_024
There are only 10 types of people in the world, those who understand binary and those who don't.

GeneralRe: update query not updating Pin
turnerdavid7-May-15 8:18
Memberturnerdavid7-May-15 8:18 
GeneralRe: update query not updating Pin
ZurdoDev7-May-15 8:58
professionalZurdoDev7-May-15 8:58 
GeneralRe: update query not updating Pin
turnerdavid7-May-15 10:26
Memberturnerdavid7-May-15 10:26 
GeneralRe: update query not updating Pin
ZurdoDev7-May-15 10:35
professionalZurdoDev7-May-15 10:35 
QuestionSybase Access Violaion Error Pin
Ankit RS6-May-15 21:32
MemberAnkit RS6-May-15 21:32 
SuggestionRe: Sybase Access Violaion Error Pin
ZurdoDev7-May-15 4:08
professionalZurdoDev7-May-15 4:08 
GeneralRe: Sybase Access Violaion Error Pin
Sascha Lefèvre7-May-15 6:25
professionalSascha Lefèvre7-May-15 6:25 
QuestionRe: Sybase Access Violaion Error Pin
Ankit RS8-May-15 0:36
MemberAnkit RS8-May-15 0:36 
AnswerRe: Sybase Access Violaion Error Pin
Sascha Lefèvre8-May-15 10:02
professionalSascha Lefèvre8-May-15 10:02 
QuestionUnion on a join Pin
jkirkerx6-May-15 9:20
professionaljkirkerx6-May-15 9:20 
AnswerRe: Union on a join Pin
Richard Deeming6-May-15 9:40
mveRichard Deeming6-May-15 9:40 
GeneralRe: Union on a join Pin
jkirkerx6-May-15 11:40
professionaljkirkerx6-May-15 11:40 
GeneralRe: Union on a join Pin
jkirkerx7-May-15 12:24
professionaljkirkerx7-May-15 12:24 
Questionpostgresql VACUUM Pin
V.5-May-15 23:55
professionalV.5-May-15 23:55 
JokeRe: postgresql VACUUM Pin
Tim Carmichael6-May-15 4:52
MemberTim Carmichael6-May-15 4:52 
GeneralRe: postgresql VACUUM Pin
Mycroft Holmes6-May-15 14:06
professionalMycroft Holmes6-May-15 14:06 
GeneralRe: postgresql VACUUM Pin
Tim Carmichael6-May-15 14:49
MemberTim Carmichael6-May-15 14:49 

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.