Viewing 4 posts - 3,631 through 3,635 (of 3,635 total)
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 4 posts - 3,631 through 3,635 (of 3,635 total)