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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-07-02 : 08:20:01
|
bob writes "Good Morning SQL Team,
The following article: http://www.sqlteam.com/item.asp?ItemID=239
(
Let's look at an example using the PUBS database. Let's suppose you want wanted to build an address book application that would search the AUTHORS table and the EMPLOYEE table based on last name. Your initial query would look something like this:
SELECT au_lname FROM authors UNION ALL SELECT lname FROM Employee ORDER BY au_lname
)
was helpful however, I would like to search for *ABC* in all tables with SQL Sever. Similar to the Find command in NT where I can search for all text files that contain a particular string.
Thanks in advance for your time and patience.
bob" |
|
|
|
|
|
Search all system and user tables for specific data.