Viewing 15 posts - 61 through 75 (of 138 total)
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...
February 13, 2004 at 10:32 am
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...
February 2, 2004 at 4:20 pm
I'm not sure that I'm completely following you. If I understand correctly:
January 29, 2004 at 10:02 am
Maybe you don't have your file properties set correctly - make sure you see multiple rows in the preview.
January 29, 2004 at 9:36 am
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)?
January 28, 2004 at 3:28 pm
Is bcp or Bulk Insert a requirement? This looks like precisely the sort of task that DTS is perfect for.
January 28, 2004 at 1:57 pm
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. ...
January 27, 2004 at 2:51 pm
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...
January 15, 2004 at 10:01 am
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...
January 15, 2004 at 8:55 am
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...
January 7, 2004 at 9:59 am
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,...
January 7, 2004 at 9:57 am
Also, using delete instead of truncate will preserve the last identity value.
January 7, 2004 at 8:49 am
Suggestion - can the code be manipulated to produce a page title for the browser window/tab?
January 6, 2004 at 2:41 pm
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...
January 6, 2004 at 12:40 pm
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...
January 2, 2004 at 11:38 am
Viewing 15 posts - 61 through 75 (of 138 total)