Task Manager for Hyper-V provides critical information that allows you to monitor Hyper-V performance by displaying real-time views of CPU and memory at the individual VM-level, so you can quickly identify which VMs are using host resources.
COURSE of the MONTH
12 days, 7 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
How to insert / update data into database in sqlserver
Posted on 2011-03-04
I have a table which contains data already.
Now i need to create some script which insert some data into the table
But befire insert the script, i have to validate the data is exist in the table or not.
If not exist thst script will insert otherwise it will update
Now i need to create some script which insert some data into the table
But befire insert the script, i have to validate the data is exist in the table or not.
If not exist thst script will insert otherwise it will update
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
5-
2
7 Comments
here is simple example.
IF EXISTS (SELECT 1 FROM table1)
UPDATE table1 set field1 = 'tosomething'
ELSE
INSERT INTO table1 (field1) VALUES ('tosomething')
IF EXISTS (SELECT 1 FROM table1)
UPDATE table1 set field1 = 'tosomething'
ELSE
INSERT INTO table1 (field1) VALUES ('tosomething')
Ya, thanks pdd1lan.
I used the following query.
If exists(select * from Translations where TNR_LANGUAGE = @TNR_LANGUAGE AND C_LABELNAME = @C_LABELNAME)
Begin
update Translations set C_TRANSLATEDSTRINGS = @C_TRANSLATEDSTRINGS where TNR_LANGUAGE = @TNR_LANGUAGE AND C_LABELNAME = @C_LABELNAME
End
Else
Begin
insert into Translations (TNR_LANGUAGE,C_LABELNAME,
End
I used the following query.
If exists(select * from Translations where TNR_LANGUAGE = @TNR_LANGUAGE AND C_LABELNAME = @C_LABELNAME)
Begin
update Translations set C_TRANSLATEDSTRINGS = @C_TRANSLATEDSTRINGS where TNR_LANGUAGE = @TNR_LANGUAGE AND C_LABELNAME = @C_LABELNAME
End
Else
Begin
insert into Translations (TNR_LANGUAGE,C_LABELNAME,
End
does your query work?
here are some suggestion:
-not hurt to have try... catch to capture any error might occur around your if statement.
-the way you do is fine, but might consider not to use "select *" when you just check for exist record, I suggest using "Select 1" instead.
If exists(select 1 from Translations where TNR_LANGUAGE = @TNR_LANGUAGE AND C_LABELNAME = @C_LABELNAME)
here is an article, might have better explanation why:
http://blog.sqlauthority.com/2008/02/26/sql-server-select-1-vs-select-an-interesting-observation/
here are some suggestion:
-not hurt to have try... catch to capture any error might occur around your if statement.
-the way you do is fine, but might consider not to use "select *" when you just check for exist record, I suggest using "Select 1" instead.
If exists(select 1 from Translations where TNR_LANGUAGE = @TNR_LANGUAGE AND C_LABELNAME = @C_LABELNAME)
here is an article, might have better explanation why:
http://blog.sqlauthority.com/2008/02/26/sql-server-select-1-vs-select-an-interesting-observation/
Featured Post
Benefit from a mission critical IT monitoring with Monitis Premium or get it FREE for your entry level monitoring needs.
-Over 200,000 users
-More than 300,000 websites monitored
-Used in 197 countries
-Recommended by 98% of users
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
In this brief tutorial Pawel from AdRem Software explains how you can quickly find out which services are running on your network, or what are the IP addresses of servers responsible for each service. Software used is freeware NetCrunch Tools (https…
This tutorial will teach you the special effect of super speed similar to the fictional character Wally West aka "The Flash"
After Shake : http://www.videocopilot.net/presets/after_shake/
All lightning effects with instructions : http://www.mediaf…
Suggested Courses
Course of the Month12 days, 7 hours left to enroll
777 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.