This was one of the SQL Server questions in the MS Exams when I wrote it few years ago 🙂

This was a fun guessing question 😀

I first wanted to say XML, because it is like the odd one out and the books online usually use universities in their XML...

So is someone going to ask tomorrow if we can use temp tables in UDFs? 😛

It should be added to the explanation that when you create a table without specifying the schema name, it uses the default schema for the database (which is most probably...

vk-kirov (10/31/2012)

---

"Delete a row multiple...

Jason-299789 (10/29/2012)

---

Actually your table design is not quite right.

I would set it up as

Create Table WorkPlace

(

WorkPlaceCode (PK)

,WRegn

,WorkplaceName

,NumberOfEmployees

,Address_Id

)

CREATE Table Employee

(

EmpNum (PK)

,EmpName

,WorkPlaceCode (FK)

)

CREATE Table Address

(

Address_Id (PK)

,Address1

,Address2

.....

)

This way you assign...

This is probably not helping to solve your problem with performance in mind, but WHY do you use BIGINTs as IDs on ALL your tables? I mean you have...