+1

good one ...

thanks for the question

I don't see any trick ; easy one ...

adding join on duplicate values, make it like a cross product, get plenty of duplicate rows , add filter and...

jlennartz (4/11/2013)

---

If default values are returned as in your explaination why are not all the values except null returned in this format, "1900-01-01 00:00:00.0000000". How did they...

+1

Thanks for the question ..

Lowell (4/10/2013)

---

here's a really easy example:

--common tables between the two

SELECT name from SandBox.sys.tables

INTERSECT

SELECT name from Dictionary.sys.tables

--tables only in SandBox

SELECT name from SandBox.sys.tables

EXCEPT

SELECT name from Dictionary.sys.tables

--tables only in Dictionary

SELECT name from...

common table , by name , by attributes or...

nice and straightforwad - instinct worked for me ..:w00t:;-)

The case statement will assign 'FF' to @str6 ,Remaining varaibles contains NULL values by default and not assigned with corresponding values of AA,BB,CC,DD and EE. The values are assigned...

db4breakfast (3/21/2013)

To be clear, we don't allow users to delete any record in our application. However there's a function for users to flag a record as error. Instead of cascade...

call.copse (3/21/2013)

---

Raghavendra Mudugal (3/21/2013)

...

- in general practice, as truncate removes all the records and no one wants to remove all the records from the table, only if any exceptional case...

One possible reason is that you can't control the order of locks being taken with cascading deletes and cascading updates. That makes it harder to avoid deadlock scenarios if you...

Hugo Kornelis (3/21/2013)

---

One possible reason...

Dineshbabu (3/20/2013)

---

Lokesh Vij (3/20/2013)

---

+1

same here. i feel it...

"It" refers to Truncate .

It's a DDL , Data definition language - why ? I think because It resets the identity, that is a database object property change. [because, it...