Viewing 15 posts - 391 through 405 (of 581 total)
No point in unique clustered index on composite key with a surrogate? Don't be too hard on yourself, there might be a point sometimes. It's just not necessarily a good...
June 1, 2006 at 5:36 am
I wouldn't use dynamic SQL for production code, especially non-trivial data retrieval or concatenating parameters from the front end. But I would draw a distinction between production (application) code and administration (utility)...
June 1, 2006 at 5:32 am
>any of the variants looking at the metadata
what variants?
June 1, 2006 at 5:10 am
Sergiy, some data is 'a mess'. Some data refers to its own processing. Someone somewhere has a legitimate reason for doing what I describe. So the answer to the question...
June 1, 2006 at 4:49 am
You'd only be interested in the INSERT order if there was a identity column. Sergiy, are you saying that this won't work and new records might be 'incorrectly' numbered?
May 31, 2006 at 7:52 pm
But you can't do it setwise, of course.
MS have deprecated use of READTEXT with text pointer saying it will be phased out, and recommended using SUBSTRING instead. Does anyone...
May 31, 2006 at 7:43 pm
[EDIT: THIS FIRST PARA WAS WRITTEN WITHOUT READING THE PREVIOUS POSTS PROPERLY] If that doesn't do it, I'd be surprised, but if not, can you see any difference between the showplan...
May 31, 2006 at 6:16 pm
Just out of interest, is the problem with the 30K text values just a performance issue, are your embedded 'rows' > 8K, or is a variable overflowing, or none of...
May 31, 2006 at 5:53 pm
Funny, I always thought it was disallowed. Maybe it was in v6.5 or 7 and I never realised they had changed it? The matter's not really documented, so I don't...
May 31, 2006 at 5:17 pm
Here's one way, using pure SQL. I've had to guess at your table structures and some other things.
c.FullName
May 31, 2006 at 4:07 pm
Looks like you have some import files stuck in your DB. You want to extract them and use an import process: bcp out, bcp in. Or perhaps ask the DTS...
May 31, 2006 at 3:19 pm
I'll have a go: when you use a GROUP BY clause, you specify that you only want one row returned for each distinct combination of values in the fields specified...
May 31, 2006 at 3:11 pm
You mean one SET clause, one FROM clause and one WHERE clause. You can have as as many JOINs as any other...
May 31, 2006 at 2:40 pm
>How do i create a .bat file with t-sql?
What do you mean? How to create the actual OS file, or how to generate windows shell script?
May 31, 2006 at 2:25 pm
Viewing 15 posts - 391 through 405 (of 581 total)