Viewing 13 posts - 3,406 through 3,418 (of 3,418 total)
I haven't checked either because I'm working in a pure development environment and at this stage is is all pretty hypothetical.
I will do some testing at a later stage to...
October 25, 2001 at 8:10 am
Thanks Guys
But what I was after was something like
SELECT @@ROWID,*
FROM Tbl_
WHERE @@ROWID BETWEEN 10 AND 20
I've seen your select TOP queries where a sub-query also has a TOP clause...
October 25, 2001 at 5:20 am
Yes definitely
When I did the SQL 6.5 courses I was lucky enough to be taught by a trainer with commercial dba and they stressed the importance of this.
One thing I...
October 15, 2001 at 1:55 am
October 8, 2001 at 3:15 am
I agree with using Hungarian notation for objects and variables.
I would NOT use it for anything that a user might see such as a column name.
I picked up the idea...
October 8, 2001 at 2:39 am
Trawling through the Microsoft site it turns out that this is a known bug when SQL is configured for Windows NT Authentication.
The work around is, as Andy recommended, to use...
September 28, 2001 at 3:57 am
Thanks.
I've tried that but it doesn't let me reassign the SA account back to the dbo user.
I'm a bit concerned that any further databases created all seem to have this...
September 26, 2001 at 9:08 am
I was recently asked to install some databases for a client and their support company specified that the database should be split into 3 filegroups.
1. PRIMARY - to be...
September 10, 2001 at 2:11 am
The problem is that the number of queries you need to write grows geometrically.
1 variable = 2 queries.
2 variables = 4 queries.
3 variables = 8 queries etc.
In other words the...
August 9, 2001 at 4:59 am
Just to clarify:-
The index is on ColA, ColB.
If the WHERE clause searches on ColA only will the index be used?
August 9, 2001 at 1:34 am
Yes, it works.
I read somewhere that evaluating NULLs has a performance hit, although I suspect it is very minor in this case
August 2, 2001 at 9:27 am
They say that lazy people take most pains!
I had seen a syntax for an INSERT statement that went something like:-
INSERT Tbl_X
EXECUTE Sp_Y
Where Sp_Y returns a recordset.
I was wondering if there...
August 2, 2001 at 6:54 am
Here is the same thing avoiding CURSORs.
Use Test
GO
Declare @MyRecipients nvarchar (255)
Declare @MyMessage nvarchar (255)
Set @MyRecipients=''
Set @MyMessage = ‘Your timesheet is overdue, please send it ASAP.'
WHILE @MyRecipients IS NOT NULL
...
July 16, 2001 at 4:51 am
Viewing 13 posts - 3,406 through 3,418 (of 3,418 total)