|
|
This person flooded the Q&A forum with massive postings:
http://www.codeproject.com/script/Membership/View.aspx?mid=10684279[^],
http://www.codeproject.com/Members/Donnie-Brownhotmailcom[^].
At the moment of writing, this member got 8 abuse reports on his account, all posts were removed, I saw 3 (three) last ones.
This is the copy of one of those posts:
Donnie-Brown wrote:
Question:
You use a Microsoft SQL Server 2012 database.
You want to create a table to store Microsoft Word documents. You need to ensure that the documents must only be accessible via Transact-SQL queries. Which Transact-SQL statement should you use?
A. CREATE TABLE DocumentStore AS FileTable
B. CREATE TABLE DocumentStore([Id] [uniqueidentifier] ROWGUIDCOL NOT NULL UNIQUE,[Document] VARBINARY(MAX) FILESTREAM NULL)GO
C. CREATE TABLE DocumentStore([Id] [INT] NOT NULL PRIMARY KEY,[Document] VARBINARY(MAX) NULL)GO
D. CREATE TABLE DocumentStore([Id] hierarchyid,[Document] NVARCHAR NOT NULL);GO
Answer: C
Question:
You develop a Microsoft SQL Server 2012 server database that supports an application. The application contains a table that has the following definition: CREATE TABLE Inventory(ItemID int NOT NULL PRIMARY KEY, ItemsInStore int NOT NULL, ItemsInWarehouse int NOT NULL) You need to create a computed column that returns the sum total of the ItemsInStore and ItemsInWarehouse values for each row. Which Transact-SQL statement should you use?
A. ALTER TABLE InventoryADD TotalItems AS SUM(ItemsInStore, ItemsInWarehouse)
B. ALTER TABLE InventoryADD TotalItems = ItemsInStore + ItemsInWarehouse
C. ALTER TABLE InventoryADD TotalItems AS ItemsInStore + ItemsInWarehouse
D. ALTER TABLE InventoryADD ItemsInStore + ItemsInWarehouse = TotalItems
Answer: D
...
This looks pretty bad. I hope we will agree that we don't want such things.
—SASergey A Kryukov
modified 24-Mar-14 2:24am.
|
|
|
|
|
|
Already reported right below...
Soren Madsen
"When you don't know what you're doing it's best to do it quickly" - Jase #DuckDynasty
|
|
|
|
|
Yes, I noticed after I posted that.
The date on your message said it was posted about three hours ago at the time, and I came here to report a minutes-old piece of spam. So I didn't bother checking...
|
|
|
|
|
|
Member gone after 11 reports.
What do you get when you cross a joke with a rhetorical question?
|
|
|
|
|
Chris has increased the amount of votes needed to remove accounts because people were abusing the vote to remove option against legitimate users.
|
|
|
|
|
Yeah... I don't think it is the right solution. It seems to me it is going to cause more trouble than it will solve.
Soren Madsen
"When you don't know what you're doing it's best to do it quickly" - Jase #DuckDynasty
|
|
|
|
|
|
|
|
"Article" closed. Member needs some more kicking
|
|
|
|
|
|
|
More kicks needed for the spammer.
|
|
|
|
|
Final kick given.
To learn all there is to know. I know I'll be disappointed one day, but I've made a good start, and the eventual disappointment is likely to be brief.
-Roger Wright
|
|
|
|
|
|
|
Kicked, gone.
|
|
|
|
|
But the author is still with us: http://www.codeproject.com/script/Membership/View.aspx?mid=10690026[^]
It's harder to get rid if them, since Chris doubled the kicks needed...
Those who fail to learn history are doomed to repeat it. --- George Santayana (December 16, 1863 – September 26, 1952)
Those who fail to clear history are doomed to explain it. --- OriginalGriff (February 24, 1959 – ∞)
|
|
|
|
|
OriginalGriff wrote: It's harder to get rid if them, since Chris doubled the kicks needed...
I'm glad he did . A few days ago I got kicked off for some reason!
I emailed Sean and he let me back on with an "innocent" verdict.
|
|
|
|
|
Oh. Is it !!! Then we have to wait.
|
|
|
|
|
|