Viewing 9 posts - 16 through 24 (of 24 total)
I have mater and child tables. Mater table has primary key and detail table has index on detail field. Detail table is large.
select *
from mdan m
left join all_rlists r
on...
May 26, 2004 at 9:07 pm
What is isolation level of your transaction and what resources it locking?
if
SET TRANSACTION ISOLATION LEVEL SERIALIZABLE
go
begin tran
insert into dbo.LSKLADI values(0,0,0,'qwe','qwe')
WAITFOR DELAY '00:00:20:000'
rollback tran
than in other connections I can't...
May 25, 2004 at 5:03 am
Hi.
I do not professional in that, but have to aks you.
How you invoke sp_OACreate? Did you use context argument? Maybe you have to use it with value 4 only?
May 24, 2004 at 9:08 pm
I has done a SQL routing that tries to capture Malyutin Slava and Malyutin Salava. Within it I can set a number of errors. That script is not small. If...
May 20, 2004 at 9:42 pm
I has done a SQL routing that tries to capture Malyutin Slava and Malyutin Salava. That is my name (mSlava). But russian name has third-part, therefore it routing tries to...
May 20, 2004 at 9:38 pm
Hi.
If ProductNumber is primary key column, Query Optimizer using Merge Join algorithm. There is no something better I think.
Probably, better is using 3 columns in application dataset like:
rs.Open "Select * from...
May 20, 2004 at 9:15 pm
Sorry for English.
Yes, It is great. But I don't understand when that OLE Object is installed. Probably with Win. If you know it, please tell me.
May 20, 2004 at 3:13 am
Not all declared will be used!
DECLARE @object int
DECLARE @hr int
DECLARE @property varchar(255)
DECLARE @return varchar(255)
DECLARE @src varchar(255), @desc varchar(255)
-- Create an object.
EXEC @hr = sp_OACreate 'Scripting.FileSystemObject', @object OUT
IF @hr <> 0
BEGIN
...
May 19, 2004 at 10:11 pm
Viewing 9 posts - 16 through 24 (of 24 total)