It’s a very old bad thing of SQLServer, but each time I need this I have to loose an hour to find the correct syntax. Open Microsoft Query Analyzer if you have SQL Server 2000 or Microsoft Management Studio if you are using SQL Server 2005; note that you can manage SQLServer 2000 servers from [...]
Split a DataSet DataTable into more DataTables
for – To split a DataTable into more DataTables you need to process table rows with a loop, you know how many rows you have, so for loop is the choice. Clone – The fastest method to create tables with original columns structure is Clone method. ImportRow – In order to preserve rows states while [...]
How to import in Excel from SQLite ODBC Driver
I founded some problems with SQLite ODBC Driver importing into Excel, but the problem is Excel; basically Excel doesn’t see tables becouse it thinks tables are all system tables. We are talking about Microsoft. So here steps to solve: From Excel click Data/Import external data/New query on database Now select your SQLite ODBC driver, a [...]