Forum Replies Created

Viewing 15 posts - 481 through 495 (of 645 total)

  • RE: Explanation of LIKE '%[0-9]%'?

    DataAnalyst011 (6/27/2013)

    From time to time I need to check if a column is completely numeric (or usually, check for the row contain something other than numeric). I've read the ISNUMERIC...

    July 27, 2013 at 5:17 pm

    #1636432

  • RE: Display More Than 8000 Characters (SQL Spackle)

    opc.three (7/1/2013)

    I think you have added an abstraction layer that seems to work but at the end of the day you still have an entitization problem:

    My problem seems to have...

    July 1, 2013 at 9:30 pm

    #1628893

  • RE: Display More Than 8000 Characters (SQL Spackle)

    opc.three (7/1/2013)

    SELECT CAST('>>' AS XML) AS [Search and Replace?];

    Well, yes and no ;-).

    Yes = in that scenario it would be impossible to get back to the source string.

    No = that...

    July 1, 2013 at 4:34 pm

    #1628856

  • RE: Display More Than 8000 Characters (SQL Spackle)

    opc.three (6/30/2013)

    I only meant to show the two characters that would be escaped when casting to the XML data type.

    Thanks for the code samples Solomon. I ran a few tests...

    July 1, 2013 at 11:46 am

    #1628803

  • RE: Display More Than 8000 Characters (SQL Spackle)

    opc.three (6/29/2013)

    Solomon Rutzky (6/29/2013)

    This is a little more flexible, and straight-forward, than using FOR XML as that might not be desirable when debugging a query.

    As with most solutions to a...

    June 30, 2013 at 3:10 pm

    #1628568

  • RE: Display More Than 8000 Characters (SQL Spackle)

    rac.coons (6/28/2013)

    Here's a very quick and easy way to display all characters that I did not see here.

    select convert(xml,'<txt>' + @txt + '</txt>')

    In SSMS, it returns a link that opens...

    June 29, 2013 at 3:03 pm

    #1628511

  • RE: Temporary Stored Procedures

    cschlieve (6/25/2013)

    How would you use them. I cannot think of a case where this would be useful?

    Global Temporary Stored Procedures are very helpful when testing updated code in Production,...

    June 27, 2013 at 7:12 am

    #1627947

  • RE: Why doesn’t ISNUMERIC work correctly? (SQL Spackle)

    Jeff Moden (4/16/2013)

    ...Technically (although I do agree that it would be easier in Regex), it's also NOT the fault of LIKE conditions because if you forget to accurately define the...

    April 17, 2013 at 4:11 pm

    #1607473

  • RE: Why doesn’t ISNUMERIC work correctly? (SQL Spackle)

    Lynn Pettis (4/16/2013)

    Solomon Rutzky (4/16/2013)

    Hugo Kornelis (4/16/2013)

    mark.gilbert (4/16/2013)

    Am I missing something, or is this the exception to the rule?

    What Lynn said. 🙂

    For ensuring that the empty string is not treated...

    April 16, 2013 at 4:15 pm

    #1607078

  • RE: Why doesn’t ISNUMERIC work correctly? (SQL Spackle)

    Hugo Kornelis (4/16/2013)

    mark.gilbert (4/16/2013)

    Am I missing something, or is this the exception to the rule?

    What Lynn said. 🙂

    For ensuring that the empty string is not treated as numeric, I would...

    April 16, 2013 at 3:20 pm

    #1607061

  • RE: Life is Like a Manure Spreader

    Steve, since you mentioned your kids I immediately thought of "The Zax" by Dr. Seuss. It is the 2nd story in _Sneetches and other Stories_ and is exactly about...

    February 20, 2013 at 9:05 am

    #1589600

  • RE: Disk Is Cheap! ORLY?

    Jeff Moden (10/5/2012)

    Solomon,

    I've recently had the need to refer to this article again and I thank you from the bottom of my heart. This "right sizing on steroids" article...

    November 5, 2012 at 7:42 am

    #1556053

  • RE: Questioning the Interviewer

    Steve Jones wrote:

    The interview is your best chance to determine if the position is a good fit for you and the company

    As Steve, and a few other commenters above, said:...

    October 15, 2012 at 7:25 am

    #1549124

  • RE: Restructure 100 Million Row (or more) Tables in Seconds. SRSLY!

    derek.colley (10/5/2012)

    An excellent article that applies a common-sense approach to doing these kinds of changes. It does rely of course on sufficient resources to allow this approach to take...

    October 5, 2012 at 5:59 am

    #1546010

  • RE: Stack Ranking

    j_e_o (7/20/2012)

    I absolutely would not want to work in a company that uses a stack ranking system. Unfortunately, I do work for such a company.

    Well said ;-). And I...

    July 21, 2012 at 3:09 pm

    #1515888

Viewing 15 posts - 481 through 495 (of 645 total)