| Author |
Search tool for SQL
|
|
|
| There are a few people at my company that are not familiar with SQL, but it
would be benificial if they were able to search for text within a database
and report on tables. Is there a freeware tool out there that will connect
to a sql db and allow you to search for text?
Thanks
| |
| MJKulangara 2006-02-03, 1:23 pm |
| Do you mean search for text in data ...ie in a table ?
If you just need to search ddl...
This query would work...
select * from syscomments
where text like '%whatever%'
HTH
MJKulangara
http://sqladventures.blogspot.com
| |
|
| Yes, they would be searching for text in a table. I'd like to avoid having
to use queries and would prefer a stand alone application that could connect
to the db and provide search fuctionallity.
Thanks
"MJKulangara" <RutgersDBA@gmail.com> wrote in message
news:1138992074.992386.270080@z14g2000cwz.googlegroups.com...
> Do you mean search for text in data ...ie in a table ?
>
> If you just need to search ddl...
>
> This query would work...
>
> select * from syscomments
> where text like '%whatever%'
>
> HTH
>
> MJKulangara
> http://sqladventures.blogspot.com
>
| |
|
| Try a search with these terms: graphical query builder freeware
"BA" <none@none.com> wrote in message
news:AzNEf.9722$VV4.160673@ursa-nb00s0.nbnet.nb.ca...
> Yes, they would be searching for text in a table. I'd like to avoid
having
> to use queries and would prefer a stand alone application that could
connect
> to the db and provide search fuctionallity.
>
| |
| Sassan Karai 2006-02-03, 8:23 pm |
| You may want to look into Full Text Search (available with SQL server)
Below a starting point
http://msdn2.microsoft.com/en-us/library/ms142545.aspx
Sassan
"BA" wrote:
> There are a few people at my company that are not familiar with SQL, but it
> would be benificial if they were able to search for text within a database
> and report on tables. Is there a freeware tool out there that will connect
> to a sql db and allow you to search for text?
>
> Thanks
>
>
>
| |
| Achim Stein [MCT] 2006-02-04, 8:23 pm |
| Hi,
ever thought about an Access .adp Project?
With "form based Filter" you can do a lot. Even fulltext search.
Achim
"BA" <none@none.com> schrieb im Newsbeitrag
news:ulNEf.9706$VV4.160280@ursa-nb00s0.nbnet.nb.ca...
> There are a few people at my company that are not familiar with SQL, but
> it would be benificial if they were able to search for text within a
> database and report on tables. Is there a freeware tool out there that
> will connect to a sql db and allow you to search for text?
>
> Thanks
>
|
|
|
|