如何使用存储过程查找此类数据 [英] How to find this type of data using stored procedure

问题描述

你好，
我有像
一样的桌子

Hello,
I have Table like

name| skills   | area |<br />
________________________<br />
ajay| .net,wcf | hyd  <br />
ram   | java,.net| bang

我想在存储过程中找到具有Java，点等候选技能的人
您可以在我的应用程序前面引导或结束任何代码段吗?我正在使用文本框进行输入，例如java，.net

I want to find who have candidates skills like java,dot in stored procedure
can u guide or end any snippets in front my application i am using textbox for for giving input like java,.net

推荐答案

您可以做到...但是这并不容易，特别是如果您不按任何特定顺序存储技能.您可以使用LIKE条件来掌握一项技能:

You can do it...but it''s not easy, particularly if you don''t store skills in any particular order. You can use the LIKE condition to pick up one skill:

SELECT name FROM myTable WHERE skills LIKE '%.net%'

会选择这两行，但是对于多种技能来说，这就是PITA.

我会更改您存储技能的方式-拥有一个Skills表，该表具有一个名称(".NET"，"Java"，...)和一个ID，然后有一个单独的表将客户端与技能链接(通过客户ID).这样，您可以更高效地检索所有具有多种技能的人员(而且在输入数据时，不能将"java"拼写为"jova"，并且错失一个职位)

would pick up both lines, but for multiple skills it''s a PITA.

I would change the way you stored skills - have a Skills table, which has a name (".NET", "Java", ...) and an ID, then have a separate table linking the client to a skill (via the client ID). THis way, you can retrieve all those who have multiple skills much, much =more efficiently (And you can''t spell "java" as "jova" by mistake when doing data entry and miss some one out for a position)

这篇关于如何使用存储过程查找此类数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！