Database

create table tbl_teachers (<br />
teach_id int AUTOINC NEXTVALUE 1 STEP 1,<br />
teach_fname text,<br />
teach_lname text,<br />
teach_add text,<br />
teach_unit_num text,<br />
teach_city text,<br />
teach_state text,<br />
teach_zip int,<br />
teach_instruments text,<br />
teach_email text,<br />
teach_phone int,<br />
teach_cell int,<br />
primary key(teach_id));

Msg 102, Level 15, State 1, Line 3<br />
Incorrect syntax near 'AUTOINC'.

 1: CREATE PROCEDURE ProductsUpdate
 2: (
 3:         @ProductID int,
 4:         @Name varchar(40),
 5:         @Concurrency timestamp
 6: )
 7: AS
 8:     UPDATE
10:         Products
11:     SET
12:         ProductName = @Name
13:     WHERE
14:         ProductID = @productID AND
15:         Concurrency = @Concurrency
16:     -- Is it possible to have another SP or query change @@ROWCOUNT at this point?
17:     return @@ROWCOUNT

1: UPDATE
2:     Products
3: SET
4:     ProductName = @Name
5: WHERE
6:     ProductID = @productID AND
7:     Concurrency = @Concurrency;
8: -- Can any other query or SP get in here and alter @@ROWCOUNT?
8: SELECT @@ROWCOUNT

"Execution Canceled by user"