Forum Replies Created

Viewing 15 posts - 16 through 30 (of 106 total)

  • RE: HOW TO FIND A VALUE IN ALL COLUMN OF ALL TABLE IN A db.

    Ivan Mohapatra (1/12/2012)

    This is how it look after changing but can i confined the search to 9 digit like the

    SearchAllTablesAllColumns '5________' as when i tried it IT shows alphabet...

    January 12, 2012 at 5:36 am

    #1432383

  • RE: HOW TO FIND A VALUE IN ALL COLUMN OF ALL TABLE IN A db.

    Ivan Mohapatra (1/12/2012)

    Steve Jones - SSC Editor (1/9/2012)

    Use a script like this: http://www.sqlservercentral.com/scripts/Miscellaneous/65769/

    Change the where from a "column like @value" to "datalength(column) = 9"

    If you want 9 digit values.

    You...

    January 12, 2012 at 4:34 am

    #1432361

  • RE: HOW TO FIND A VALUE IN ALL COLUMN OF ALL TABLE IN A db.

    Ivan,

    please check out BOL on SUBSTRING and you'll find out that this command will only work with STRINGS, but not with numeric values.

    Just remove the SUBSTRING section from the last...

    January 12, 2012 at 4:17 am

    #1432353

  • RE: HOW TO FIND A VALUE IN ALL COLUMN OF ALL TABLE IN A db.

    You may also want to try the following code; modified it to what I believe is what you want--I originally created this one to detect all TEXT fields in a...

    January 10, 2012 at 3:53 am

    #1430973

  • RE: Numbers

    Stuart Davies (1/4/2012)

    Dave62 (1/4/2012)

    Here's another beauty.

    Select ISNUMERIC('£,,1.,') As "String";

    Still returns a 1 :crazy:

    Based on Jeff Moden's SQL Spackle on ISNUMERIC[/url], any of these characters evaluates to 1; so I'd assume...

    January 5, 2012 at 3:17 am

    #1428863

  • RE: Numbers

    Stuart Davies (1/4/2012)

    Know what you mean Tom - but I took the wording straight from BOL (I know, a scarely used resource 🙂 ) to try and avoid any arguments

    For...

    January 4, 2012 at 8:55 am

    #1428393

  • RE: DATETIME 1

    ma-516002 (12/7/2011)

    Great question, but the answer is language dependant since outside the us at first glance '01-08-2011' reads 1st of August 😉

    Fully agree--thus I'd always be in favor of ISO...

    December 7, 2011 at 1:47 am

    #1417843

  • RE: Complex joins

    SQL Kiwi (12/6/2011)

    Hi Hugo,

    Writing a question to demonstrate the equivalence of SQL expressions is very brave, so well done for that. Small point: in the explanation you say, "the...

    December 6, 2011 at 5:21 am

    #1417261

  • RE: Complex joins

    Thanks for a great brain teaser--got my analytical half started this morning. Wonderful 🙂

    December 6, 2011 at 1:46 am

    #1417137

  • RE: Variant Order 2

    Thanks for a very interesting question.

    Got it right by a wrong assumption 🙂

    Figured that Latin1_General_100_CI_AS will always be the "first" and prevailing collation (and hence picked the only option having...

    December 5, 2011 at 5:20 am

    #1416599

  • RE: MERGE with ANSI

    Stewart "Arturius" Campbell (11/25/2011)

    This was quite a tough one.

    Learned a fair bit about the origin of the MERGE statement from this.

    I definitely second this.

    Some may argue it's cheating to do...

    November 25, 2011 at 2:20 am

    #1412896

  • RE: ISNULL

    archie flockhart (11/23/2011)

    Also, maybe this is maybe not the place to debate this, but is "researching" the question before answering really in the spirit of the QOTD ? Is...

    November 23, 2011 at 5:08 am

    #1412069

  • RE: ISNULL

    Hugo Kornelis (11/23/2011)

    [...] Anyway, since I investigated this before answering I can now affirm that this behaviour is explicitly documented in the CAST and CONVERT topic in Books Online.

    Thanks to...

    November 23, 2011 at 4:06 am

    #1412048

  • RE: Do You Want to be a DBA in Space?

    Too bad :(--while I've already answered all the questions correctly, I cannot apply to be sent into space. I definitely would opt for the space flight. Since I was a...

    November 16, 2011 at 6:11 am

    #1408430

  • RE: Mirroring

    Thanks for this question.

    As usually, the devil is in the details--should have read the question properly before answering :Whistling:

    November 4, 2011 at 2:49 am

    #1403106

Viewing 15 posts - 16 through 30 (of 106 total)