Re: Can I search a certain text in a SQL SERVER db?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Lance Wynn (lance_wynn_at_N.O.S.P.A.M.hotmail.com)
Date: 01/19/05

  • Next message: Jamie MacLennan \(MS\): "Re: accessing data mining model via web/PDA" 
    Date: Tue, 18 Jan 2005 20:22:01 -0700

    If you don't know the table and field names, and you want to search for text
    within the tables, you could query for the table and field names, and then
    determine which fields can contain text, and build dynamic query based on
    that. I don't know how well it will work though, I have never attempted
    anything like this before.

    "creative" <creativebyte@hotmail.com> wrote in message
    news:e$MulNc$EHA.3592@TK2MSFTNGP09.phx.gbl...
    what if I do not know these table names and field names?

    "Lance Wynn" <lance_wynn@N.O.S.P.A.M.hotmail.com> дÈëÓʼþ
    news:utmWcrX$EHA.1084@tk2msftngp13.phx.gbl...
    > You can, look into Unions. When you specify a table in a database, use
    the
    > full name (database.dbo.table)
    >
    >
    >
    > "creative" <creativebyte@hotmail.com> wrote in message
    > news:ejfPpxR$EHA.3616@TK2MSFTNGP11.phx.gbl...
    > There are many db in my machine.
    > Can I search a certain text among those dbs?
    >
    >
    >

  • Next message: Jamie MacLennan \(MS\): "Re: accessing data mining model via web/PDA"

    Relevant Pages

    • Re: DBMS and lisp, etc.
      ... Naively implemented with SQL, again for 10 ... (1 query for the initial orders, 1 query for each order for its ... soon as you upgrade to the SQL database. ... (eq (order-customer orderA) ...
      (comp.lang.lisp)
    • Re: OT: SQL
      ... query processing. ... FROM Employees e, Employees m, Management mgt ... Manager and Employee Salaries. ... The scheme used does not model database files in general, ...
      (sci.logic)
    • Re: access 2003
      ... I removed the parameters from the form query source. ... boxes from the form header, events, code, etc and ran the form query source ... forms queries and the SQL because syntax of the SQL will change randomly. ... the Access 97 database, I wouldn't have thought any expressions would be ...
      (microsoft.public.access.conversion)
    • RE: Import external data - web query
      ... Your reply for my query is very extensive, this is for importing a file from ... The data source I want isn't listed in the Select Data Source dialog box. ... information used to connect to a database. ... Check your driver First, make sure you have the right ODBC driver (Open ...
      (microsoft.public.excel.misc)
    • Re: Using a Select Query to build a MDB table from a Fox table
      ... MS Access has a 'make-table' query with IN clause you can specify ... As you said the IN <database> clause is specific to Access SQL. ...
      (microsoft.public.fox.helpwanted)