leading zeros - SQL Server Forums

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.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

leading zeros

Author

Topic

jcb267
Constraint Violating Yak Guru

291 Posts

Posted - 2009-03-18 : 16:29:22

I am attempting to import a file (.csv) to a sql 2005 database. During the import process, I am losing leading zeros. How can I prevent this?

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2009-03-18 : 16:31:07

See http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=122003

E 12°55'05.63"
N 56°04'39.26"

jcb267
Constraint Violating Yak Guru

291 Posts

Posted - 2009-03-18 : 16:32:58

quote:
Originally posted by Peso

See http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=122003

E 12°55'05.63"
N 56°04'39.26"

OK, thanks.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources