Click here to Skip to main content
15,908,111 members
Home / Discussions / Database
   

Database

 
GeneralRe: single DataSet having multiple DataTables from multiple databases Pin
Hailu Worku Obsse16-Jun-17 2:17
professionalHailu Worku Obsse16-Jun-17 2:17 
GeneralRe: single DataSet having multiple DataTables from multiple databases Pin
Richard Deeming16-Jun-17 2:22
mveRichard Deeming16-Jun-17 2:22 
AnswerRe: single DataSet having multiple DataTables from multiple databases Pin
Mycroft Holmes15-Jun-17 13:16
professionalMycroft Holmes15-Jun-17 13:16 
GeneralRe: single DataSet having multiple DataTables from multiple databases Pin
Eddy Vluggen16-Jun-17 3:18
professionalEddy Vluggen16-Jun-17 3:18 
QuestionError in SSIS Connection says (Test connection failed because of an error in initializing provider. ORA-12541: TNS:no listener) Pin
indian1437-Jun-17 13:12
indian1437-Jun-17 13:12 
AnswerRe: Error in SSIS Connection says (Test connection failed because of an error in initializing provider. ORA-12541: TNS:no listener) Pin
mike1402125-Jun-17 21:53
mike1402125-Jun-17 21:53 
QuestionI need advice on storing application level encrypted data. Pin
Gilbert Consellado5-Jun-17 18:26
professionalGilbert Consellado5-Jun-17 18:26 
SuggestionRe: I need advice on storing application level encrypted data. Pin
Kornfeld Eliyahu Peter5-Jun-17 20:50
professionalKornfeld Eliyahu Peter5-Jun-17 20:50 
You do not explain what kind of data it is and what search you want to do...
As for the HASH based search - it will work only if you search for exact data, for instance 'Gilbert Consellado' will produce a constant HASH but the HASH for 'Gilbert' will not be part of it, so you will find that piece of data only if you are looking for 'Gilbert Consellado' exactly as is (include case and space and order)...

If there is a way to index the data, prior encryption, than you can use it (the HASH of the indexes) to search quickly at the DB level...
Skipper: We'll fix it.
Alex: Fix it? How you gonna fix this?
Skipper: Grit, spit and a whole lotta duct tape.

QuestionHow do I write the insert sql statement for the following scenario ? Pin
karengsh3-Jun-17 22:30
karengsh3-Jun-17 22:30 
AnswerRe: How do I write the insert sql statement for the following scenario ? Pin
Mycroft Holmes4-Jun-17 13:49
professionalMycroft Holmes4-Jun-17 13:49 
GeneralRe: How do I write the insert sql statement for the following scenario ? Pin
karengsh4-Jun-17 20:41
karengsh4-Jun-17 20:41 
GeneralRe: How do I write the insert sql statement for the following scenario ? Pin
Mycroft Holmes4-Jun-17 20:58
professionalMycroft Holmes4-Jun-17 20:58 
GeneralRe: How do I write the insert sql statement for the following scenario ? Pin
karengsh4-Jun-17 22:12
karengsh4-Jun-17 22:12 
GeneralRe: How do I write the insert sql statement for the following scenario ? Pin
Mycroft Holmes5-Jun-17 12:05
professionalMycroft Holmes5-Jun-17 12:05 
GeneralRe: How do I write the insert sql statement for the following scenario ? Pin
karengsh10-Jun-17 19:12
karengsh10-Jun-17 19:12 
GeneralRe: How do I write the insert sql statement for the following scenario ? Pin
Mycroft Holmes10-Jun-17 20:45
professionalMycroft Holmes10-Jun-17 20:45 
GeneralRe: How do I write the insert sql statement for the following scenario ? Pin
karengsh11-Jun-17 17:38
karengsh11-Jun-17 17:38 
GeneralRe: How do I write the insert sql statement for the following scenario ? Pin
Mycroft Holmes11-Jun-17 23:39
professionalMycroft Holmes11-Jun-17 23:39 
GeneralRe: How do I write the insert sql statement for the following scenario ? Pin
karengsh14-Jun-17 18:55
karengsh14-Jun-17 18:55 
Questionwhy we use datareader Pin
Mazahir Habib1-Jun-17 20:10
Mazahir Habib1-Jun-17 20:10 
AnswerRe: why we use datareader Pin
John C Rayan1-Jun-17 22:16
professionalJohn C Rayan1-Jun-17 22:16 
GeneralRe: why we use datareader Pin
Mycroft Holmes1-Jun-17 22:25
professionalMycroft Holmes1-Jun-17 22:25 
Questionattempt to load oracle client libraries threw badimageformatexception ssis Pin
indian1431-Jun-17 13:59
indian1431-Jun-17 13:59 
AnswerRe: attempt to load oracle client libraries threw badimageformatexception ssis Pin
Richard Deeming2-Jun-17 1:18
mveRichard Deeming2-Jun-17 1:18 
QuestionLoading Data on Demand Pin
Richard Andrew x6431-May-17 11:02
professionalRichard Andrew x6431-May-17 11:02 

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.