More than one thing is wrong. Your dynamic SQL runs a query against INFORMATION_SCHEMA.TABLES - but there is no need for that query to be dynamic. Presumably you want a...

SELECT *

FROM Document D

WHERE (@Type = 1 AND

EXISTS (SELECT *

...

Having spoken we with a few SQL Server Developers, I know that SET options is high...

Yes, I would interpret this message as bad media - or a bad download. Although, I think a bad download would give some different (and more confusing) message.

These days, I...

Jeff Moden (8/25/2013)

---

I have to disagree. Right click on the properties for an instance and look at the "Default Connection Option" under "Connections". If you haven't previously messed...

If this happens on an Oracle system, you need find a forum for Oracle. This entire site is dedicated to Microsoft SQL Server.

Jeff Moden (8/24/2013)

---

We have to be a little careful here. The default for the setting at the database connection level is OFF and the default setting for connections within...

But that does not help if execution is cancelled because of a query timeout. SQL Server...

In the first case, each statement commits separately,...

It sounds like your application does not have proper hanlding of query timeouts.

First you should ask yourself, if you want these suckers at all, and in such case what timeout...

Through Google I found this information in Wikipedia:

There are currently two editions of Act! -

Act! Pro is limited to 10 active users and utilizes Microsoft SQL...

To answer the original question, yes there is:

SELECT c1, c2, delta = lead(c2, 1, c2) OVER (ORDER BY c1) - c2

FROM #t1

ORDER BY c2

LEAD(c2, n) gives you the nth row...

Excuse me, but what is the connection to SQL Server?

In addition to Gail's remark, keep in mind that there is plenty of functionality in SQL Server that requires ANSI_NULLS to be ON. SET ANSI_NULLS OFF is a true legacy...

Because

<cmp:O b="16" />

is not a valid XML document. It doesn't help to add WITH XMLNAMESPACES; the document is still not valid.

You can use WITH XMLNAMESPACES when you want to construct...