Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
usafelix
Posting Yak Master
165 Posts |
Posted - 2014-09-05 : 00:07:33
|
I would like to search the text "apple" , but I have many query progam and not sure which query will using this text. where the sql query have this text ? please give a query for this find function ? |
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2014-09-05 : 00:30:29
|
do a search in your client application development environmentor if you mean searching the stored procedure etc in the Database thenSELECT object_name(m.object_id), definitionFROM sys.sql_modules m WHERE m.definition like '%apple%' KH[spoiler]Time is always against us[/spoiler] |
|
|
|
|
|