Viewing 15 posts - 4,951 through 4,965 (of 8,416 total)
tstaker (3/22/2010)
March 23, 2010 at 5:55 am
😀 So it was a table trigger after all! 😀
Glad the semi-colon thing helped.
Please look up the QUOTENAME function - it allows your code to cope with database names that...
March 23, 2010 at 5:53 am
EdVassie (3/23/2010)
March 23, 2010 at 5:50 am
It looks as if the intention here is to disable a database trigger.
Aside from the other syntactical errors, the syntax is 'DISABLE TRIGGER {name} ON DATABASE'.
You use the word 'DATABASE'...
March 23, 2010 at 5:21 am
Aspet Golestanian Namagerdi (3/22/2010)
March 23, 2010 at 5:11 am
Not sure if I fully understood the requirements, but...
DECLARE @Source
TABLE (
companyname VARCHAR(10) NOT NULL,
...
March 23, 2010 at 5:07 am
Use APPLY with TOP. If you provide easily consumable test data, I will write a demonstration script.
March 23, 2010 at 4:30 am
SouthernConfusion (3/22/2010)
I agree that it executes them synchronously, but the cursor will run through all of the rows rather than pausing between rows for completion...
Executing synchronously means that each sp_executesql...
March 23, 2010 at 4:28 am
WangcChiKaBastar (3/22/2010)
I have to write a sp that would give two data sets...
It is usually more efficient to just return one data set, and return the row count in an...
March 23, 2010 at 4:16 am
Tweaked:
DECLARE @Sample
TABLE (
code CHAR(1) NOT NULL,
value INTEGER...
March 22, 2010 at 7:11 pm
My experience of interviewing is that candidates with certifications lack practical knowledge. Just an observation.
March 22, 2010 at 6:31 pm
Some code to illustrate my point about indexed computed columns. Note that the computation is performed on the column reference.
-- Persisting whole_date2 only works in 2008
CREATE TABLE #Test...
March 22, 2010 at 6:23 pm
Attaching the text file to this post to make accessing it easier than going via rapidshare.
When you attach the graphical plan, be sure to upload it as an attachment to...
March 22, 2010 at 6:09 pm
swiedner (3/22/2010)
"never acquires more memory than the level specified in max server memory."
Does that mean, that it will not ever use the page file then? That statement tells...
March 22, 2010 at 6:03 pm
Stefan_G
What exactly do you mean with SARGable in this context?
No idea! Misremembering something, answers on a postcard as to what. :laugh:
Of course the only way such an expression is...
March 22, 2010 at 8:17 am
Viewing 15 posts - 4,951 through 4,965 (of 8,416 total)