Click here to Skip to main content
15,350,151 members
Home / Discussions / Database
   

Database

 
GeneralRe: Validate Date Time value on Sqlite before insert / update Pin
Eddy Vluggen20-Jun-14 10:45
professionalEddy Vluggen20-Jun-14 10:45 
GeneralRe: Validate Date Time value on Sqlite before insert / update Pin
PIEBALDconsult20-Jun-14 9:43
professionalPIEBALDconsult20-Jun-14 9:43 
AnswerRe: Validate Date Time value on Sqlite before insert / update Pin
Eddy Vluggen18-Jun-14 0:29
professionalEddy Vluggen18-Jun-14 0:29 
AnswerRe: Validate Date Time value on Sqlite before insert / update Pin
jschell18-Jun-14 11:23
Memberjschell18-Jun-14 11:23 
AnswerRe: Validate Date Time value on Sqlite before insert / update Pin
PIEBALDconsult20-Jun-14 9:46
professionalPIEBALDconsult20-Jun-14 9:46 
QuestionSQL search question Pin
Jassim Rahma16-Jun-14 22:14
MemberJassim Rahma16-Jun-14 22:14 
AnswerRe: SQL search question Pin
Eddy Vluggen16-Jun-14 22:29
professionalEddy Vluggen16-Jun-14 22:29 
AnswerRe: SQL search question Pin
NitinDhapte16-Jun-14 23:08
MemberNitinDhapte16-Jun-14 23:08 
Dear Jassim,

If you know the exact column list to search data

For Example :
1. company_name
2. first_name
3. last_name

Then you can write down your query as below :

SQL
SELECT * FROM contacts WHERE (company_name like '%'+@searchText+'%' OR first_name like '%'+@searchText+'%' OR last_name like '%'+@searchText+'%')


Secondly, If you don't know about the column list then let me know the I can write a dynamic query for you.
AnswerRe: SQL search question Pin
Shameel17-Jun-14 0:48
professionalShameel17-Jun-14 0:48 
GeneralRe: SQL search question Pin
Jassim Rahma17-Jun-14 1:35
MemberJassim Rahma17-Jun-14 1:35 
AnswerRe: SQL search question Pin
Shameel17-Jun-14 5:31
professionalShameel17-Jun-14 5:31 
GeneralRe: SQL search question Pin
Eddy Vluggen17-Jun-14 7:41
professionalEddy Vluggen17-Jun-14 7:41 
QuestionHow to Search a Text into a Database objects Pin
Ravindra Bisen16-Jun-14 20:27
MemberRavindra Bisen16-Jun-14 20:27 
AnswerRe: How to Search a Text into a Database objects Pin
$*Developer - Vaibhav*$16-Jun-14 20:41
Member$*Developer - Vaibhav*$16-Jun-14 20:41 
GeneralRe: How to Search a Text into a Database objects Pin
Ravindra Bisen16-Jun-14 20:43
MemberRavindra Bisen16-Jun-14 20:43 
GeneralRe: How to Search a Text into a Database objects Pin
$*Developer - Vaibhav*$16-Jun-14 20:45
Member$*Developer - Vaibhav*$16-Jun-14 20:45 
AnswerRe: How to Search a Text into a Database objects Pin
Ravindra Bisen16-Jun-14 21:07
MemberRavindra Bisen16-Jun-14 21:07 
AnswerRe: How to Search a Text into a Database objects Pin
Richard Deeming17-Jun-14 2:09
mveRichard Deeming17-Jun-14 2:09 
QuestionData Warehouse/SSAS Cube/Reporting and date assistance Pin
Member 1088784816-Jun-14 6:02
MemberMember 1088784816-Jun-14 6:02 
AnswerRe: Data Warehouse/SSAS Cube/Reporting and date assistance Pin
Mycroft Holmes16-Jun-14 12:49
professionalMycroft Holmes16-Jun-14 12:49 
GeneralRe: Data Warehouse/SSAS Cube/Reporting and date assistance Pin
Member 1088784816-Jun-14 22:41
MemberMember 1088784816-Jun-14 22:41 
QuestionORM Rant Pin
Tomaž Štih16-Jun-14 0:55
MemberTomaž Štih16-Jun-14 0:55 
AnswerRe: ORM Rant Pin
Richard MacCutchan16-Jun-14 3:37
mveRichard MacCutchan16-Jun-14 3:37 
GeneralRe: ORM Rant Pin
Tomaž Štih16-Jun-14 3:51
MemberTomaž Štih16-Jun-14 3:51 
GeneralRe: ORM Rant Pin
Richard MacCutchan16-Jun-14 4:10
mveRichard MacCutchan16-Jun-14 4:10 

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.