Example BCP export and import commands

The Microsoft Bulk Copy Utility, BCP.exe, can be used to copy data from a table in one SQL Server instance to the same table in another SQL Server instance. Since the BCP Utility is designed…

Language used by the SQL Server binaries

SQL Server binaries come in various languages, such as 日本語 (Japanese), French, and English. It’s pretty easy to determine the language once SQL Server is *running*. A simple query does the trick:

However, if…

How do I store a number with leading zeros?

Many line-of-business applications want to store document numbers with leading zeros, such as an Invoice Number, or Cheque Number. The idea behind having the leading zeros is we’ve predefined the format for the document number…