blocks|key|442048|text|你也可以试试ApexSQL+Search+--它是一个类似于SQL+Search的免费SSMS插件。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|442049|如果您真的只想使用SQL，则可能需要尝试以下脚本：|442050|select
S.name+as+[Schema],
o.name+as+[Object],
o.type_desc+as+[Object_Type],
C.text+as+[Object_Definition]
from+sys.all_objects+O+inner+join+sys.schemas+S+on+O.schema_id+=+S.schema_id
inner+join+sys.syscomments+C+on+O.object_id+=+C.id
where+S.schema_id+not+in+(3,4)+--+avoid+searching+in+sys+and+INFORMATION_SCHEMA+schemas
and+C.text+like+'%25ICE_%25'
order+by+[Schema]|code-block|syntax|javascript|442051|entityMap|0|LINK|mutability|MUTABLE|url|http://www.apexsql.com/sql_tools_search.aspx|1|https://en.wikipedia.org/wiki/Redgate#History|2|http://en.wikipedia.org/wiki/SQL_Server_Management_Studio^0|6|E|0|U|A|1|17|4|2|0|0|0^^$0|@$1|2|3|4|5|6|7|W|8|@]|9|@$A|X|B|Y|1|Z]|$A|10|B|11|1|12]|$A|13|B|14|1|15]]|C|$]]|$1|D|3|E|5|6|7|16|8|@]|9|@]|C|$]]|$1|F|3|G|5|H|7|17|8|@]|9|@]|C|$I|J]]|$1|K|3|-4|5|6|7|18|8|@]|9|@]|C|$]]]|L|$M|$5|N|O|P|C|$Q|R]]|S|$5|N|O|P|C|$Q|T]]|U|$5|N|O|P|C|$Q|V]]]]

You can also try <a href="http://www.apexsql.com/sql_tools_search.aspx" rel="nofollow noreferrer">ApexSQL Search</a> – it’s a free <a href="http://en.wikipedia.org/wiki/SQL_Server_Management_Studio" rel="nofollow noreferrer">SSMS</a> add-in similar to <a href="https://en.wikipedia.org/wiki/Redgate#History" rel="nofollow noreferrer">SQL Search</a>.

If you really want to use only SQL you might want to try this script:

<pre><code>select
S.name as [Schema],
o.name as [Object],
o.type_desc as [Object_Type],
C.text as [Object_Definition]
from sys.all_objects O inner join sys.schemas S on O.schema_id = S.schema_id
inner join sys.syscomments C on O.object_id = C.id
where S.schema_id not in (3,4) -- avoid searching in sys and INFORMATION_SCHEMA schemas
and C.text like '%ICE_%'
order by [Schema]
</code></pre>

blocks|key|656476|text|您可以将数据库(如果较小)导出到硬盘/桌面，然后只需通过文本搜索程序或文本编辑器进行字符串搜索。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|656477|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

You can export your database (if small) to your hard drive / desktop, and then just do a string search via a text search program or text editor.

blocks|key|656400|text|要在SQL+Server中按名称获取表：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|656401|SELECT+*
FROM+sys.Tables
WHERE+name+LIKE+'%25Employees%25'|code-block|syntax|javascript|656402|要按名称查找存储过程：|656403|SELECT+name
FROM+sys.objects
WHERE+name+=+'spName'|656404|要获取与表相关的所有存储过程：|656405|----Option+1
SELECT+DISTINCT+so.name
FROM+syscomments+sc
INNER+JOIN+sysobjects+so+ON+sc.id=so.id
WHERE+sc.TEXT+LIKE+'%25tablename%25'
----Option+2
SELECT+DISTINCT+o.name,+o.xtype
FROM+syscomments+c
INNER+JOIN+sysobjects+o+ON+c.id=o.id
WHERE+c.TEXT+LIKE+'%25tablename%25'|656406|entityMap^0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|R|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|S|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|T|8|@]|9|@]|A|$E|F]]|$1|K|3|L|5|6|7|U|8|@]|9|@]|A|$]]|$1|M|3|N|5|D|7|V|8|@]|9|@]|A|$E|F]]|$1|O|3|-4|5|6|7|W|8|@]|9|@]|A|$]]]|P|$]]

For getting a table by name in SQL&nbsp;Server:

<pre><code>SELECT *
FROM sys.Tables
WHERE name LIKE '%Employees%'
</code></pre>

For finding a stored procedure by name:

<pre><code>SELECT name
FROM sys.objects
WHERE name = 'spName'
</code></pre>

To get all stored procedures related to a table:

<pre><code>----Option 1
SELECT DISTINCT so.name
FROM syscomments sc
INNER JOIN sysobjects so ON sc.id=so.id
WHERE sc.TEXT LIKE '%tablename%'
----Option 2
SELECT DISTINCT o.name, o.xtype
FROM syscomments c
INNER JOIN sysobjects o ON c.id=o.id
WHERE c.TEXT LIKE '%tablename%'
</code></pre>

blocks|key|442230|text|我可以访问数据库，但不能访问我的查询所在的表。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|442231|受@marc_s+answer的启发，我看了一下HeidiSQL，它是一个可以处理MySQL、Server和PostgreSQL的程序。|offset|length|442232|我发现它还可以在数据库中搜索字符串。|442233|​|442234|📷|atomic|442235|442236|442237|442238|442239|它将搜索每个表，并给出每个表找到字符串的次数！|442240|entityMap|0|LINK|mutability|MUTABLE|url|https://stackoverflow.com/a/9188581/3357935|1|https://www.heidisql.com/|2|IMAGE|IMMUTABLE|imageUrl|https://ask.qcloudimg.com/http-save/yehe-900000/6d9499cad4a23f8142e77985faf7d4e3.png|imageAlt|3|https://ask.qcloudimg.com/http-save/yehe-900000/bc9c7909f03846b610b9be26e75b9d0c.png^0|0|1|D|0|O|8|1|0|0|0|0|1|2|0|0|0|0|1|3|0|0|0^^$0|@$1|2|3|4|5|6|7|1A|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|1B|8|@]|9|@$D|1C|E|1D|1|1E]|$D|1F|E|1G|1|1H]]|A|$]]|$1|F|3|G|5|6|7|1I|8|@]|9|@]|A|$]]|$1|H|3|I|5|6|7|1J|8|@]|9|@]|A|$]]|$1|J|3|K|5|L|7|1K|8|@]|9|@$D|1L|E|1M|1|1N]]|A|$]]|$1|M|3|I|5|6|7|1O|8|@]|9|@]|A|$]]|$1|N|3|I|5|6|7|1P|8|@]|9|@]|A|$]]|$1|O|3|K|5|L|7|1Q|8|@]|9|@$D|1R|E|1S|1|1T]]|A|$]]|$1|P|3|I|5|6|7|1U|8|@]|9|@]|A|$]]|$1|Q|3|R|5|6|7|1V|8|@]|9|@]|A|$]]|$1|S|3|-4|5|6|7|1W|8|@]|9|@]|A|$]]]|T|$U|$5|V|W|X|A|$Y|Z]]|10|$5|V|W|X|A|$Y|11]]|12|$5|13|W|14|A|$15|16|17|-4]]|18|$5|13|W|14|A|$15|19|17|-4]]]]

I was given access to a database, but not the table where my query was being stored in.

Inspired by <a href="https://stackoverflow.com/a/9188581/3357935">@marc_s answe</a>r, I had a look at <a href="https://www.heidisql.com/" rel="nofollow noreferrer">HeidiSQL</a> which is a Windows program that can deal with MySQL, SQL&nbsp;Server, and PostgreSQL.

I found that it can also search a database for a string.

<a href="https://i.stack.imgur.com/qJCGd.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/qJCGd.png" alt="Click Search, then Find text on Server"></a>

<a href="https://i.stack.imgur.com/O9ZmU.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/O9ZmU.png" alt="Search tool open. Make sure the DB is selected"></a>

It will search each table and give you how many times it found the string per table!

blocks|key|442077|text|这将在每个数据库中搜索一个字符串：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|442078|declare+@search_term+varchar(max)
set+@search_term+=+'something'

select+@search_term+=+'use+?+SET+QUOTED_IDENTIFIER+ON
select
++++''[''%2Bdb_name()%2B''].[''%2Bc.name%2B''].[''%2Bb.name%2B'']''+as+[object],
++++b.type_desc+as+[type],
++++d.obj_def.value(''.'',''varchar(max)'')+as+[definition]
from+(
++++select+distinct
++++++++a.id
++++from+sys.syscomments+a
++++where+a.[text]+like+''%25'%2B@search_term%2B'%25''
)+a
inner+join+sys.all_objects+b
++++on+b.[object_id]+=+a.id
inner+join+sys.schemas+c
++++on+c.[schema_id]+=+b.[schema_id]
cross+apply+(
++++select
++++++++[text()]+=+a1.[text]
++++from+sys.syscomments+a1
++++where+a1.id+=+a.id
++++order+by+a1.colid
++++for+xml+path(''''),+type
)+d(obj_def)
where+c.schema_id+not+in+(3,4)+--+avoid+searching+in+sys+and+INFORMATION_SCHEMA+schemas
++++and+db_id()+not+in+(1,2,3,4)+--+avoid+sys+databases'

if+object_id('tempdb..#textsearch')+is+not+null+drop+table+#textsearch
create+table+#textsearch
(
++++[object]+varchar(300),
++++[type]+varchar(300),
++++[definition]+varchar(max)
)

insert+#textsearch
exec+sp_MSforeachdb+@search_term

select+*
from+#textsearch
order+by+[object]|code-block|syntax|javascript|442079|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

This will search for a string over every database:

<pre><code>declare @search_term varchar(max)
set @search_term = 'something'

select @search_term = 'use ? SET QUOTED_IDENTIFIER ON
select
 ''[''+db_name()+''].[''+c.name+''].[''+b.name+'']'' as [object],
 b.type_desc as [type],
 d.obj_def.value(''.'',''varchar(max)'') as [definition]
from (
 select distinct
 a.id
 from sys.syscomments a
 where a.[text] like ''%'+@search_term+'%''
) a
inner join sys.all_objects b
 on b.[object_id] = a.id
inner join sys.schemas c
 on c.[schema_id] = b.[schema_id]
cross apply (
 select
 [text()] = a1.[text]
 from sys.syscomments a1
 where a1.id = a.id
 order by a1.colid
 for xml path(''''), type
) d(obj_def)
where c.schema_id not in (3,4) -- avoid searching in sys and INFORMATION_SCHEMA schemas
 and db_id() not in (1,2,3,4) -- avoid sys databases'

if object_id('tempdb..#textsearch') is not null drop table #textsearch
create table #textsearch
(
 [object] varchar(300),
 [type] varchar(300),
 [definition] varchar(max)
)

insert #textsearch
exec sp_MSforeachdb @search_term

select *
from #textsearch
order by [object]
</code></pre>

blocks|key|656866|text|如果我想找出我想要搜索的东西在哪里，我会使用以下命令：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|656867|DECLARE+@search_string++++varchar(200)
++++SET+@search_string+=+'%25myString%25'

++++SELECT+DISTINCT
+++++++++++o.name+AS+Object_Name,
+++++++++++o.type_desc,
+++++++++++m.definition
++++++FROM+sys.sql_modules+m
+++++++++++INNER+JOIN
+++++++++++sys.objects+o
+++++++++++++ON+m.object_id+=+o.object_id
+++++WHERE+m.definition+Like+@search_string;|code-block|syntax|javascript|656868|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

If I want to find where anything I want to search is, I use this:

<pre><code>DECLARE @search_string varchar(200)
 SET @search_string = '%myString%'

 SELECT DISTINCT
 o.name AS Object_Name,
 o.type_desc,
 m.definition
 FROM sys.sql_modules m
 INNER JOIN
 sys.objects o
 ON m.object_id = o.object_id
 WHERE m.definition Like @search_string;
</code></pre>

blocks|key|442269|text|下面是与submitted+by+user+l--''''''---------''''''''''''相同的脚本，但进行了更正，以便在区分大小写的SQL实例上工作，并进行了其他一些小的改进。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|442270|DROP+PROCEDURE+IF+EXISTS+dbo.spFind_Text_In_Database
GO

CREATE+PROCEDURE+dbo.spFind_Text_In_Database
++++@strText_To_Find+NVARCHAR(4000),
++++@bitExact_Match+BIT+=+0
AS
SET+NOCOUNT+ON

DECLARE+@Temp+TABLE(RowId+INT+IDENTITY(1,1),+SchemaName+sysname,+TableName+sysname,+ColumnName+SysName,+DataType+VARCHAR(100),+DataFound+BIT)

++++INSERT++INTO+@Temp(TableName,SchemaName,+ColumnName,+DataType)
++++SELECT++C.TABLE_NAME,+C.TABLE_SCHEMA,+C.COLUMN_NAME,+C.DATA_TYPE
++++FROM++++INFORMATION_SCHEMA.COLUMNS+AS+C
++++++++++++INNER+Join+INFORMATION_SCHEMA.TABLES+AS+T
++++++++++++++++ON+C.TABLE_NAME+=+T.TABLE_NAME
++++++++AND+C.TABLE_SCHEMA+=+T.TABLE_SCHEMA
++++WHERE+++TABLE_TYPE+=+'BASE+TABLE'
++++++++++++And+DATA_TYPE+In+('ntext','text','nvarchar','nchar','varchar','char')


DECLARE+@i+INT
DECLARE+@MAX+INT
DECLARE+@TableName+sysname
DECLARE+@ColumnName+sysname
DECLARE+@SchemaName+sysname
DECLARE+@SQL+NVARCHAR(4000)
DECLARE+@PARAMETERS+NVARCHAR(4000)
DECLARE+@DataExists+BIT
DECLARE+@SQLTemplate+NVARCHAR(4000)

SELECT++@SQLTemplate+=+CASE+WHEN+@bitExact_Match+=+1
++++++++++++++++++++++++++++THEN+'If+Exists(Select+*
++++++++++++++++++++++++++++++++++++++++++From+++ReplaceTableName
++++++++++++++++++++++++++++++++++++++++++Where++Convert(nVarChar(4000),+[ReplaceColumnName])
+++++++++++++++++++++++++++++++++++++++++++++++++++++++=+'''+%2B+@strText_To_Find+%2B+'''
++++++++++++++++++++++++++++++++++++++++++)
+++++++++++++++++++++++++++++++++++++Set+@DataExists+=+1
+++++++++++++++++++++++++++++++++Else
+++++++++++++++++++++++++++++++++++++Set+@DataExists+=+0'
++++++++++++++++++++++++++++ELSE+'If+Exists(Select+*
++++++++++++++++++++++++++++++++++++++++++From+++ReplaceTableName
++++++++++++++++++++++++++++++++++++++++++Where++Convert(nVarChar(4000),+[ReplaceColumnName])
+++++++++++++++++++++++++++++++++++++++++++++++++++++++Like+''%25'+%2B+@strText_To_Find+%2B+'%25''
++++++++++++++++++++++++++++++++++++++++++)
+++++++++++++++++++++++++++++++++++++Set+@DataExists+=+1
+++++++++++++++++++++++++++++++++Else
+++++++++++++++++++++++++++++++++++++Set+@DataExists+=+0'
++++++++++++++++++++++++++++END,
++++++++@PARAMETERS+=+'@DataExists+Bit+OUTPUT',
++++++++@i+=+1

SELECT+@i+=+1,+@MAX+=+MAX(RowId)
FROM+++@Temp

WHILE+@i+<=+@MAX
++++BEGIN
++++++++SELECT++@SQL+=+REPLACE(REPLACE(@SQLTemplate,+'ReplaceTableName',+QUOTENAME(SchemaName)+%2B+'.'+%2B+QUOTENAME(TableName)),+'ReplaceColumnName',+ColumnName)
++++++++FROM++++@Temp
++++++++WHERE+++RowId+=+@i


++++++++PRINT+@SQL
++++++++EXEC+sp_executesql+@SQL,+@PARAMETERS,+@DataExists+=+@DataExists+OUTPUT

++++++++IF+@DataExists+=1
++++++++++++UPDATE+@Temp+SET+DataFound+=+1+WHERE+RowId+=+@i

++++++++SET+@i+=+@i+%2B+1
++++END

SELECT++SchemaName,TableName,+ColumnName
FROM++++@Temp
WHERE+++DataFound+=+1
GO|code-block|syntax|javascript|442271|entityMap|0|LINK|mutability|MUTABLE|url|https://stackoverflow.com/questions/9185871/how-do-i-search-an-sql-server-database-for-a-string/9185923#9185923^0|4|1C|0|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@]|9|@$A|R|B|S|1|T]]|C|$]]|$1|D|3|E|5|F|7|U|8|@]|9|@]|C|$G|H]]|$1|I|3|-4|5|6|7|V|8|@]|9|@]|C|$]]]|J|$K|$5|L|M|N|C|$O|P]]]]

Here is the same script as <a href="https://stackoverflow.com/questions/9185871/how-do-i-search-an-sql-server-database-for-a-string/9185923#9185923">submitted by user l--''''''---------''''''''''''</a>, but corrected to work on a case-sensitive SQL instance, and with some other minor improvements.

<pre><code>DROP PROCEDURE IF EXISTS dbo.spFind_Text_In_Database
GO

CREATE PROCEDURE dbo.spFind_Text_In_Database
 @strText_To_Find NVARCHAR(4000),
 @bitExact_Match BIT = 0
AS
SET NOCOUNT ON

DECLARE @Temp TABLE(RowId INT IDENTITY(1,1), SchemaName sysname, TableName sysname, ColumnName SysName, DataType VARCHAR(100), DataFound BIT)

 INSERT INTO @Temp(TableName,SchemaName, ColumnName, DataType)
 SELECT C.TABLE_NAME, C.TABLE_SCHEMA, C.COLUMN_NAME, C.DATA_TYPE
 FROM INFORMATION_SCHEMA.COLUMNS AS C
 INNER Join INFORMATION_SCHEMA.TABLES AS T
 ON C.TABLE_NAME = T.TABLE_NAME
 AND C.TABLE_SCHEMA = T.TABLE_SCHEMA
 WHERE TABLE_TYPE = 'BASE TABLE'
 And DATA_TYPE In ('ntext','text','nvarchar','nchar','varchar','char')


DECLARE @i INT
DECLARE @MAX INT
DECLARE @TableName sysname
DECLARE @ColumnName sysname
DECLARE @SchemaName sysname
DECLARE @SQL NVARCHAR(4000)
DECLARE @PARAMETERS NVARCHAR(4000)
DECLARE @DataExists BIT
DECLARE @SQLTemplate NVARCHAR(4000)

SELECT @SQLTemplate = CASE WHEN @bitExact_Match = 1
 THEN 'If Exists(Select *
 From ReplaceTableName
 Where Convert(nVarChar(4000), [ReplaceColumnName])
 = ''' + @strText_To_Find + '''
 )
 Set @DataExists = 1
 Else
 Set @DataExists = 0'
 ELSE 'If Exists(Select *
 From ReplaceTableName
 Where Convert(nVarChar(4000), [ReplaceColumnName])
 Like ''%' + @strText_To_Find + '%''
 )
 Set @DataExists = 1
 Else
 Set @DataExists = 0'
 END,
 @PARAMETERS = '@DataExists Bit OUTPUT',
 @i = 1

SELECT @i = 1, @MAX = MAX(RowId)
FROM @Temp

WHILE @i &lt;= @MAX
 BEGIN
 SELECT @SQL = REPLACE(REPLACE(@SQLTemplate, 'ReplaceTableName', QUOTENAME(SchemaName) + '.' + QUOTENAME(TableName)), 'ReplaceColumnName', ColumnName)
 FROM @Temp
 WHERE RowId = @i


 PRINT @SQL
 EXEC sp_executesql @SQL, @PARAMETERS, @DataExists = @DataExists OUTPUT

 IF @DataExists =1
 UPDATE @Temp SET DataFound = 1 WHERE RowId = @i

 SET @i = @i + 1
 END

SELECT SchemaName,TableName, ColumnName
FROM @Temp
WHERE DataFound = 1
GO
</code></pre>

blocks|key|442318|text|下面是如何使用FMDB库在Swift中搜索数据库。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|442319|首先，转到此链接并将其添加到您的项目中：FMDB。当你做到这一点后，下面就是你如何做到这一点。例如，您有一个名为Person的表，您有firstName和secondName，并且您想要按名字查找数据，以下是相应的代码：|offset|length|442320|++++func+loadDataByfirstName(firstName+:+String,+completion:+@escaping+CompletionHandler){
++++if+isDatabaseOpened+{
++++++++let+query+=+"select+*+from+Person+where+firstName+like+'\(firstName)'"
++++++++do+{
++++++++++++let+results+=+try+database.executeQuery(query,+values:+[firstName])
++++++++++++while+results.next()+{
++++++++++++++++let+firstName+=+results.string(forColumn:+"firstName")+??+""
++++++++++++++++let+lastName+=+results.string(forColumn:+"lastName")+??+""
++++++++++++++++let+newPerson+=+Person(firstName:+firstName,+lastName:+lastName)
++++++++++++++++self.persons.append(newPerson)
++++++++++++}
++++++++++++completion(true)
++++++++}catch+let+err+{
++++++++++++completion(false)
++++++++++++print(err.localizedDescription)
++++++++}
++++++++database.close()
++++}
}|code-block|syntax|javascript|442321|然后，在您的ViewController中，您将编写以下代码来查找您要查找的人员详细信息：|442322|++override+func+viewWillAppear(_+animated:+Bool)+{
+++++super.viewWillAppear(animated)
++++++SQLManager.instance.openDatabase+{+(success)+in
++++++++if+success+{
++++++++++++SQLManager.instance.loadDataByfirstName(firstName:+"Hardi")+{+(success)+in
++++++++++++++++if+success+{
++++++++++++++++++++//+You+have+your+data+Here
++++++++++++++++}
++++++++++++}
++++++++}
++++}
}|442323|entityMap|0|LINK|mutability|MUTABLE|url|https://github.com/ccgus/fmdb^0|0|K|4|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|W|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|X|8|@]|9|@$D|Y|E|Z|1|10]]|A|$]]|$1|F|3|G|5|H|7|11|8|@]|9|@]|A|$I|J]]|$1|K|3|L|5|6|7|12|8|@]|9|@]|A|$]]|$1|M|3|N|5|H|7|13|8|@]|9|@]|A|$I|J]]|$1|O|3|-4|5|6|7|14|8|@]|9|@]|A|$]]]|P|$Q|$5|R|S|T|A|$U|V]]]]

Here is how you can search the database in Swift using the FMDB library.

First, go to this link and add this to your project: <a href="https://github.com/ccgus/fmdb" rel="nofollow noreferrer">FMDB</a>. When you have done that, then here is how you do it. For example, you have a table called Person, and you have firstName and secondName and you want to find data by first name, here is a code for that:

<pre><code> func loadDataByfirstName(firstName : String, completion: @escaping CompletionHandler){
 if isDatabaseOpened {
 let query = "select * from Person where firstName like '\(firstName)'"
 do {
 let results = try database.executeQuery(query, values: [firstName])
 while results.next() {
 let firstName = results.string(forColumn: "firstName") ?? ""
 let lastName = results.string(forColumn: "lastName") ?? ""
 let newPerson = Person(firstName: firstName, lastName: lastName)
 self.persons.append(newPerson)
 }
 completion(true)
 }catch let err {
 completion(false)
 print(err.localizedDescription)
 }
 database.close()
 }
}
</code></pre>

Then in your ViewController you will write this to find the person detail you are looking for:

<pre><code> override func viewWillAppear(_ animated: Bool) {
 super.viewWillAppear(animated)
 SQLManager.instance.openDatabase { (success) in
 if success {
 SQLManager.instance.loadDataByfirstName(firstName: "Hardi") { (success) in
 if success {
 // You have your data Here
 }
 }
 }
 }
}
</code></pre>

I know it's possible, but I don't know how.

I need to search an SQL&nbsp;Server database for all mentions of a specific string.

For example: I would like to search all tables, views, functions, stored procedures, ... for string "tblEmployes" (not data within the tables).

One of the reasons I need this is I would like to remove some extra data tables that are created, but I am afraid that they are maybe used somewhere in procedures or functions.

How do I search an SQL Server database for a string?

我知道这是可能的，但我不知道怎么做。我需要在SQL Server数据库中搜索特定字符串的所有提法。例如:我想搜索所有的表，视图，函数，存储过程，...对于字符串"tblEmployes“(不是表中的数据)。我需要这样做的原因之一是我想删除一些额外创建的数据表，但我担心它们可能在过程或函数中的某个地方使用。

问如何在SQL Server数据库中搜索字符串？
EN

回答 8

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何在SQL Server数据库中搜索字符串？EN

回答 8

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何在SQL Server数据库中搜索字符串？
EN