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 |
hasanali00
Posting Yak Master
207 Posts |
Posted - 2005-07-22 : 07:42:15
|
I want to enter 0010000 into my column. What column type should I have. Initially, I tried with int (4) and bigint (8). But this truncates 0010000 to 10000.any ideas, please |
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2005-07-22 : 07:51:27
|
you need varcharor use int datatype and show that number by appending leading zeroes in the presentation layerMadhivananFailing to plan is Planning to fail |
|
|
hasanali00
Posting Yak Master
207 Posts |
Posted - 2005-07-25 : 11:48:20
|
even though this post is not directly related to sql server, lets see if u can help.Every time I enter 00100 in to Excell, it trims to 100. I have to go to Properties > Format Cell and choose 'Text' as the cell type.Now I can enter 00100. But every time I make a change to my file, the data goes back to 100.How can I get rid of this problem. Thanks |
|
|
Stalker
Yak Posting Veteran
80 Posts |
Posted - 2005-07-25 : 12:16:11
|
if I've correctly understood your problem, try to put comma - (') before your text, like '001000 and Excell will think about it as a text (you will see a green triange in the left upper corner of the cell) |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2005-07-26 : 01:44:25
|
did you highlight the entire column and choosing text as type?quote: Originally posted by hasanali00 even though this post is not directly related to sql server, lets see if u can help.Every time I enter 00100 in to Excell, it trims to 100. I have to go to Properties > Format Cell and choose 'Text' as the cell type.Now I can enter 00100. But every time I make a change to my file, the data goes back to 100.How can I get rid of this problem. Thanks
--------------------keeping it simple... |
|
|
|
|
|