Hi acne.star52,
Please refer below SQL Query.
SQL
CREATE TABLE #PSCK0025
(
Emp_ID INT IDENTITY(1,1) PRIMARY KEY,
Emp_Name VARCHAR(50),
Emp_Code INT,
Emp_Date VARCHAR(50),
Emp_UID INT,
Emp_DateCode INT,
Emp_Password VARCHAR(20),
Emp_Amount INT,
Emp_M VARCHAR(20),
Emp_K VARCHAR(20)
)
CREATE TABLE #PSCK0026
(
CUST_ID INT IDENTITY(1,1) PRIMARY KEY,
CUST_NAME VARCHAR(50),
CUST_CODE INT,
CUST_UID INT,
CUST_TABLE INT,
CUST_AMOUNT INT,
CUST_PASS VARCHAR(50),
CUST_CITY VARCHAR(50),
CUST_COUNTRY VARCHAR(50),
)
INSERT INTO #PSCK0026 VALUES ('Sameer',1,45,4,5000,'Pass','Mumbai','India')
INSERT INTO #PSCK0026 VALUES ('Raj',1,45,4,5000,'Pass','Mumbai','India')
INSERT INTO #PSCK0025 values ('Sonu',4,'27/01/2018',106,9,'4567bdbs',10000,'M','k')
INSERT INTO #PSCK0025 values ('Rahul',4,'27/01/2018',106,9,'4567bdbs',10000,'M','k')
DECLARE @EmpId INT, @CustId INT
SET @EmpId = 1
SET @CustId = 1
DELETE FROM #PSCK0025
WHERE Emp_ID = @EmpId
DELETE FROM #PSCK0026
WHERE CUST_ID = @CustId
SELECT * FROM #PSCK0025
SELECT * FROM #PSCK0026
DROP TABLE #PSCK0026
DROP TABLE #PSCK0025
Screenshot
