I upgraded a test server using the RTC version. Very few code changes were required. SQL 7 to SQL 2000 was difficult and SQL 2000 to...

The execution of the procedure, "exec dbo.add_child 1, 'me', 86 " is just a test of that procedure, add_child. The procedure was intended to show how to test for...

create table parents (id int not null primary key, name varchar(40))

go

create table child (parent_id int not null constraint FK_childs_parent foreign key references dbo.parents(id)

, name varchar(40) not null

, age tinyint null

,...

Thank you, Gail!

The work-around, adding the always null CBIVisitNumber to the include list, worked very well.

Thanks Gail.

I suspected that it is a "gap in functionality" but my query does not fit,

"[font="Times New Roman"]If the predicate of the query and the index is inverted...

Thank you for informing us that sp_executesql parameters may be OUTPUT parameters. I didn't find that anywhere in BOL.

Here is an example:

USE pubs

declare @sql nvarchar(3000)

declare @d datetime

set @sql =...