Viewing 15 posts - 4,636 through 4,650 (of 8,416 total)
Valid question, but I don't suppose I will retain the answer very long.
Thank goodness for BOL 😉
March 30, 2010 at 9:14 am
vk-kirov (2/10/2010)
In the example above, we will see request_mode = Sch-M (schema modification). This is specific to DDL events.
Not true. From Books Online - Lock Modes:
Some data manipulation language...
March 30, 2010 at 9:10 am
vk-kirov (3/3/2010)
So, db_ddladmin can run any DDL command; db_ddladmin can run TRUNCATE TABLE. This means TRUNCATE is a DDL command, I believe 🙂
Crows are birds.
All crows are black.
Therefore, all birds...
March 30, 2010 at 9:01 am
I look forward to Raju The Leader (???) enlightening us all about Type 3 SCDs :laugh:
March 30, 2010 at 8:57 am
Never get tired of this sort of question - it is such an important topic.
March 30, 2010 at 8:54 am
Using OPENROWSET that way is just wrong!!! 😀
March 30, 2010 at 8:53 am
This difficult-to-recall behaviour is the main reason I prefer SET @x = (SELECT...) syntax.
March 30, 2010 at 8:49 am
It seems odd to me that type names must be lower cased in a case-sensitive database.
Also the case with hiercarchyid in SQL 2008.
Am I the only one that prefers to...
March 30, 2010 at 8:47 am
Tedious question. Just the sort of pointless detail I do not need in my head.
March 30, 2010 at 8:45 am
WayneS (2/16/2010)
Just remember that without an order by clause, there is no guaranteed order. The correct answer for this could have been just as easily "Bill, Mark, John".
Agreed. That...
March 30, 2010 at 8:44 am
Lesson for today: spend more than 3 seconds reading the question 🙁
March 30, 2010 at 8:42 am
Viewing 15 posts - 4,636 through 4,650 (of 8,416 total)