Viewing 15 posts - 16 through 30 (of 102 total)
There is also a standalone patch for this bug. Check out microsoft.com Q323875 hotfix.
Paras Shah
Evision Technologies
Mumbai, India
January 27, 2003 at 2:21 pm
does this affect sql server 7 also? or does it affect only sql 2000 machines
Paras Shah
Evision Technologies
Mumbai, India
January 25, 2003 at 10:06 am
The first one seems to be perfect!
Thankx a lot!
Paras Shah
Evision Technologies
Mumbai, India
May 15, 2002 at 3:10 pm
But by this query you are getting 3 people from dept 2. Only 2 wanted
13vijay140001Home
16hitesh140001Home
18kiran270002Office1
19gautam270002Office1
20abhi280002Office1
23amit3110003Office2
24sunilr3120003Office2
quote:
SELECT*
FROM
Emp oQ
INNER JOIN
Dept
ON
oQ.deptid = Dept.deptid
WHERE
Salary IN (SELECT TOP...
May 14, 2002 at 9:55 pm
if exists (select * from sysobjects where id = object_id(N'[dbo].[Dept]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Dept]
GO
if exists (select * from sysobjects where id = object_id(N'[dbo].[Emp]') and OBJECTPROPERTY(id, N'IsUserTable')...
May 14, 2002 at 2:37 pm
this is what i'm hearing something new! Is it possible to create new response objects in ASP
quote:
You're sounding like a broken record.A...
May 12, 2002 at 10:45 pm
I have tried changing the contentype. But it does not change once set. I changed it first to image/gif and then when i want to write html text next to...
May 12, 2002 at 10:13 pm
Is MS frightened of not revealing SPs codes? 😉
Then better they encrypt them. Whats your opinion!
Paras Shah
Evision Technologies
Mumbai, India
May 12, 2002 at 2:00 am
Is MS frightened of not revealing SPs codes? 😉
Then better they encrypt them. Whats your opinion!
Paras Shah
Evision Technologies
Mumbai, India
May 12, 2002 at 1:58 am
This query can be used if you plan to use INTERSECT
USE pubs
GO
SELECT pub_name
FROM publishers
WHERE NOT EXISTS
(SELECT *
FROM titles
WHERE pub_id = publishers.pub_id
...
May 11, 2002 at 7:20 pm
Is this only to avoid CPU Overload. Or are there any other reason for such an advice from you?
quote:
In no case...
May 11, 2002 at 1:02 pm
Thankx, shall check out BOL for more info.
quote:
The cutoff point is whatever you set it. If you don't set it, then all...
May 11, 2002 at 12:37 pm
Ok, great! Thankx
quote:
In that case it really would be up to you. Sorry no help there but this runs into how much...
May 11, 2002 at 11:03 am
What if, I have the IIS and SQL Server on the same machine. That would avoid the trips over the hubs. Then what would have been your choice?
May 11, 2002 at 10:52 am
This seems to be great. But why so? and what do you mean by cut off rate? Is it 8000 chars ie. the max varchar length.
What I understand from...
May 11, 2002 at 10:47 am
Viewing 15 posts - 16 through 30 (of 102 total)