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 |
|
ravigupta
Starting Member
2 Posts |
 Posted - 2010-08-27 : 00:45:41
|
| want "01" insted of "1" in column of type bigint |
|
|
pk_bohra
Master Smack Fu Yak Hacker
1182 Posts |
Posted - 2010-08-27 : 00:57:40
|
| Then u need to convert it to varchar or char type and append "0" on left side. |
 |
|
|
ravigupta
Starting Member
2 Posts |
Posted - 2010-08-27 : 01:04:31
|
quote:
Originally posted by pk_bohra
Then u need to convert it to varchar or char type.
is it not possible by bigint datatype |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2010-08-27 : 02:53:31
|
| That's a formatting issue, not a storage issue. Do it in the query that returns the data or in the front end app.--Gail ShawSQL Server MVP |
|
|
|
landuan
Starting Member
3 Posts |
Posted - 2010-08-30 : 05:43:08
|
| <spam removed> |
|
|
|
|
|
|
want "01" insted of "1" in column of type bigint