Viewing 15 posts - 286 through 300 (of 658 total)
Mr. Kapsicum (5/13/2013)lost a valuable point
How valuable exactly? Would you like to make an offer for some of mine?
😉
May 13, 2013 at 8:34 am
I wrongly assumed the point of the question was that the table wouldn't have an identity column because it wouldn't be created at all due to the lack of a...
May 13, 2013 at 3:22 am
Well spotted 🙂
I'd say best practice is not only to use aliases, but also to adopt and stick to some standard naming conventions for your database!
May 9, 2013 at 1:34 am
A good question, but I'm not so sure about the explanation.
If a column is referenced in a subquery that does not exist in the table referenced by the subquery's FROM...
May 9, 2013 at 1:15 am
Danny Ocean (5/2/2013)
Most of people don't know about it because it's not in use in any real scenario.
Sure it is, if the table contains other columns, all with defaults.
As a...
May 3, 2013 at 2:33 am
An object lesson in the need for well-commented code!
April 3, 2013 at 2:26 am
KWymore (3/29/2013)
Outside of a hierarchy example, I can't think of when you would have a table foreign key reference to itself.
A piece of machinery that is no longer available because...
April 2, 2013 at 2:55 am
Artur Komkov (3/24/2013)Moderator suppose to check questions.
User supposed to read thread before posting exactly the same reply as 8 pages of other people 😉
March 25, 2013 at 3:10 am
On reflection - given that you cannot use truncate on a table referenced by foreign keys - it seems more like it is actually doing a drop/create. Which would make...
March 22, 2013 at 2:59 am
nenad-zivkovic (3/21/2013)
http://msdn.microsoft.com/en-us/library/ff848799.aspx
"Data Definition Language (DDL) is a vocabulary used to define data structures in SQL Server 2012. Use these statements to create, alter, or drop data structures in an instance...
March 21, 2013 at 6:53 am
demonfox (3/20/2013)
which way do you think is more safe ??
Using cascade delete. If the business rule says that is the appropriate behaviour, then why avoid using inbuilt functionality that achieves...
March 21, 2013 at 3:00 am
demonfox (3/19/2013)
only English , when it comes to britain ...
I'm looking forward to Tom's reply to that one 😉
March 19, 2013 at 8:28 am
sknox (3/13/2013)
It then goes on to provide several data type examples, including a lot of "date" constants which are actually all varchar constants.
Blimey. That really is quite special. Presumably they...
March 14, 2013 at 3:11 am
Most disappointing. I was sure when I got to the thread I'd see several pages of identical replies saying that it gives an error about assigning variables in the declare...
March 14, 2013 at 3:08 am
sgmunson (3/13/2013)
And why isn't anyone making a lot more noise about it?
Because it's not really important? Because we're all grateful for the free service that Steve provides, and the time...
March 13, 2013 at 8:11 am
Viewing 15 posts - 286 through 300 (of 658 total)