There are a couple of ways:

A) Restore a backup plus tran logs to a different database and copy the data from there

B) If you're running SS2005 and have a database...

Get everyone else in IT to leave and then you'll have some artificial job security

Hi Andrew,

I think we also need to see udf_SQL_DataTypeString to make that UDF work.

Okay, so you're saying that some OO devs designed this database like they would design an OO system? I've seen some absolutely --wonderful-- output from those situations. Confusion...

David:

Are you talking about DRI, or "cascading" actions? Note that DRI is only primary key/foreign key constraints. The cascading stuff is not necessary for enforcing any kind of...

Really? What if I define a point (latitude/longitude) datatype? Does SQL Server have an operator that will let me move my point 10 miles east? Why don't...

So you're suggesting that the '+' operator be removed from SQL?

Stored procedures, sure. But you're forgetting about functions and--even more importantly--user-defined types.

Example: Assume you're coding an application that needs to store URLs in a few different tables. ...

The ultimate weapon against developers who say they want to re-write all of the stored procedures in CLR languages:

"Sounds like a great idea to me! Let me know how...

Anyone reading, please let me know if you have any feedback or questions about the sample chapter -- I wrote it

Thanks!

I've taken all four available exams so far, and the biggest headache for me (aside from SSRS and SSIS questions that I was unable to answer because I'm clueless on...

Hi Hugo,

I just double-checked in "An Introduction to Database Systems, 8th ed.", and per my understanding, JOIN in the case of a relation with a single attribute should behave identically...

Ahhh, answered my own question:

--

DECLARE @tbl table (id int)

insert @tbl values (1)

insert @tbl values (2)

insert @tbl values (3)

delete x from (select top 1 id from @tbl order by id desc)...

I believe you are correct.

The only way to do this is:

DELETE Customer

WHERE CustomerId IN

(

SELECT TOP 10 CustomerId

FROM Customer

ORDER BY DateAdded DESC

)

I'm not sure what...

Probably the best option!

Hmmm, after some more reflection, I can't think of any circumstances in which it would make sense to disable a...