To continue the previous post, this article demonstrates ways to do Upsert (update and insert) and how MERGE statement in SQL Server 2008 (or later) can be more efficient to perform the two operations at once. First we'll create a table for this demo. We want to do update if the Id is found on the table and insert if it's a new Id number. 1. Conventional way of doing it is by using IF … [Read more...]
Perform Update, Delete and Insert using Merge Statement
In SQL Server, a better way to perform insert, update, or delete operations on a target table based on the results of a join with a source table is by using one MERGE statement. UPDELSERT using MERGE statement It's more efficient as you're doing just one statement instead of three individual (UPDATE, DELETE, and INSERT) SQL queries. More examples can be found on the next posting, Ways … [Read more...]
How to Change Default Project Folder in SSMS
There are several ways to configure SSMS to point to your own working directory as the default. Here's the easiest to do it without registry hack. You just need to edit the Visual Studio settings file (XML format). Open Windows Explorer, and go to (you can force type): Find vssettings file with the latest modification date. The file name should follow the convention … [Read more...]
How to Find a Column Name in SQL Server Database
This query was originally appeared from SQL Authority Blog and I find it really useful when you need to find a column in any tables in a database. If you need to find all column names that are in the database, just comment out or delete the highlighted line from the SQL command above. Further Reading SQL SERVER – Query to Find Column From All Tables of Database … [Read more...]
Using Connection Coloring in SSMS Tools Pack
From previous posting, we demonstrated a way to use custom color coding using SQL Server Management Studio's (SSMS) Registered Servers properties. But using the feature can be very dangerous if you don't have the discipline to follow a strict process of opening new query from the registered servers pane. For example, if you use Change Connection button, the color will stay the same as the last … [Read more...]