Forum Replies Created

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

  • RE: How to compare SQL databases ?

    You could query the metadata between their systems and yours to look for differences. To compare data types, run something like this on each system and compare results:

    February 7, 2019 at 8:35 am

    #2021404

  • RE: ORDER BY affecting query against my view

    I'm reporting the response times from the report server log; never actually had the patience to get actual plan yet. Estimated plan is same for both with or without ORDER...

    July 13, 2011 at 12:00 pm

    #1352340

  • RE: Best Way to Calculate Age

    The logic in the third statement does not properly relate the day of the month to the month of the year. It should read:

    select DATEDIFF(yy, BirthDate, GETDATE())

    - CASE

    WHEN...

    March 6, 2008 at 8:02 am

    #786001

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