Forum Replies Created

Viewing 5 posts - 1 through 5 (of 5 total)

  • Reply To: The Developer Arguments for Stored Procedures

    In my understanding, around 2005 people started to notice that developers were putting business logic in stored procedures, and they advised against this practice. When this advice was picked up,...

    March 6, 2020 at 6:38 am

    #3731791

  • Reply To: The Sequel to SQL

    It's not about marketing vs developers. Not at all. It's not about doing away with the need for skilled professional developers. It's about getting things done.

    Information systems design is primarily...

    August 10, 2019 at 4:26 pm

    #3670495

  • Reply To: You're not really that good at SQL Server

    The longer I am in life, the more I think that many men don't learn to be good fathers. They learn just enough to solve the problems they face and...

    April 8, 2019 at 1:12 pm

    #3015068

  • RE: Data Profiling with T-SQL

    Two more errors I ran into:

    (1) Line 217 and 218 read
    ,MAX(' + QUOTENAME(@COLUMN_NAME) + ')
    ,MIN(' + QUOTENAME(@COLUMN_NAME) + ')
    I...

    January 17, 2019 at 7:16 am

    #2019204

  • RE: Data Profiling with T-SQL

    The ISDATE function does not work for columns with long texts. 

    When I replaced 

            WHERE ISDATE(' + QUOTENAME(@COLUMN_NAME) + ') = 1)

    by

    January 16, 2019 at 12:48 pm

    #2019136

Viewing 5 posts - 1 through 5 (of 5 total)