How can write a delete script from the table

Question

I have a customer table with the follwing structure and records. I would like to write a delete script inside a stored procedure but make have to make sure the number of record from the select statement and delete statement are equal if not it should go to rollback . please can you help

Answer 1

That's to less on information.
Please post table design as DDL, some sample data as DML statement and the expected result.

Answer 2

Hi @Polachan Paily

I have a customer table with the follwing structure and records.

I didn't see your customer table or any records. Please edit your issue.

make sure the number of record from the select statement and delete statement are equal if not it should go to rollback .

Check this sample:

DECLARE @full_table_count1 int  
DECLARE @full_table_count2 int  
DECLARE @select_Count int  
DECLARE @delete_Count int  
  
BEGIN TRANSACTION DELETE_DATA  
  SELECT @full_table_count1 = COUNT(*) FROM table_name   
  
  SELECT @select_Count = COUNT(*) FROM table_name WHERE <add conditions here>  
    
  DELETE FROM table_name WHERE <add conditions here>  
  
  SELECT @full_table_count2 = COUNT(*) FROM table_name  
  
  SET @delete_Count = @full_table_count1 - @full_table_count2  
    
  IF @delete_Count <> @select_Count  
    BEGIN   
      ROLLBACK TRANSACTION   
      PRINT 'Records of select statement and delete statement are equal'  
    END  
  ELSE  
    BEGIN  
      COMMIT TRANSACTION   
      PRINT 'Delete successfully'  
    END  

Of course, it may not match your request, and it would be better if you could supplement the question more complete.

Best regards,
LiHong