Viewing 15 posts - 1 through 15 (of 49 total)
L' Eomot Inversé (2/9/2012)
I wonder what SQL Server does about victim selection when all processes involved have the same deadlock priority (which will be most of the time, I imagine).
It...
February 13, 2012 at 4:04 am
Are you specifying a date in your WHERE clause? If so, then the format you are passing might not match the format for your default language - e.g. if...
February 5, 2010 at 8:10 am
February 4, 2010 at 1:16 am
Simon Liddle (2/3/2010)
I thought that the dynamic SQL would execute and the results from the last statement - the delete statement would be inserted.
...and that is nonsense the more I...
February 3, 2010 at 3:45 am
Interesting question - I guessed 0 rows - I thought that the dynamic SQL would execute and the results from the last statement - the delete statement would be inserted....
February 3, 2010 at 3:35 am
Joy Smith San (2/3/2010)
February 3, 2010 at 3:32 am
sjimmo (1/29/2010)
I opened an OSQL session in DOS to a SS2K5 box, and running the code as is got the 0,1 answer.
BUT - how many...
January 29, 2010 at 9:00 am
Not related to the debate about the quality of QotD, but if I try running SELECT @@ROWCOUNT using osql against SQL2000 it returns my SPID! Any idea why?
(It works...
January 29, 2010 at 8:57 am
The question HAS been changed. As well as that, my answer (which was 0,1 previously) is now showing as 1,1 (and is still marked correct)! :w00t:
January 29, 2010 at 8:51 am
Irish Flyer (1/29/2010)
When you open a new query window, an immediate @@ROWCOUNT will always return a 1. This is an incorrect return
Sorry to split hairs, but I disagree that...
January 29, 2010 at 7:24 am
Just to take this one step further from my previous comment about it depending on the client tool....
If you profile QA as you connect to the server, you will see...
January 29, 2010 at 2:06 am
It seems to depend on the client tool, not the server - I tried this with both QA and SSMS against a SQL 2000 server - QA returned 1,0 as...
January 29, 2010 at 1:52 am
If you need to do this, the following should work:
DECLARE @table1 TABLE (source VARCHAR(10), criteria VARCHAR(1))
DECLARE @table2 TABLE (source VARCHAR(10), criteria VARCHAR(1))
INSERT INTO @table1 (source, criteria) VALUES ('Table1', '1')
INSERT INTO...
January 21, 2010 at 2:11 am
Just to take it one step further, the changes to Lutz's code below will bring it to the current date:
declare @customer table (customerid varchar(8))
declare @startdate datetime
declare @maxdate INT
insert into @customer...
January 21, 2010 at 2:03 am
Where do @SysObjectTest and @SysObjectTableName come from? If they both come from data in another table, then you may be able to do this using a join rather than...
January 14, 2010 at 2:02 am
Viewing 15 posts - 1 through 15 (of 49 total)