CSV is a data exchange format that most software can export to, since it is a simple list of values separated by commas (hence the name). Spreadsheet programs like OpenOffice Calc, Microsoft Excel, Google Docs Spreadsheet and others commonly have an ‘Export to CSV’ option, often found under the File menu. There are scripts that…
Subscribe via RSS
If knowledge has instrinsic value, sharing it enriches us all.
Tag Archive: sql
Storing date without time in SQL Server 2005
The Problem Apparently Microsoft SQL Server 2005 doesn’t offer a data type that stores date only, which is all sorts of inconvenient. I am certain this was not merely an oversight, and that it was actually the result of carefully planning and design. I wish I knew what the reasoning was, though. From MSDN: datetime…
