Hi
iam using sql server 2008 to deal with my DB, i have a column with 'int' data type when i insert number inside that column like "0025648" it return it to me "25648" without zeros why ? and how to solve this problem ?
Best Regard
IT_Techno
Hi
iam using sql server 2008 to deal with my DB, i have a column with 'int' data type when i insert number inside that column like "0025648" it return it to me "25648" without zeros why ? and how to solve this problem ?
Best Regard
IT_Techno
Jump to PostAn integer column has no formatting so the zeroes are useless to it. Is there a reason you need it stored in the database like that? Adding zeroes is just a presentation issue.
An integer column has no formatting so the zeroes are useless to it. Is there a reason you need it stored in the database like that? Adding zeroes is just a presentation issue.
I have changed my column datatype to "NVARCHAR", it's go on thnks for replay
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, learning, and sharing knowledge.
You're trying to visit a URL that doesn't currently exist on the web. Most likely, a member posted a link a long time ago to a web page that has since been removed. It's also possible that there was a typo when posting the URL. We redirect you to this notice instead of stripping out the link to preserve the integrity of the post.