Not so clear to Oracle guys 🙂

http://download.oracle.com/docs/cd/E11882_01/server.112/e10592/statements_1001.htm – TRUNCATE is in the DDL list.

This must be a typo because the result is 0.

By the way, which event took place on 1776-01-01?

Why the question specifies the slash datetime format (yyyy/mm/dd) while all the answers are in the dash datetime format (yyyy-mm-dd)? This is completely misleading and incorrect! 😛

Paul White NZ (3/30/2010)

---

Some data manipulation language (DML) operations, such as table truncation, use Sch-M locks to prevent access to affected tables by concurrent operations.

So, table truncation is explicitly defined...

Here is a nice article about this: http://blogs.msdn.com/sqltips/archive/2008/06/26/differences-between-isnull-and-coalesce.aspx

COALESCE basically translates to CASE...

This is very interesting because [font="Courier New"]ISNUMERIC(' ')[/font] returns...

I'm afraid you'll be disappointed in this function since it became documented (and obsolete at the same time) in SQL Server 2008 🙂 http://msdn.microsoft.com/en-us/library/dd822791.aspx

PWDENCRYPT is a hash function, which means it's a one-way function. Once hashed, data cannot be restored. With cell-level encryption, data...

Tom.Thomson (3/19/2010)

---

vk-kirov (3/16/2010)

---

Hugo Kornelis (3/16/2010)

---

the backup first copies all the data pages, then adds all the log pages starting from the start of the oldest uncommitted transaction right up until...

I think Microsoft is also indirectly responsible for the subject of discussion, because usually answers and explanations include quotes from BOL and links to BOL. If there are any errors...

File - New - Policy

Oops... it looks like I revealed someone's secret :w00t:

You are mistaken. Here is a quote from BOL 7.0:

Creating and Restoring a...

Hugo Kornelis (3/16/2010)

---

the backup first copies all the data pages, then adds all the log pages starting from the start of the oldest uncommitted transaction right up until the time...

Mark D Powell (3/16/2010)

---

Because this is a full backup ...

From the manual:

The full recovery model uses log backups to prevent data loss in the broadest range of failure scenarios, and...