Can we pass two sql queries for two different database table at a time.

Question

1.00/5 (2 votes)

See more:

hi buddy
Can we pass two sql queries for button(select and insert) at a time.

Thanks

Posted 5-Aug-14 23:50pm

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Amol_B · Accepted Answer · 2014-08-06T00:28:00

Hi
if i understand it correctly, you can write a single Stored procedure for insert and update

SQL

IF EXISTS(SELECT ID from Table where ID=@PK)
BEGIN
	--Update Query
	UPDATE Table Set ....
	WHERE ID=@PK
END
ELSE
	---Insert Query

Posted 6-Aug-14 0:28am