如何在SQL Server中搜索所有列 [英] how to search all column in Sql serever

问题描述

假设

有搜索功能.

Assume

there is search functionality.

EmpId [TextBox]
Ename [TextBox]
Dept  [TestBox]
 [Submit]

我如何搜索所有可选列.

就像

1.i只能搜索empid.
2.i只能搜索enamme.
3.我只能搜索部门.

数据库查询的样子.

how can i search all columns like optional.

like

1.i can search empid only.
2.i can search enamme only.
3. i can search dept only.

how the db query looks like.

Help me Techies.

推荐答案

请参阅w3schools.com的这些查询.您的查询将与这些相同. http://www.w3schools.com/sql/sql_where.asp [

See these queries form w3schools.com.Your query will be same like these..
http://www.w3schools.com/sql/sql_where.asp[^]

这篇关于如何在SQL Server中搜索所有列的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！