Viewing 15 posts - 496 through 510 (of 812 total)
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
I mainly use triggers to modify the behavior of third-party db and to alert users by e-mail that some value has been set. e.g. changing terms of payment is permitted,...
February 19, 2013 at 1:12 am
This case is simpler: NO CROSS JOIN NEEDED.
Get result in text format:
create table #temp1(PK int IDENTITY Primary Key, column1 varchar(20))
insert into #temp1 values ('employee 1')
insert into #temp1 values ('employee 2')
insert...
February 12, 2013 at 8:25 am
Boh! Out of the context this script is useless!
Use of cursor is terrible.
February 11, 2013 at 12:58 am
Hugo Kornelis (2/6/2013)
Dineshbabu (2/6/2013)
But you steal some of my time by making me to sit and calculate each and every statement..:-) .
You could have saved that time. I just checked...
February 6, 2013 at 1:04 am
I know how CHOOSE works, but I do not want to know what the default data are for the table Employ!
Let's go!
January 28, 2013 at 2:54 am
raulggonzalez (1/28/2013)
January 28, 2013 at 2:52 am
Viewing 15 posts - 496 through 510 (of 812 total)