Hi Thomas,  Thanks for your response.

The revised code you suggested works like a charm. Wonderful!!!

Thanks again,

Scott Chang

UPDATE:

I changed "BookTitle varchar(25) NOT NULL," to "BookTitle varchar(50) NOT NULL," and I created 2 tables (Person and Book) sucessfully and saved them in the database newDB. I executed the following...

Hi,  I tried the revised code listed below:

USE

testDb

GO

ALTER

VIEW InventoryPublisherView

GO

CREATE

VIEW InventoryPublisherView

Hi barsuk,

No, I did not do the way you suggested. Instead, I deleteled the 3 DECLARE statements and corrected 1 small mistake (missing a coma in EXEC sp_updatedRecord 5, 'ER Vol1', 'VHS'...

Hello peterhe,

After I posted my last response, I tried to add more batch delimiter "GO" to my program and executed my revised program (listed below) and I...

Hi peterhe,

Your response is not helpful to me.  I feel I have the batch delimiter "GO" in the end of the program.  Where should I add more batch delimiter "GO"?

I am new...