Re: Finding data

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

From: Hamilton (hamilton_at_polese.com)
Date: 04/02/04 

Date: Fri, 2 Apr 2004 13:25:11 -0800

Thanks Mark

"Mark Allison" <marka@no.tinned.meat.mvps.org> wrote in message
news:D3376437-D5CE-441C-8A86-3948921C9CB6@microsoft.com...
Hamilton,

You could develop your own stored procedure by iterating through the
COLUNM_NAME of the system INFORMATION_SCHEMA.COLUMNS view. This will require
a cursor. Any matches should also display the table name, owner and column
name. A proc might exist on the web somewhere to do this, there is nothing
native to SQL Server that will do this currently. Be aware that such a
search could take a very, very long time to complete as you will be table
scanning every table in your database.

Try and design your proc so that you are are only doing one table scan per
table, and not one table scan per column - that should keep the already bad
performance to a minimum. 

--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk

Relevant Pages

  • Re: Text file inported to sql2005 table
    ... It's not the issue of display length. ... cursor out, it shows the entire row again. ... When I use sql query analyzer to select, I don't see the who field. ... Links for SQL Server Books Online: ...
    (microsoft.public.sqlserver.security)
  • Re: Error adding command properties for stored procedure call
    ... I see you are using the SQL Native Client for SQL Server ... A server cursor is not allowed on a remote stored procedure or stored ... The stored procedure called is a test one that simply SELECTs the name field ... int InitializeAndConnect; ...
    (microsoft.public.data.oledb)
  • Row by Row Operations Help req
    ... Create temp table 1 ... Nigel,The cursor question is the SQL equivalent of the GOTOs / NO GOTOs ... question about whether the familiarity of procedural code is worth the ... leverages the strengths of SQL Server and is usually faster since it uses ...
    (microsoft.public.sqlserver.programming)
  • Re: Strange Recordset/Query Problem
    ... > display in SQL Server. ... table names for each field in the SELECT clause, ON clauses, and WHERE ... Also, SQL Server is not case sensitive, so you can save your eyes by using ... the IF statement executes the first condition as it should, ...
    (microsoft.public.inetserver.asp.general)
  • Re: How to suppress those messages [404] etc
    ... Though I suspect that your PROC is running the SELECT statement and the LIST ... DISPLAY VENDOR PRICE DETAILS ... so that people get a visual feedback that things are happening. ... John Marshall ...
    (comp.databases.pick)