Viewing 15 posts - 151 through 165 (of 179 total)
Jeff Moden - Wednesday, April 5, 2017 4:54 PMI'm thinking that your plan of using MachineID+F1+Kant for the PK //snip//
He can't -...
April 6, 2017 at 5:39 am
If the script is all "backwards" as you report, it probably isn't checking to see if things exist before trying to create them either. You should check if a table...
March 15, 2017 at 5:17 am
March 9, 2017 at 11:42 am
Driving further off into the weeds ....
Why is it that so many businesses seem to think that an email address or phone number is immutable and therefore is...
March 8, 2017 at 5:28 am
I ran into 2 of these recently.
One, in the company I work for, is partially being rewritten. The problem is that there are 2 codes, call them C...
February 17, 2017 at 5:22 am
Thanks Jeff.
I use either of the last 2 examples in your post. I was concerned that the last one, with an alias following UPDATE, was or was not...
February 13, 2017 at 5:07 am
February 9, 2017 at 5:21 am
hawg - Thursday, January 26, 2017 10:22 AMComments posted to this topic are about the item Find Text in All Databases
Very nice....
January 30, 2017 at 5:45 am
Lynn, I bet they figured since they survived Y2K, the whole thing was just fine. They didn't realize there was going to be a J10K problem a few years later.
January 27, 2017 at 10:26 am
At a previous job, I was looking at a table. "Wow, that's a lot of rows. I didn't know we had any tables that big."
Then I had another...
January 27, 2017 at 6:00 am
CELKO (1/4/2017)
CREATE TABLE Players
(player_id CHAR(5) NOT NULL,
first_name VARCHAR(10) NOT NULL,
last_name VARCHAR(10) NOT NULL,
sport_name VARCHAR(15) NOT NULL
CHECK (sport_name IN ('FootBall', 'Soccer', 'Baseball', 'Basketball', 'Volleyball',...
January 5, 2017 at 5:43 am
Is there a reason this table would be populated with non-award "events"? In the sample data, employee 1 has 2 nulls and one award. What is the value...
January 4, 2017 at 5:22 am
RonKyle (12/28/2016)
It can be used. But there could be fragmentation if new accounts are added in some patterns, rather than in (generally) increasing values.
For example, suppose the first 3 characters...
December 28, 2016 at 8:55 am
RonKyle (12/28/2016)
I've found that account numbers (of various types, not just bank accounts) have meaningful leading zeros. So they must be stored as char/varchar.
Excellent point. However, why can't...
December 28, 2016 at 7:15 am
Viewing 15 posts - 151 through 165 (of 179 total)