asked on How to insert / update data into database in sqlserver
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
Microsoft SQL Server 2008
Last Comment
pdd1lan
ASKER CERTIFIED SOLUTION
Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
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/
ASKER
pdd1lan,
Its working .
Thanks for ur kind of informations.
Its working .
Thanks for ur kind of informations.
Your help has saved me hundreds of hours of internet surfing.
fblack61
glad to hear
can you give points ?
??
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
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