The Microsoft Access procedure contained within post, can be used to remove the “dbo_” prefix from all imported tables within a Microsoft Access Database. Saves doing them all by hand 🙂
The code within this post, is an example of how to retrieve the column/field names from the header row from a text file, and add them to a “ListBox”.
I was in the middle of writing an application to retrieve the list of Access Database Tables, but I was getting the error “The ‘Microsoft.Jet.OLEDB.4.0’ provider is not registered on the local machine.” I discovered, that as I was using Vista x64, I needed to change the “Advanced Compiler Options” in Visual Studio to target […]
If you are using SQL Server Integration Services (SSIS) to import data and want to record the row number against each record, then the Konesans Row Number Transformation product is exactly what you need. Please click here for more information about the Konesans Row Number Transformation product (http://www.konesans.com/rownumber.aspx).
When SQL Server is installed, the “tempdb” database is placed by default, on the same drive that SQL Server is installed on.
As this is usually the same drive as the operating system, it is best to move the “tempdb” database to a separate drive.
Whilst studying for my MCITP Database Developer certification, I have come across a very useful function that returns the value of the first non-NULL value from multiple choices
The default value of a parameter can be specified as NULL. In this case, if you do not supply a parameter, SQL Server executes the stored procedure according to its other statements. No error message is displayed.
The procedure definition can also specify that some other action be taken if you do not give a parameter.