this question should have been worth 4 points :-)... so that atleast a person can get something for his correct choice... no rounding off required... 😀

CirquedeSQLeil (6/10/2010)

---

johnf_amic (6/10/2010)

---

I got 3...

this is the worst piece of design i have ever heard about!

my experience just includes not having foreign keys on tables, having varchar as the primary column!

thanks, great question... got it wrong though 🙁

A user-defined stored procedure that has the same name as a system stored procedure and is either nonqualified or is in the dbo...

thanks Hugo, i really didnt know this. I was assuming that HAVING must have a corresponding GROUP by.

agreed, absolutely !

thanks Paul 🙂 of all the QOTD, i find your questions the most difficult...:-)

agreed... i executed the query on sql 2005; ANSI NULLS on/off doesn't make any...

good one... thanks 🙂

I've seen that too before, same like this:

declare @a int set @a=1select @a

However, select1 or select@a won't work. It seems that a keyword preceded...

thanks for this... i had a hard time cleaning this one 🙂

by mistake, I executed this in the UAT environment and then i began searching the syntax for dropping a...

thanks for the question... got to know something new today, didn't get the point though 🙁

had to solve this using ssms 2005... 🙁 the query length was too much for me 🙂

thanks...didn't know about the index structures... lucky to get this one correct..:-)

ziangij (5/19/2010)

---

thanks... but there is one issue though...

1. create some user defined types in your database say UdtIntEntity

2. when you execute this query, you will get one row for...

thanks... but there is one issue though...

1. create some user defined types in your database say UdtIntEntity

2. when you execute this query, you will get one row for each...