Transact sql error message Msg 2715 Level 16 - Column, parameter, or variable #1: Cannot find data type NUMBER.
Msg 2715 Level 16 Example:
GO
CREATE TABLE products(
product_id NUMBER NOT NULL,
name VARCHAR(250) NOT NULL,
description VARCHAR(4000),
avaible VARCHAR(3),
price NUMBER );
GO
| Message |
|---|
| Msg 2715, Level 16, State 6, Line 1 |
| Column, parameter, or variable #1: Cannot find data type NUMBER. |
Modify number with numeric
GO
CREATE TABLE products(
product_id NUMERIC NOT NULL,
name VARCHAR(250) NOT NULL,
description VARCHAR(4000),
avaible VARCHAR(3),
price NUMERIC );
GO
| Message |
|---|
| Command(s) completed successfully. |