How to search through the whole Database?

Welcome to dbFreaks.com!

FAQ

Search

Profile

Private Messages

How to search through the whole Database?

Database Help (Home) -> Server

Next: AdventureWorks won't attach

Author

Message

Zaur Bahramov

External

Since: Jun 10, 2008
Posts: 63

(Msg. 1) Posted: Wed Jun 11, 2008 10:51 am
Post subject: How to search through the whole Database?
Archived from groups: microsoft>public>sqlserver>server (more info?)

Hi!

is there a way to run a query that will search through my entire database
for a specific word?

>> Stay informed about: How to search through the whole Database?

Login to vote

Uri Dimant

External

Since: Aug 24, 2003
Posts: 1744

(Msg. 2) Posted: Wed Jun 11, 2008 12:15 pm Post subject: Re: How to search through the whole Database? [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)

Hi http://vyaskn.tripod.com/search_all_columns_in_all_tables.htm "Zaur Bahramov" wrote in message > Hi! > > is there a way to run a query that will search through my entire database > for a specific word? > > >> Stay informed about: How to search through the whole Database?

Login to vote

corey bui

External

Since: Dec 08, 2010
Posts: 1

(Msg. 3) Posted: Wed Dec 08, 2010 7:07 pm Post subject: Re: How to search through the whole Database? [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)

Search sql server database for text, dates, numbers, xml, etc. using SQL Locator. Search results can be replaced, removed, saved, and shared. sql search engine for SQL Server 2008 and SQL Server 2005. http://www.SQLLocator.com > On Wednesday, June 11, 2008 4:51 AM Zaur Bahramov wrote: > Hi! > > is there a way to run a query that will search through my entire database > for a specific word? >> On Wednesday, June 11, 2008 5:15 AM Uri Dimant wrote: >> Hi >> http://vyaskn.tripod.com/search_all_columns_in_all_tables.htm >> Submitted via EggHeadCafe >> Microsoft LINQ Query Samples For Beginners >> http://www.eggheadcafe.com/training-topic-area/LINQ-Standard-Query-Ope...ors/33/ >> Stay informed about: How to search through the whole Database?

Login to vote

Display posts from previous:

Related Topics:

Search using a VarBinary - All, Is it possible to use a varbinary column as a search field in the where clause? I have encrypted a social security number into a varbinary data type and I want to search the table by the value. Is this possible? Thanks Mike

Search and replace - Hi, Here is the sample of the data from one column(ClassDID) in my table (CLASS): DB1-A07\CASCLASS_DATA DB1-A07\CASCLASS_SUB DB1-A07\PCLASS_DATA DB1-A07\POSCLASS_SUB DB1-A07\RATS_DATA DB1-A07\STALASS_DATA DB1-A07\TLASS_DATA DB1-A07\TASS_SUB..

TSQL = LIKE search statement for a '%@%' - Does anybody know why searching for a string '@' with LIKE does not work even when you use ESCAPE Very strange...... Say the field has ..... I love my @*&!& friend And I want to SELECT this row when I search for @ with LIKE Select * from myT...

Dynamic Search Conditions - In Erlag S's article Dynamic Search Conditions (which is excellent), in the section that describes WHERE (key1 = @Key1 OR @Key1 IS NULL) AND (key2 = @Key2 OR @Key2 IS NULL) it says "This procedure will never use any selective index, but you w...

Full text search in albanian - Hello everyone, I'm trying to implement full-text search for the albanian language. What's the best way to implement it? Based on my current understanding the most feasible way is to: 1. Use one of the supported lnaguages, for example Turkish. 2...

	Database Help (Home) -> Server	All times are: Pacific Time (US & Canada)
Page 1 of 1

You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum

[ Contact us | Terms of Service/Privacy Policy ]