Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
cesark
Posting Yak Master
215 Posts |
 Posted - 2004-10-29 : 04:51:36
|
| Hi,I want to create a column in a table to store the product measurement with two digits after the decimal point, and I don’ t know which data type I have to choose. For example, a pencil measurement could be 15’52 centimeters. Later, with this column I want to make comparisons between product measurements. I have read that the ‘Numeric’ type is the best choice, What do you think? I create my tables with visual tools in SQL Server Enterprise Management, I never create my tables in Query Analizer with Sql language. Is it a bad practice? Or I can combine both systems? If so, (I can combine both systems), How can I open a table in Query Analyzer to modify the properties with Sql language?Thank you,Cesar |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2004-10-29 : 04:55:58
|
look at alter table in BOLdecimal(8,2) is your type of choice  EM does the same thing QA does, the only difference is that EM does it using GUI and in QA you have to type it yourself.Go with the flow & have fun! Else fight the flow  |
 |
|
|
cesark
Posting Yak Master
215 Posts |
Posted - 2004-10-29 : 05:35:38
|
| Ok, but to open the table in Query Analyzer to modify the properties (decimal(8,2)), How I have to do it? I tried ‘Object Examinator’ from the Query Analyzer tool bar, and then I have selected the table from the objects listed to the left, right click, and I chose something like ‘Create command sequence of the object in new window as’, and then ‘create’. But once the table ‘specifications’ is opened in a new window, I tried to modify my table column writing ‘ALTER’ instead of ‘CREATE’, and then pressing the above green button ‘Query Execute’, but it doesn’ t work, an error message says ‘incorrect syntax near '('.’ |
|
|
|
|
|
|
|
|
Create a table column to store product measurement