Very very good question mascot. That was the only thing I knew about SQL 2014 so i shot it down quickly. 🙂

Thats the benefit we get on this platform. We...

In between, simple and good QOTD. 🙂

Jamsheer (10/3/2013)

---

tom.w.brannon (10/2/2013)

---

I believe the problem is a difference in how distinct gets used in different contexts. For the following queries

select count(distinct id) from #temp_test;

select distinct id from #temp_test;

select...

Dana Medley (10/1/2013)

---

+1 Good question. Never really used these, so it was good to do some research...

Thanks to some QOTD asked some time back, I was able to answer it correctly without giving second thought. The errors with the script in SQL 2005 were interesting.

Though...

very good question. 🙂

Good QOTD. 🙂

Hi Just check this one:

create table dbo.Emp

(EmpID varchar(5), Empname varchar(20), Logdate date, Timein time, Timeout time)

insert into dbo.Emp select '1001', 'Steve', '20130928', '11:30 am', '02:30 pm'

insert into dbo.Emp select '1001',...

sknox (9/30/2013)

---

Good question, but the answer isn't quite right.

You cannot use TRUNCATE TABLE on tables that are referenced by a FOREIGN KEY constraint UNLESS that table has a foreign key...

SELECT 'UPDATE table_1

SET labeltext ='+ T.labeltext +

'WHERE LanguageID = 10

AND LabelKey ='+ T.LabelKey +

'AND FileID =' + T.FileID

Try this one. You are forgetting one "+" on the right...

Thanks balde for posting the link. Definitely there might be some rare cases where such implementation is...

Same here. After long long time, I didn't had to think twice. Happy weekend....

For me, it's definitely the hardcopies. I've so many pdfs in my lappy but couldn't complete any and the only one's i've completed are the hard copied. Somehow I cannot...

Good question and equally good explanation. 🙂

In today's scenario, many of the times, the code which is correct today may become incorrect (or inefficient) tomorrow based on the frequently changing scenarios and/or improvements. So any change...