使用存储过程搜索数据库表的最佳方法是什么？

I want to know what's the best way to search a DB table using a stored procedure (let's say text search)?

我想知道使用存储过程搜索数据库表的最佳方法是什么(让我们说文本搜索)?

What are the points I should look at?

我应该注意哪些要点?

Let me know if you guys want more information.

如果你们想要更多信息,请告诉我。

1 个解决方案

This query will give you list of tables whose name matches to your keyword

此查询将为您提供名称与关键字匹配的表的列表

SELECT name FROM sysobjects WHERE xtype = 'U' AND name LIKE '%keyword%'

SELECT name FROM sysobjects WHERE xtype ='U'AND name LIKE'%keyword%'

This query will give you list of tables whose name matches to your keyword

此查询将为您提供名称与关键字匹配的表的列表

SELECT name FROM sysobjects WHERE xtype = 'U' AND name LIKE '%keyword%'

SELECT name FROM sysobjects WHERE xtype ='U'AND name LIKE'%keyword%'