General information
Forum:
Microsoft SQL Server
Category:
Stored procedures, Triggers, UDFs
Title:
Hanging & missing data in result set
Hi everyone,
We encountered two anomaly's in SQL 6.5 SP4.
1) Running an SP which takes
2) Running an SP that misses some data in the result set.
Example 1)
Example 2)
create procedure xxx()with recompile
as
begin
if exists (select * from tempdb.dbo.sysobjects where name = "##tempMessages")
begin
drop table ##tempMessages
end
create table ##tempMessages
(
id decimal(3) identity not null,
ExtraData varchar(10) not null
)
insert ##tempMessages
(
ExtraData
)
select ExtraData
from Table
order by cc.Colorcode
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only