Create Table statement
Database
3
Posts
3
Posters
0
Views
1
Watching
-
Hello, I want to write a sql statement to create a table with one field which is a decimal.But it doesn't work. I did the following Create Table Purchase (Name varchar,Amount numeric(10,2)) Prithaa
-
Hello, I want to write a sql statement to create a table with one field which is a decimal.But it doesn't work. I did the following Create Table Purchase (Name varchar,Amount numeric(10,2)) Prithaa
Actually you are not giving the size of varchar so by default it will take varchar(1) and you will not be able to insert the record which is greater than 1 character. You have to do like this:-
Create Table Purchase (Name varchar(50),Amount numeric(10,2))