sql - How to Solve Error on this code -

sql - How to Solve Error on this code -

create table item ( itemcode char(2) primary key, itemname varchar(20) not null, unit_measure varchar(10) check (unit_measure in ('mtr','kg','tonn','ltr','nos')), rate number(10,2) check (rate > 0), stock number(10,2), minstock number(10,2), maxstock number(10,2), drawingsp varchar(10) default 'dr1000', check (store between minstock , maxstock) );

create table item ( itemcode char(2) primary key, itemname varchar(20) not null, unit_measure varchar(10) check (unit_measure in ('mtr','kg','tonn','ltr','nos')), rate numeric(10,2) check (rate > 0), stock numeric(10,2), minstock numeric(10,2), maxstock numeric(10,2), drawingsp varchar(10) default 'dr1000', check (stock between minstock , maxstock) ); there no type number in sql server --> chnage numeric there no column store --> alter stock

sql sql-server-2008