Information générale
Forum:
Microsoft SQL Server
Versions des environnements
SQL Server:
SQL Server 2005
>I'm using bcp to copy some data to a csv file.
>
>Phone numbers which have been entered without a space are losing their leading zero.
>
>Whats the best way to stop happening.
>
>Phone numbers with an embedded space are ok
>
>so 07887734045 comes out as 7887734045
>
>07995 634910 comes out correctly
>
Going from memory, I think you need to format the column as character instead of nuimeric in the CSV file. You can do that with Excel.
You sure are immersed in SQL Server. How did this come about? It's going to look good on your resume. Sorry, your CV ;-)
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement