Forum Replies Created

Viewing 15 posts - 1,636 through 1,650 (of 3,348 total)

  • RE: Expressions

    srienstr (8/8/2013)

    select checksum('00000000-0000-0000-0000-000000000000')

    -1448389036

    You're calculating the checksum of a value that just happens to loook remarkably like a uniqueidentifier value - but is just a plain old varchar.

    select checksum(cast('00000000-0000-0000-0000-000000000000' as uniqueidentifier)...

    August 8, 2013 at 6:42 am

    #1639726

  • RE: Expressions

    Good question!

    *kicks self* - I knew this, have been bitten by it before, and STILL managed to get it wrong. Obviously need to be bittenn a lot more before it...

    August 8, 2013 at 4:21 am

    #1639666

  • RE: Exists

    jarid.lawson (8/7/2013)

    I decided to run this on my system, and I did receive an error (see attachment). Since this will not be bothering us much longer I am curious what...

    August 7, 2013 at 1:02 pm

    #1639524

  • RE: Exists

    mtassin (8/7/2013)

    tell me Hugo, do you put commas at the end or beginning of a line?

    Sorry, missed that question earlier.

    I try to get myself to put the comma's at the...

    August 7, 2013 at 12:53 pm

    #1639520

  • RE: Exists

    Michael_Garrison (8/7/2013)

    Good question. I missed this because on SQL 2008 R2 I get error with 'c.ID could not be bound'. So I picked SQL would return an error. Obviously...

    August 7, 2013 at 10:49 am

    #1639476

  • RE: Exists

    Danny Ocean (8/6/2013)

    Most of time i try to avoid Exists clause. I will prefer join or sub query.

    Good question 🙂

    Exists IS (or rather, uses) a subquery. If you mean that...

    August 7, 2013 at 2:10 am

    #1639250

  • RE: Between Clause

    Naveen PK (8/5/2013)

    If 'order by 1 ' is commented/removed, I still get same result set in different order.

    In other words wrt to performance, does Between puts the column in...

    August 5, 2013 at 3:06 pm

    #1638751

  • RE: The Human Touch

    Shawn Richards (8/4/2013)

    I don't disagree. However bad code that runs and fulfills the requirements which are set out is not buggy it is just bad. I did go on to...

    August 4, 2013 at 4:40 pm

    #1638501

  • RE: The Human Touch

    patrickmcginnis59 10839 (8/1/2013)

    whereas Hugo is stuck repeating all that analysis and synthesis DURING EACH MANUAL RUN OF HIS TASK.

    Heh! You must have misunderstood my point. I never said I am...

    August 1, 2013 at 8:18 am

    #1637803

  • RE: LEN and CONVERT

    PHYData DBA (8/1/2013)

    I'll just let the code speak for itself.

    Have Fun! 😎

    EDIT - Watch how datalength changes on the string variable.

    This time I remembered to refresh before posting. And a...

    August 1, 2013 at 7:36 am

    #1637790

  • RE: LEN and CONVERT

    PHYData DBA (8/1/2013)

    Phillip would you mind posting a link to the article your quote comes from? I not trying to say anyone is right or wrong. I am...

    August 1, 2013 at 7:02 am

    #1637774

  • RE: The Human Touch

    I understand what you're saying, Steve. But there is also another side to the equation.

    First, on using the script button in SSMS.

    Using this button to generate code can be dangerous...

    August 1, 2013 at 1:53 am

    #1637679

  • RE: LEN and CONVERT

    john.arnott (7/31/2013)

    L' Eomot Inversé (7/30/2013)

    ...... The question is about the lengths of the strings to which the numeric values are implicitly converted, since the length operator used is...

    August 1, 2013 at 1:37 am

    #1637678

  • RE: DBCC CHECKDB

    karuppusamy.kk (7/31/2013)

    Please clarify my following concern about this question..

    Why not DBCC CHECKIDENT?

    The short and simple answer: because Microsoft didn't build DBCC CHECKDB to include CHECKIDENT.

    The longer and more useful answer:...

    July 31, 2013 at 2:34 am

    #1637267

  • RE: T-SQL 2012 #2

    koteswararao.mca10 (7/30/2013)

    Chose function is not recognized built in function

    It is in SQL Server 2012.

    July 30, 2013 at 1:07 am

    #1636849

Viewing 15 posts - 1,636 through 1,650 (of 3,348 total)