Viewing 15 posts - 496 through 510 (of 582 total)
There won't be any foreign key dependencies, so I guess you're mostly thinking of sps and triggers. This will find references from the current DB to another named DB selected...
Tim Wilkinson
"If it doesn't work in practice, you're using the wrong theory"
- Immanuel Kant
November 18, 2003 at 3:03 am
A hint on using UNION -
Since you won't be returning any duplicates, and since you aren't ORDERing the data, you should use UNION ALL to improve performance. Otherwise SQL...
Tim Wilkinson
"If it doesn't work in practice, you're using the wrong theory"
- Immanuel Kant
November 18, 2003 at 2:55 am
Maybe try a computed column?
Tim Wilkinson
"If it doesn't work in practice, you're using the wrong theory"
- Immanuel Kant
November 18, 2003 at 2:50 am
Create the 'stub' of a temp table (say, just an identity column) with a standard name before calling the stored proc. Inside the stored proc you could add the...
Tim Wilkinson
"If it doesn't work in practice, you're using the wrong theory"
- Immanuel Kant
November 18, 2003 at 2:43 am
If you have off-peak times, you could try using a timestamp column on your production tables to identify new/modified rows, then extract the new rows every night. This should minimise...
Tim Wilkinson
"If it doesn't work in practice, you're using the wrong theory"
- Immanuel Kant
November 18, 2003 at 2:36 am
David
quote:
For problems like this cursors seem the best bet as trying to build a dynamic query can sometimes exceed variable size limits....
Tim Wilkinson
"If it doesn't work in practice, you're using the wrong theory"
- Immanuel Kant
November 3, 2003 at 3:30 am
oops - I don't know if you are reading any of this, but I commented some bits of the code out in the version I posted - the WHERE clause...
Tim Wilkinson
"If it doesn't work in practice, you're using the wrong theory"
- Immanuel Kant
October 27, 2003 at 9:56 am
I've just used the code for this problem as an example for the junior DBA I am currently training - in the process I fixed a couple of errors. The...
Tim Wilkinson
"If it doesn't work in practice, you're using the wrong theory"
- Immanuel Kant
October 27, 2003 at 7:56 am
You will need to use dynamic SQL. I haven't tried the code below, so there may be errors, but it should give you the idea.
declare @attid int, @attname varchar(255)
declare @sql_start...
Tim Wilkinson
"If it doesn't work in practice, you're using the wrong theory"
- Immanuel Kant
October 27, 2003 at 3:36 am
Not sure about this, but you could try just changing the '7.0' on the first line to '8.0'. The equivalent works for upgrade from 6.5 to 7.0, so worth a...
Tim Wilkinson
"If it doesn't work in practice, you're using the wrong theory"
- Immanuel Kant
October 27, 2003 at 2:42 am
I can't see any problem which would prevent this statement from parsing. You don't have to supply an 'else' clause.
Did you definitely copy and paste exactly the correct code?
I guess...
Tim Wilkinson
"If it doesn't work in practice, you're using the wrong theory"
- Immanuel Kant
October 2, 2003 at 3:08 am
JeffDyer's point does not rule out using views, only SPs.
Some queries may require stored procs, of course, e.g. crosstabs, returning lists of values in a single field etc., so with...
Tim Wilkinson
"If it doesn't work in practice, you're using the wrong theory"
- Immanuel Kant
September 17, 2003 at 4:04 am
look at:
@@error
set xact_abort
transactions
sysmessages
in BOL
Tim Wilkinson
"If it doesn't work in practice, you're using the wrong theory"
- Immanuel Kant
September 17, 2003 at 3:35 am
Are they really the same attribute? There may be a logical design issue here. Can you explain what the attribute is?
Tim Wilkinson
"If it doesn't work in practice, you're using the wrong theory"
- Immanuel Kant
September 17, 2003 at 3:33 am
Viewing 15 posts - 496 through 510 (of 582 total)