The iPad would certainly come in handy if I'm ever trapped on a rollercoaster, have a connection and an iPad, and have to connect to a database server to handle...

I could be mistaken, but I think Red Gate has a tool that will do that for you.

You won't be able to use a checksum on text.

Almost certainly, the biggest performance hit in this is the inequality comparison between two text columns. (Should have called them...

"Image" is an obsolete binary data type. Use varbinary(max) instead. "Long" in Oracle appears to be a deprecated nvarchar data type comparable to nvarchar(max) in SQL Server. ...

This has the rules on all the data types in SQL Server: http://msdn.microsoft.com/en-us/library/ms187752.aspx

The Oracle float(126) is simply a 64-bit numeric data type, which would be the equivalent of float(53) in...

I don't understand what you're asking. Are you asking how to design a hierarchy in a database?

The close cursor option wouldn't impact this.

It would be interesting to capture the state of the data in the cursor at each row-move. Not sure it would be worth...

But ... but ... wait! ... are you trying to...

Select everything with ID = 2 all by itself. Does it have more than one entry for the same "field" anywhere?

But only if you understand the performance and transactional differences between the two.

petervdkerk (12/12/2010)

---

Sorry if I wasnt clear, but by this "what I'd rather not have to do is individually insert the column names that are to be selected and inserted.", I...

You're welcome.

You're welcome. Glad I could help.

mishaluba (12/11/2010)

---

Thank you for the article! We are getting started on a project requiring us to maintain hierarchies and I found the information here very useful. What's missing...

Will your table ever have two records on the same day that you want to keep?

Try turning that into a dynamic command as a string, and plug in the table...