Thanks for the input everyone - I had a look at the article "Comparing Table Variables to Temporary Tables", and it is useful.

I suppose it is true that this was...

I get the feeling that Microsoft are keen to emphasize their "new" additions in the exams - hence favoritism towards table variable over temp tables, CTEs over subqueries, etc. I've...

Ninja's_RGR'us (3/15/2011)

---

Option Z

Rename old table, drop all constraints (name conflicts)

Then create new table with all constraints and indexes.

You still have a backup of the table and you have an empty...

Toby White (3/15/2011)

---

Truncate Table is logged, it's just that the pages are deallocated instead of each row being logged as with the delete. For proof of this, try rolling back...

Sadly, I cannot change the database structure or perform any DDL operations.

Don't think I can use bcp either - it has to be within a transaction (in a sproc) in...

I'm wondering, why is batch delete faster than one statement? I'm assuming it is something to do with the transaction log...

Customers are not happy with truncate being used in...

In case anyone else has this problem as searches for it:

A trigger is a "level 3" object, beneath a table (for example). So you specify the schema, then the...

meh, nevermind think I got a semi-explanation here:

http://msdn.microsoft.com/en-us/library/ms180047.aspx

ALZDBA (3/19/2008)

---

you would have been able to keep the existing identity values by using

set identity_insert yourtable on

perform your inserts

set identity_insert yourtable off

This way you would have been able...

The problem itself wasn't quite what I was making of it. I didn't need to return the table name from the context of the insert statement after all.

Basically I...

Thanks for the help everyone...I have figured it out (the problem was a bit more complex than how I was explaining it).

Thanks for the suggestion - I was hoping for a system function which would return the table name but I guss it doesn't exist.

However, I wrote the following function which...