Viewing 15 posts - 6,571 through 6,585 (of 7,484 total)
Terrific question.
My brain was not working correctly - for some reason I decided that since DDL triggers (unlike DML triggers, which have an "instead" option) always execute after...
October 17, 2010 at 4:03 pm
Nice question. Illustrates how silly some of XML is.
October 17, 2010 at 3:37 pm
Nice question (I saw it after the change from "table"). Nice example from vk_kirov made it clear how it can be used.
October 17, 2010 at 3:21 pm
Lynn Pettis (10/17/2010)
Sorry, but I couldn't resist responding. We'll see how he takes my critizism (sp ?).
Well, that's a very snsible thing to tell him. But...
I think the result...
October 17, 2010 at 2:56 pm
Why is this question about SMO and VBScript categorised as a T-SQL question? It has absolutely nothing to do with T-SQL.
October 17, 2010 at 2:18 pm
If I remember this rightly, the wrapper was somewhat half-baked and would only connect to the local default instance; if you wanted to connect to any other instance using VBScript...
October 17, 2010 at 2:11 pm
Russell Shilling (1/24/2005)
The "correct" answer ignored the @NoisePattern parameter, so there really wasn't a completely correct answer amongst the four choices.
I have to agree with that. The number returned...
October 17, 2010 at 1:58 pm
Like Jason, I disagree with the current answe (for the same reason).
October 17, 2010 at 12:14 pm
GilaMonster (10/17/2010)
This has to be like this,...
October 17, 2010 at 11:42 am
David Ziffer (10/17/2010)
Nowhere did I propose that anyone construct a view and a table which when queried directly display the same content. .
No. However you did say
At some...
October 17, 2010 at 11:33 am
David Ziffer (10/13/2010)
October 17, 2010 at 10:36 am
beejug1983 (10/17/2010)
First : - The query that is...
October 17, 2010 at 9:46 am
GilaMonster (10/17/2010)
October 17, 2010 at 6:50 am
GilaMonster (10/17/2010)
With some sample code that looks like an interesting cross between T-SQL and an object-orientated language.
SELECT .... WHERE OrderDate.Month = 2
May I suggest that everyone just ignores...
October 17, 2010 at 4:35 am
Really excellent article - nice and clear, easy to understand, and seems to cover all the issues. Thanks Roy.
October 16, 2010 at 1:22 pm
Viewing 15 posts - 6,571 through 6,585 (of 7,484 total)