There is a great way to insert multiple rows into a Microsoft SQL Server database in one statement. This notation has multiple advantages: simplicity and the grouping of multiple instructions into one transaction. INSERT MyTable (name, description)VALUES(‘John’, ‘Manager’),(‘Bill’, ‘Truck driver’) Script from Ernie Cruz
Category Archives: Software Development
The ‘Microsoft.ACE.OLEDB.12.0’ provider is not registered on the local machine. (System.Data)
When you try to import Excel 2007 or later “.xlsx” files into an SQL Server 2008 database you may get the following error mesage : The ‘Microsoft.ACE.OLEDB.12.0’ provider is not registered on the local machine. (System.Data) To solve this problem install the appropriate version of the Microsoft Access Database Engine. On 32 bit …
How to open SQL files in Visual Studio 2012
The default installation of Visual Studio 2012 cannot open SQL documents when you double click on them in Source Control Explorer. To be able to do that you have to install the SQL Server Data Tools for Visual Studio 2012 Open the ” December 2012″ update page at http://msdn.microsoft.com/en-us/jj650015 Download and install SSDTSetup.exe by clicking Download …
Continue reading “How to open SQL files in Visual Studio 2012”
Add if conditional statement to the Visual Studio pre-build and post-build events
There are times when you want to execute statements in the pre-build and post-build events of a Microsoft Visual Studio project when certain conditions met. In the next example we will copy the environment specific config file to the web application folder if the configuration is set to “Local”. To edit the pre-buld and post-buld …
Continue reading “Add if conditional statement to the Visual Studio pre-build and post-build events”
How to add the Config folder to a Microsoft Visual Studio project even if the folder is not in the project directory
Corporations maintain multiple server environments for development, testing and production purposes. All of these environments require specific settings to connect to the databases and other resources. When the build master builds the application for the specific environment the build process has to select the appropriate configuration and build it into the installer file for deployment. …
Create a backup of a Microsoft SQL Server database to a location outside of the database server
The Microsoft SQL Server Management Studio 2008 user interface only allows you to create a backup of a database to one of the local drives of the database server. To create a backup of a Microsoft SQL Server database to a location outside of the database server execute the following SQL script: BACKUP DATABASE MyDatabase TO …
How to enable jQuery intellisense in Microsoft Visual Studio
To enable jQuery intellisense in Microsoft Visual Studio Open the _references.js file in the editor by double clicking it Drag the jquery-x.x.x.intellisense.js file into the _references.js file in the editor. The name of the file will be added to the _references.js file
Microsoft Visual Studio editor settings
There are some settings that can make your work easier in Visual Studio. Start Microsoft Visual Studio, and in the “Tools” menu select “Options” – To insert new tabs to the right of existing tabs and keep the already opened tabs in place and – Show pinned tabs in a separate row On the left …
Unable to open a setup project in Microsoft Visual Studio 2010 on Windows 7 64 bit
I work on multiple computers using different operating systems. When I tried to open a web service solution in Microsoft Visual Studio 2010 on my Windows 7 64 bit workstation I got the following error message: “The project file … has been moved, renamed or is not on your computer.” I could verify that the …
How to set the application pool automatically during Microsoft Visual Studio 2010 web application and web service deployment
During the Visual Studio 2010 Web Application and Web Service deployment the prior setting of the application pool name is lost. The installer does not assign the correct application pool to the virtual directory, it will be assigned to the Default Application Pool. If different .NET versions are assigned to the same application pool, the older .NET applications stop …