Viewing 15 posts - 496 through 510 (of 819 total)
These conversions are non deterministic, but from string to date:
from BOL:
Certain datetime Conversions Are Nondeterministic in SQL Server 2005 and Later Versions
In SQL Server 2000, string to date and time...
March 22, 2013 at 3:41 am
L' Eomot Inversé (3/20/2013)
demonfox (3/20/2013)
Danny Ocean (3/20/2013)
Good question.In real life scenario, we need to take care of cascade option.
I prefer not to have delete cascade on design .. to let...
March 20, 2013 at 4:53 am
I do not like "[OrderID] [int] NULL," in the [OrderDetail],
so you can insert orphan records despite the constraint.
CREATE TABLE [dbo].[OrderDetail]
(
[OrderDetailID] [int] NOT NULL,
[OrderID] [int] NULL,
CONSTRAINT [PK_OrderDetail] PRIMARY KEY CLUSTERED...
March 20, 2013 at 2:34 am
okbangas (3/15/2013)
Really easy question, but the explanation puzzles me. As far as I can see it is no implicit conversion, just a pure integer division.
+1
March 15, 2013 at 2:21 am
okbangas (3/13/2013)
Learned something new here, and by the way, the reference should be:
Good!
March 13, 2013 at 1:59 am
cppprogrammer (3/12/2013)
Yes statistically low probability but rows *can* be returned if SYSDATETIME() and GETDATE() at a particular time are equal. The "correct" answer is not correct.
+1
Correct answer is "Dates which...
March 12, 2013 at 2:06 am
Lokesh Vij (3/7/2013)
Must include an ORDER BY clause when a TOP clause is specified.
I think this statements should be "Must include an TOP clause when a ORDER BY clause is...
March 8, 2013 at 1:57 am
Dineshbabu (3/5/2013)
Hugo Kornelis (3/5/2013)
Good question, and good explanation. Well done!First time I'm seeing Hugo's post without any information.
We are waiting for "L'èmot est inversée", Tom for friends!
😀
March 5, 2013 at 4:11 am
handkot (2/26/2013)
the answer is ambiguous and depends from collations
+1
😉
February 27, 2013 at 12:51 am
The update may fails with error, if the default collation is case sensitive.
UPDATE GenderUpdate
SET Gender = CASE WHEN GENDER = 'M' then 'F' ELSE 'M' END
February 19, 2013 at 1:28 am
Viewing 15 posts - 496 through 510 (of 819 total)