Forum Replies Created

Viewing 15 posts - 1 through 15 (of 78 total)

  • Reply To: No record in an UNION query

    The UNION part of this really shouldn't make a difference as the results from the two queries are differentiated by the 'Cie1' and 'Cie2' fixed column values.

    This means that whatever...

  • Reply To: Redistributing Data Across Files

    Nice description of a useful but not as simple as it appears topic. Thanks.

     

    Minor thing, the image with the caption "There has been a little movement, as my new files...

  • Reply To: The Dangers When Changing Database File Names

    Please do not forget non-English installations. This example will not work with them and the environment variables %ProgramFiles% should be used because on non-English systems there may not be a...

    • This reply was modified 2 years, 3 months ago by  Nick Ryan.
  • Reply To: Sorting Months By Number (SQL Spackle)

    As this article has been resurrected from the distant past, how about amending the article to show the rather more efficient and slightly more obvious looking use of the MONTH()...

  • RE: No More SQL Server Installs

    steve.powell 14027 - Wednesday, March 27, 2019 2:36 AM

    Geoff.Sturdy - Wednesday, March 27, 2019 1:26 AM

    March 27, 2019 at 3:44 am

    #2031865

  • RE: No More SQL Server Installs

    I'll also be very happy when scripting the installation of MS-SQL server is a bit less painful. Controlled installation where are a lot of options and knowing exactly what is...

  • RE: No More SQL Server Installs

    There's a balance to be had, and a sensible developer/administrator must know and understand the important difference.

    An organisation's database is often utterly critical to the operation of the...

  • RE: T-SQL correlated queries

    Jonathan AC Roberts - Thursday, March 14, 2019 5:48 AM

    Another reason why you should always prefix the column names with the table...

  • RE: GDPR - A guide for the perplexed

    David.Poole - Sunday, January 14, 2018 4:04 PM

    CC-597066 - Sunday, January 14, 2018 3:20 PM

  • RE: GDPR - A guide for the perplexed

    CC-597066 - Sunday, January 14, 2018 4:50 PM

    David.Poole - Sunday, January 14, 2018 4:04 PM

  • RE: GDPR - A guide for the perplexed

    a.crossley - Friday, January 12, 2018 2:12 AM

    This is a great article - thanks.
    One key area that I keep bumping into and...

  • RE: A Tiny Trauma

    Eric M Russell - Wednesday, February 13, 2019 7:35 AM

    Rather than measurements and counts, I think that TINYINT was intended as...

  • RE: A Tiny Trauma

    I suspect that this is partly down to unofficial standards in software languages. Integer types are usually capable of holding negative numbers whereas word, dword and so on types do...

  • RE: Adding a Column Set

    Steve Jones - SSC Editor - Tuesday, September 18, 2018 11:21 AM

    n.ryan - Tuesday, September 18, 2018...

  • RE: Adding a Column Set

    Sorry, I may be missing something but I was rather confused by this question because the question just reads "how do I add a column to this table" however the...

Viewing 15 posts - 1 through 15 (of 78 total)