Viewing 15 posts - 43,396 through 43,410 (of 49,571 total)
You can't alter the system resourse database. It's not visible and can't be modified. In SQL 2005, the files must be in the same location as master.
November 2, 2008 at 11:56 pm
gints.plivna (11/2/2008)
So AFAIK as Jeff already said in this case TOP 1 without order by functionally does the same.
Providing you don't mind which rows you get back, yes.
November 2, 2008 at 12:38 pm
All that means is that you can't use the STOPAT command if there was a bulk operation within the log backup that covers the time requested.
If log backups occur at...
November 2, 2008 at 5:53 am
Run the log backup job every 15 min from midnight. That's probably the safest way. Log backups aren't blocked by full backups in SQL 2005. even if they were, the...
November 2, 2008 at 1:58 am
gints.plivna (11/1/2008)
GilaMonster (10/3/2008)
There's no direct equivalent. SQL doesn't have the concept of a row's position in the table.
BTW rownum has nothing to do with the row position in table. Rownum...
November 1, 2008 at 2:15 pm
Grant Fritchey (11/1/2008)
November 1, 2008 at 1:21 pm
After an encounter with auditors that resulting in the entire DBA team receiving verbal warnings and been threatened with dismissal if we ever allowed an audit to fail again, I...
November 1, 2008 at 1:18 pm
Bear in mind that if you lessen the checkpoint frequency you're going to increase the impact it has on your system. If it runs less often then when it does...
November 1, 2008 at 1:10 pm
Now things make sense....
CREATE PROCEDURE [dbo].[LoadGalery]
(@rowNumber INT)
AS
WITH Im AS (
SELECT Id,Name,Tag,ROW_NUMBER() OVER(ORDER BY Name DESC)AS RowNumber FROM Galery ...
November 1, 2008 at 4:00 am
Continued here - http://www.sqlservercentral.com/Forums/Topic595406-8-1.aspx
November 1, 2008 at 3:54 am
dr_csharp (11/1/2008)
i mean i need to select max(rownumber) and other fields but you are going to...
November 1, 2008 at 3:35 am
The first one throws an error because the last select refers to a table that doesn't exist. The derived table myTable is just a named subquery and it doesn't persist...
November 1, 2008 at 3:31 am
Please post in the correct forum in the future. This is the SQL 2000 forum and CTEs doen't exist on SQL 2000
November 1, 2008 at 3:24 am
Try this.
DECLARE @state BIT
SET @state='0'
;WITH Im AS (
SELECT Id,Name,Tag,ROW_NUMBER() OVER(ORDER BY Name DESC)AS 'RowNumber' FROM Galery ...
November 1, 2008 at 3:20 am
Does it throw an error? If so, what error? Does it give unexpected results?
November 1, 2008 at 2:52 am
Viewing 15 posts - 43,396 through 43,410 (of 49,571 total)