How to retrieve data from query and link the data to a data number?

Hot Topic

MSMQ Connection Manager and input into a data flow
Drag & Drop Multiple Query Files Into Management Studio
How do I calculate YTD for previous year
server problem occurred during deployment of vb.net application with MSSQL db
SQL2K5 SP1-CTP fails while upgrading "Database Services"
Where's the bell?
Missing SqlDataReader.GetSqlMetaData() in April CTP
How to get a handle of my queries
Errors in High Level Relational and OLAP Storage Engine
SQL Authentication issue

SQL Server

Indexed View - has no influence on performance
Is it possible to use T-SQL to create a user in Active Directory?
SSIS runtime components Install
User define function
An error occurred while receiving data: '10054(An existing connection was forcibly closed by the remote host.)'.
can i directly use a variable on this?
Copy databases
any way to check the duplicated rows in destination before loading data?
SP2 - Need Your Feedback!
SQL Server 2005 Service Pack 1 is now available

How to retrieve data from query and link the data to a data number?

i'm doing a project on SQL Server 2005, i'm stack in searching the data and can't link the data in the data number.. can someone help mi with the programming code as i can search for the words in the table but i can't link with the data number..

Answer this question

How to retrieve data from query and link the data to a data number?

  • Ferry Mulyono

    am i doing the correct thing this command will search for the keyword LIVER. or issit this command i doing half way through..

    SELECT Omim_No

    FROM av

    WHERE Description LIKE '%LIVER%'

    ORDER BY Omim_No ASC

    SELECT Omim_No

    FROM cs

    WHERE CS_Description LIKE '%LIVER%'

    OR CS_DATA LIKE '%LIVER%'

    ORDER BY Omim_No ASC

    SELECT Omim_No

    FROM ti

    WHERE Omim_Titles LIKE '%LIVER%'

    ORDER BY Omim_No ASC

    SELECT Omim_No

    FROM ti_alt_title

    WHERE Omim_Alt_Titles LIKE '%LIVER%'

    ORDER BY Omim_No ASC

    SELECT Omim_No

    FROM tx

    WHERE Omim_Text LIKE '%LIVER%'

    SELECT subsnp_id,pop_id,allele_id

    FROM AlleleFreqBySsPop

    WHERE source LIKE '%LIVER%'

    SELECT aln_id

    FROM b125_Alignments_35_1

    WHERE tr_acc LIKE '%LIVER%'

    OR ctg_name LIKE '%LIVER%'

    OR ctg_acc LIKE '%LIVER%'

    OR tr_orient LIKE '%LIVER%'

    SELECT ctg_id,exon_number,exon_start,exon_end

    FROM b125_ContigExon_1_1

    WHERE mrna_acc LIKE '%LIVER%'

    SELECT ctg_id,exon_number,exon_start,exon_end,seg_start,seg_end

    FROM b125_ContigExon_35_1

    WHERE mrna_acc LIKE '%LIVER%'

    SELECT b125_ContigInfo_1_1.*

    FROM b125_ContigInfo_1_1

    WHERE contig_acc LIKE '%LIVER%'

    OR contig_name LIKE '%LIVER%'

    OR contig_chr LIKE '%LIVER%'

    OR group_term LIKE '%LIVER%'

    OR group_label LIKE '%LIVER%'

    OR contig_label LIKE '%LIVER%'

    SELECT b125_ContigInfo_34_3.*

    FROM b125_ContigInfo_34_3

    WHERE contig_acc LIKE '%LIVER%'

    OR contig_name LIKE '%LIVER%'

    OR contig_chr LIKE '%LIVER%'

    OR group_term LIKE '%LIVER%'

    OR group_label LIKE '%LIVER%'

    OR contig_label LIKE '%LIVER%'

    SELECT b125_ContigInfo_35_1.*

    FROM b125_ContigInfo_35_1

    WHERE contig_acc LIKE '%LIVER%'

    OR contig_name LIKE '%LIVER%'

    OR contig_chr LIKE '%LIVER%'

    OR group_term LIKE '%LIVER%'

    OR group_label LIKE '%LIVER%'

    OR contig_label LIKE '%LIVER%'

    SELECT b125_CrashedInfo.*

    FROM b125_CrashedInfo

    WHERE snp_type LIKE '%LIVER%'

    SELECT b125_MapLink_35_1.*

    FROM b125_MapLink_35_1

    WHERE snp_type LIKE '%LIVER%'

    OR allele LIKE '%LIVER%'

    SELECT b125_MapLinkInfo_35_1.*

    FROM b125_MapLinkInfo_35_1

    WHERE accession LIKE '%LIVER%'

    SELECT b125_ModelInfo_35_1.*

    FROM b125_ModelInfo_35_1

    WHERE tr_acc LIKE '%LIVER%'

    OR donor LIKE '%LIVER%'

    OR acceptor LIKE '%LIVER%'

    OR alignment LIKE '%LIVER%'

    SELECT b125_ProjectedSNP_35_1.*

    FROM b125_ProjectedSNP_35_1

    WHERE snp_type LIKE '%LIVER%'

    SELECT b125_ProteinInfo_34_3.*

    FROM b125_ProteinInfo_34_3

    WHERE ref_seq_status LIKE '%LIVER%'

    OR rna_accs LIKE '%LIVER%'

    OR prot_accs LIKE '%LIVER%'

    OR nucl_accs LIKE '%LIVER%'

    SELECT b125_ProteinInfo_35_1.*

    FROM b125_ProteinInfo_35_1

    WHERE ref_seq_status LIKE '%LIVER%'

    OR rna_accs LIKE '%LIVER%'

    OR prot_accs LIKE '%LIVER%'

    OR nucl_accs LIKE '%LIVER%'

    SELECT b125_SNPContigLoc_34_3.*

    FROM b125_SNPContigLoc_34_3

    WHERE snp_type LIKE '%LIVER%'

    OR phys_pos LIKE '%LIVER%'

    OR allele LIKE '%LIVER%'

    SELECT b125_SNPContigLoc_34_3_dup.*

    FROM b125_SNPContigLoc_34_3_dup

    WHERE snp_type LIKE '%LIVER%'

    OR phys_pos LIKE '%LIVER%'

    OR allele LIKE '%LIVER%'

    SELECT b125_SNPContigLoc_34_3_fix.*

    FROM b125_SNPContigLoc_34_3_fix

    WHERE snp_type LIKE '%LIVER%'

    OR phys_pos LIKE '%LIVER%'

    OR allele LIKE '%LIVER%'

    SELECT b125_SNPContigLoc_35_1.*

    FROM b125_SNPContigLoc_35_1

    WHERE snp_type LIKE '%LIVER%'

    OR phys_pos LIKE '%LIVER%'

    OR allele LIKE '%LIVER%'

    SELECT b125_SNPContigLoc_35_1_ss.*

    FROM b125_SNPContigLoc_35_1_ss

    WHERE snp_type LIKE '%LIVER%'

    OR phys_pos LIKE '%LIVER%'

    OR allele LIKE '%LIVER%'

    SELECT b125_SNPContigLoc_35_1_ss_fixed.*

    FROM b125_SNPContigLoc_35_1_ss_fixed

    WHERE snp_type LIKE '%LIVER%'

    OR phys_pos LIKE '%LIVER%'

    OR allele LIKE '%LIVER%'

    SELECT b125_SNPContigLocusId_1_1_temp.*

    FROM b125_SNPContigLocusId_1_1_temp

    WHERE contig_acc LIKE '%LIVER%'

    OR locus_symbol LIKE '%LIVER%'

    OR mrna_acc LIKE '%LIVER%'

    OR protein_acc LIKE '%LIVER%'

    OR allele LIKE '%LIVER%'

    OR residue LIKE '%LIVER%'

    OR build_id LIKE '%LIVER%'

    SELECT b125_SNPContigLocusId_34_3.*

    FROM b125_SNPContigLocusId_34_3

    WHERE contig_acc LIKE '%LIVER%'

    OR locus_symbol LIKE '%LIVER%'

    OR mrna_acc LIKE '%LIVER%'

    OR mrna_ver LIKE '%LIVER%'

    OR protein_acc LIKE '%LIVER%'

    OR allele LIKE '%LIVER%'

    OR residue LIKE '%LIVER%'

    OR build_id LIKE '%LIVER%'

    SELECT b125_SNPContigLocusId_35_1.*

    FROM b125_SNPContigLocusId_35_1

    WHERE contig_acc LIKE '%LIVER%'

    OR locus_symbol LIKE '%LIVER%'

    OR mrna_acc LIKE '%LIVER%'

    OR mrna_ver LIKE '%LIVER%'

    OR protein_acc LIKE '%LIVER%'

    OR allele LIKE '%LIVER%'

    OR residue LIKE '%LIVER%'

    OR build_id LIKE '%LIVER%'

    SELECT b125_SNPContigLocusId_35_1_old.*

    FROM b125_SNPContigLocusId_35_1_old

    WHERE contig_acc LIKE '%LIVER%'

    OR locus_symbol LIKE '%LIVER%'

    OR mrna_acc LIKE '%LIVER%'

    OR mrna_ver LIKE '%LIVER%'

    OR protein_acc LIKE '%LIVER%'

    OR allele LIKE '%LIVER%'

    OR residue LIKE '%LIVER%'

    OR build_id LIKE '%LIVER%'

    SELECT b125_SNPMapInfo_34_3.*

    FROM b125_SNPMapInfo_34_3

    WHERE snp_type LIKE '%LIVER%'

    OR assembly LIKE '%LIVER%'

    SELECT b125_SNPMapInfo_34_3_fix.*

    FROM b125_SNPMapInfo_34_3_fix

    WHERE snp_type LIKE '%LIVER%'

    OR md5 LIKE '%LIVER%'

    OR assembly LIKE '%LIVER%'

    SELECT b125_SNPMapInfo_35_1.*

    FROM b125_SNPMapInfo_35_1

    WHERE snp_type LIKE '%LIVER%'

    OR md5 LIKE '%LIVER%'

    OR assembly LIKE '%LIVER%'

    SELECT b125_SNPMapInfo_35_1_ss.*

    FROM b125_SNPMapInfo_35_1_ss

    WHERE snp_type LIKE '%LIVER%'

    OR md5 LIKE '%LIVER%'

    OR assembly LIKE '%LIVER%'

    SELECT b125_WithdrawCandidates.*

    FROM b125_WithdrawCandidates

    WHERE subsnp_id LIKE '%LIVER%'

    SELECT Batch.*

    FROM Batch

    WHERE handle LIKE '%LIVER%'

    OR loc_batch_id LIKE '%LIVER%'

    OR loc_batch_id_upp LIKE '%LIVER%'

    OR batch_type LIKE '%LIVER%'

    OR moltype LIKE '%LIVER%'

    OR synonym_type LIKE '%LIVER%'

    OR linkout_url LIKE '%LIVER%'

    SELECT BatchCita.*

    FROM BatchCita

    WHERE citation LIKE '%LIVER%'

    SELECT BatchCommLine.*

    FROM BatchCommLine

    WHERE line LIKE '%LIVER%'

    SELECT BatchCultivar.*

    FROM BatchCultivar

    WHERE line LIKE '%LIVER%'

    SELECT BatchMeExLine.*

    FROM BatchMeExLine

    WHERE line LIKE '%LIVER%'

    SELECT BatchPrivLine.*

    FROM BatchPrivLine

    WHERE line LIKE '%LIVER%'

    SELECT BatchStrain.*

    FROM BatchStrain

    WHERE line LIKE '%LIVER%'

    SELECT BatchValCode.*

    FROM BatchValCode

    WHERE batch_id LIKE '%LIVER%'

    SELECT chk_SNPContigLoc_35_1.*

    FROM chk_SNPContigLoc_35_1

    WHERE snp_type LIKE '%LIVER%'

    OR phys_pos LIKE '%LIVER%'

    OR allele LIKE '%LIVER%'

    SELECT chk_SNPMapInfo_35_1.*

    FROM chk_SNPMapInfo_35_1

    WHERE snp_type LIKE '%LIVER%'

    OR md5 LIKE '%LIVER%'

    OR assembly LIKE '%LIVER%'

    SELECT Contact.*

    FROM Contact

    WHERE handle LIKE '%LIVER%'

    OR name LIKE '%LIVER%'

  • Saul

    you use the LIKE keyword to find data inside strings. You return the ID with the string in the query.



  • 9727604

    because some tables inside contain only numbers so i have to search for the keyword and display the result(omim number) and link this result number to a table contain numbers must be identical numbers. it is so hard that i can't really explain well sorry.. my tasks is hard..

  • Roni Tovi

    Please tell me this is not one command It's huge.

    At it's core, what you're doing is right, using the LIKE keyword.



  • Wilson Chew

    can u show an example i wan to search from the whole tables.. will the code be very long

  • Raoni

    first thing is how to search the keywords from the tables

    Second thing after u search the result ,how to link the result to a number related to the result


  • WinFormer

    how to link a result to a number i mean inside the table..

  • rastsan_caj

    What's wrong with this It will return all the data you could hope for. Do you want to generate new IDs, unique to the query and not in the DB



  • .net and xml newbie

    i wan to search for the word and it will display the Omim number and the Omim number will link to another identical number to display the description.. can u do it

  • Stephen123

    I'm sorry, I do not understand the question. What do you want to do



  • Steve4527

    I don't understand. You're selecting from multiple tables. Don't those tables have ID columns Can't you use those



  • KnownIssueJosh

    SELECT av.*,cs.*,ti.*,ti_alt_title.*,tx.*,AlleleFreqBySsPop.*,OmimVarLocusIdSNP.*

    FROM av,cs,ti,ti_alt_title,tx,AlleleFreqBySsPop,OmimVarLocusIdSNP

    WHERE

    av.Omim_No = cs.Omim_No

    AND av.Omim_No = ti.Omim_No

    AND av.Omim_No = ti_alt_title.Omim_No

    AND av.Omim_No = tx.Omim_No

    AND av.Omim_No = OmimVarLocusIdSNP.omim_id

    AND (

    Description LIKE '%LIVER%'

    OR CS_Description LIKE '%LIVER%'

    OR CS_DATA LIKE '%LIVER%'

    OR Omim_Titles LIKE '%LIVER%'

    OR Omim_Alt_Titles LIKE '%LIVER%'

    OR Omim_Text LIKE '%LIVER%'

    )

    how


  • ilr

    Nothing you're saying makes sense to me. You're selecting multiple tables why can't you just use the same ID, isn't that what you're saying you want



  • BluestOval

    I can't show you an example because I don't know the table schema you're using. You want SQL, right

    select id, name from tblSomething where name LIKE '%text%'



  • How to retrieve data from query and link the data to a data number?
Answer this question