Viewing 15 posts - 17,131 through 17,145 (of 18,926 total)
Yes it's syntaxe only... but I preffer the read something that looks like an inner join. That way I can't miss the 2nd table in the query... But...
June 9, 2005 at 6:46 am
Here's the kicker...
Compare colid to colid2
.
I know it's not perfect but the syscolumns handle the colid in strange way in functions and...
June 9, 2005 at 6:41 am
Quoting myself :
"Also I feel I must mention that this presentational stuff should be made at the client."
.
June 9, 2005 at 6:36 am
You'll have to start the profiler and run on trace based on his login. But this will have to run for all the time he's in the office. ...
June 9, 2005 at 6:33 am
Frank, Rob. I'm not sure you got exactly how the update is working (unless you're keeping it to yourself). You're right about incrementing a value, but you're still...
June 9, 2005 at 6:26 am
Why can't you create different stored procs for different update statements?
June 8, 2005 at 10:02 pm
Time to go to bed... and still no correct answer.
Maybe tomorrow morning
.
June 8, 2005 at 9:58 pm
Wouldn't it be nice if we could just do :
ALTER TYPE [dbo].[city] FROM [varchar](50) NOT NULL.
Is it because it's impossible or not recommended to do so?
June 8, 2005 at 9:57 pm
Unless you logged the searched, or the results, I don't think it can be done.
You could always use a log reader but then don't log selects so I doubt that...
June 8, 2005 at 9:45 pm
R u trying to remove duplicates from the data, or are you trying to find the primary key?
June 8, 2005 at 9:30 pm
Thanx for the tip... Will try to test that tomorrow.
June 8, 2005 at 9:15 pm
God I'm slow tonight.
Just remembered that one of the unique indexes in SysObjects is :
Name, Owner (always the simple little things that trip you up).
Michael Du Bois :...
June 8, 2005 at 9:13 pm
Viewing 15 posts - 17,131 through 17,145 (of 18,926 total)