Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.
Course Of The Month
1 day, 18 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
For Any Use & On Any Platform
Contextual Guidance at the moment of need helps your employees/users adopt software o& achieve even the most complex tasks instantly. Boost knowledge retention, software adoption & employee engagement with easy solution.
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder. The folder can be on the local hard drive or on a network share. This batch file will query the SQL server to get the current date & time and wi…
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
NetCrunch network monitor is a highly extensive platform for network monitoring and alert generation. In this video you'll see a live demo of NetCrunch with most notable features explained in a walk-through manner. You'll also get to know the philos…
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.
Suggested Courses
Course of the Month1 day, 18 hours left to enroll
Earn Certification
Administering Microsoft SQL Server 2012 Databases (Exam 70-462)
$79.00$71.10
717 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.