Viewing 15 posts - 751 through 765 (of 1,219 total)
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...
August 25, 2013 at 4:24 pm
SELECT *
FROM Document D
WHERE (@Type = 1 AND
EXISTS (SELECT *
...
August 25, 2013 at 3:58 pm
Jeff Moden (8/25/2013)
I like to have options no matter how infrequently I may use them.
Having spoken we with a few SQL Server Developers, I know that SET options is high...
August 25, 2013 at 2:55 pm
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...
August 25, 2013 at 2:16 pm
Jeff Moden (8/25/2013)
August 25, 2013 at 2:09 pm
If this happens on an Oracle system, you need find a forum for Oracle. This entire site is dedicated to Microsoft SQL Server.
August 25, 2013 at 2:21 am
Jeff Moden (8/24/2013)
August 25, 2013 at 2:20 am
Jan Arnoldus (8/24/2013)
The calling SP already has something like IF @@error <> 0 ROLLBACK TRANSACTION.
But that does not help if execution is cancelled because of a query timeout. SQL Server...
August 24, 2013 at 4:30 pm
Jan Arnoldus (8/24/2013)What is the difference between running a 1000 update as in the first example and wrapping it in a transaction?
In the first case, each statement commits separately,...
August 24, 2013 at 4:15 pm
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...
August 24, 2013 at 4:11 pm
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...
August 24, 2013 at 3:54 pm
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...
August 24, 2013 at 3:45 pm
Excuse me, but what is the connection to SQL Server?
August 24, 2013 at 3:37 pm
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...
August 24, 2013 at 3:34 am
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...
August 24, 2013 at 3:30 am
Viewing 15 posts - 751 through 765 (of 1,219 total)