Method 1: Using the Select INTO Statement
Here is a Training Kit for Visual Studio 2010. Download it Free.
File Splitter Utility in C#
I had to come across a situation where I had to cut a large single .csv file containing 2.2 Million records into smaller files. Initially I thought of using already available split tool to do it, but then decided to write my own File Splitter tool in C#. Thats how I came up with this tool. The File Splitter Tool takes an input file and splits it into multiple files each containing the number of records you specify. Here is the source code for the tool.
If you have been working in Visual Studio 2005 or later, you sure would come across a file with the extension .vshost.exe. You should find this file under the bin folder or the debug folder of your application.
If you open a very large file in Excel it might not open up fully. For instance, I tried opening up a .csv file of 480MB and which had 2.2M records it would not open up completely. The reason is Excel has a limit of 1,048.576 rows and 16, 384 columns it can have in a file.
I am trying to run Queries in MS SQL Server and it comes up with errors if I specify table names or column names in a different case. The query is case-sensitive….!!!!
We find both bool and Boolean types in C#. It just made me wonder if there is any difference between the two types. It appears there is no difference between the two as both Represent the Boolean Type. So bool is just an alias to the System.Boolean type.
If you are using the SQLCMD utility and want to avoid or suppress the column header in the output of SQL Script. You can do it just by setting the Variable SQLCMDHEADERS to -1 by default its 0
As you use StreamReader to manipulate Text files and read one line at a time using Readline() Method you might come across a situation where you are somewhere in the middle of the Stream say on the 5th line and want to go back to the begin of the Stream. You can do that using the Seek Method on the BaseStream of the StreamReader as in this example.
Use a Scatter-Gather that broadcasts a message to multiple recipients and re-aggregates the responses back into a single message.
The Scatter-Gather routes a request message to the a number of recipients. It then uses an Aggregator to collect the responses and distill them into a single response message.