Viewing 15 posts - 571 through 585 (of 820 total)
Oops. I reread the original. You are getting the column names from the header row and letting BCP or the like do the column splitting for you.
Sorry, had...
March 5, 2008 at 9:20 am
Paul,
Once that data was imported into SQL why go back to a flat file? I would have thought that you could have started digesting the data straight away. ...
March 5, 2008 at 9:15 am
frank.ress (3/3/2008)
... Just saying the same thing over and over doesn't make it true - but it does make lots of people THINK it is.
Ooh, good point. I...
March 4, 2008 at 6:58 am
fuller.artful (3/3/2008)
I don't suppose anybody knows of one. ...Arthur
I'm not sure that it does everything that you want but XXCOPY will come close. It's cheap, IMHO. You can...
March 3, 2008 at 7:24 am
I like what the guy on the Dyson adverts says: "I just think that things should work properly." I agree with majorbloodnock. I don't much care how that...
February 1, 2008 at 8:46 am
REPLACE INTO would be great, but it doesn't exist in SQL Server. This is what MERGE is supposed to do.
I'm just moaning about what I can't have. 🙁 ...
January 29, 2008 at 9:48 am
I'm not a big fan of MERGE. I much prefer REPLACE INTO. You code everything one way. It looks just like a regular INSERT statement except for...
January 29, 2008 at 9:01 am
We recently had a problem at a prominent client. Many (near) duplicate records were deleted from a critical table. The client IT manager could not use his "agent...
January 9, 2008 at 8:31 am
Jurriaan Themmen (1/8/2008)
Clint Eastwood said it years ago: "Opinions are like a$$holes....everybody has one."
And also "A man's got to know his limitations."
January 8, 2008 at 7:57 am
I've been resisting the joke about an in house programer being better than an out house programmer.
I let that slip out. Rats! I need food.
January 3, 2008 at 11:43 am
Drab, grey buttons work as well as well thought out colorful ones in corporate systems, so no one wants to pay any extra money to make things better.
Better? ...
January 3, 2008 at 8:20 am
Thanks Matt. I'm sorry, some times I say things just to be a flame magnet. Also I like to forward comments to managers that I know wherin the...
January 2, 2008 at 6:54 pm
brhunter (1/2/2008)
Great advice. However, I think a better article would be on the practice of creating "Self Documenting" database Schemas.
See Joe Celko's book "SQL Programming Style" ISBN:0-12-088797-5
January 2, 2008 at 11:15 am
Good point Sarah. Can you imagine an employer who says not only am I going to give you a good income for your 40 per week but I'm going...
January 2, 2008 at 9:32 am
Hey, I'm planning on listing SQL Server Central frequent readership as career development. If I can hold my own with heavy hitters like you lot that has to stand...
December 31, 2007 at 8:07 am
Viewing 15 posts - 571 through 585 (of 820 total)