Forum Replies Created

Viewing 15 posts - 61 through 75 (of 138 total)

  • RE: Virtual Briefcase sort order

    I'd expect to see the items sorted in actual date order. At present, if I had articles from January and February of 2003, I believe I'd see them as...

  • RE: Inserting NULL into datetime Field

    MikeMcDonald's point was that SQL Server automatically inserts NULL into any column not specified in the INSERT statement. The exceptions are if no columns are specified (in which case...

  • RE: how to implement a “colourScheme”

    I'm not sure that I'm completely following you. If I understand correctly:

    • There are multiple companies
    • Each company can have multiple regions
    • Each region can have multiple areas
    • Each area can have...
  • RE: BCP OR BULK INSERT

    Maybe you don't have your file properties set correctly - make sure you see multiple rows in the preview.

  • RE: Using new Identity in new insert (other table)

    I'd be inclined to do this with a trigger, normally. Any reason not to do that (like this only applies in a special case, or some such)?

  • RE: BCP OR BULK INSERT

    Is bcp or Bulk Insert a requirement? This looks like precisely the sort of task that DTS is perfect for.

  • RE: The Bit Data Type Problem Mentioned in a recent QOD

    Possible explanation: It is common in many languages (including C++ and Perl) to "convert" integers into a true/false value by saying 0 = FALSE, anything else = TRUE. ...

  • RE: Joins vs More Columns

    Actually, the single table approach isn't truly a denormalized approach - data isn't repeated in it any more than it is repeated in the multi-table approach. As people have...

  • RE: Joins vs More Columns

    More points regarding the importance of flexibility:

    There are problems with the single-table format and multiple rows of data. Your opitons are to hard-code which set of data...

  • RE: Compare Text Fields

    Re-read the part about storing the previous and new values in the log table. If what I said would work, then you'd just store the updated value in the...

  • RE: Compare Text Fields

    That's still an application-level solution - users with the right permission could still make changes directly through SQL. Even if our quester is the only person with such access,...

  • RE: need urgent help

    Also, using delete instead of truncate will preserve the last identity value.

  • RE: Beta Test New Forums

    Suggestion - can the code be manipulated to produce a page title for the browser window/tab?

  • RE: Compare Text Fields

    Keep in mind that there is the possibility of incorrect results if the field following 'LIKE' includes wildcard characters. The inclusion of '_' or '%' might cause two unlike...

  • RE: QOD 1/2/04

    Although I got the right answer, one does have to make a couple of significant assumptions to get there:

    1) The company uses the simplest form of its domain in...

Viewing 15 posts - 61 through 75 (of 138 total)