You must Sign In to post a response.

04 May 2018 12:25

Joined:	11/12/2010
Level:	Silver
Points:	53

Points:	2

How to insert multiple records if not exists in table

Hi.
I have one table with columns, "Book", "Chapter".
Also, I have one screen from where, user can send records in bulk for insertion in above table.
I want to write a query to insert bulk records if not exists by comparing 2 columns.
Please help me.

#769578

07 May 2018 15:38

Joined:	13/01/2015
Level:	Silver
Points:	230

Points:	2

Hi Pranjal,

Such problems can be handled in sql server using Merge statement. You can check if record does not exist then Insert other wise perform some other work.

Using Merge you can insert,update,delete in a single statement.

Thanks!
Anjali

Thanks!
Anjali Bansal

~Give your best and lead the world

Submit New Thread

Return to Return to Discussion Forum

How to insert multiple records if not exists in table

About dotnetspider.com

Quick Links

General

Services