Multiple Record Delete in Sql server Single Transction

CREATE PROCEDURE [dbo].[Insert_Customers]
      @tblCustomers CustomerType READONLY
AS
BEGIN
      SET NOCOUNT ON;
     
     INSERT INTO Customers(CustomerId, Name, Country)
      SELECT Id, Name, Country FROM @tblCustomers -- In this Area i need delete from Email where EmailID=@tblCustomers

END

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.IO;

namespace Code.SearchFileContent
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }

        private void button1_Click(object sender, EventArgs e)
        {
            SearchFileContent(@"E:\Projects\Code.SearchFileContent\Code.SearchFileContent");
        }
        public void SearchFileContent(string pDirectoryPath)
        {
            // Modify this path as necessary. 


            // Take a snapshot of the file system.
            System.IO.DirectoryInfo dir = new System.IO.DirectoryInfo(pDirectoryPath);

            // This method assumes that the application has discovery permissions 
            // for all folders under the specified path.
            IEnumerable<system.io.fileinfo> fileList = dir.GetFiles("*.*", System.IO.SearchOption.AllDirectories);

            string searchTerm = @"Visual Studio";

            // Search the contents of each file. 
            // A regular expression created with the RegEx class 
            // could be used instead of the Contains method. 
            // queryMatchingFiles is an IEnumerable<string>. 

            // Execute the query.
            string ssss = string.Empty;
            Console.WriteLine("The term \"{0}\" was found in:", searchTerm);
            string fileText = string.Empty;
            string line;
            StringBuilder sb = new StringBuilder();
            
            foreach (FileInfo sss in fileList)
            {
                fileText += GetFileText(sss.FullName);
                label1.Text = sss.FullName;
                using (System.IO.StreamReader file = new System.IO.StreamReader(sss.FullName))
                {
                    int lineno = 1;
                    while ((line = file.ReadLine()) != null)
                    {
                        if (line.Contains("fileText += GetFileText(sss.FullName);"))
                        {
                            // This append the text and a newline into the StringBuilder buffer       
                            sb.AppendLine(sss.FullName +  "" + line.ToString() + lineno + Environment.NewLine);
                        }
                        lineno++;
                    }

                }

            }


            int counter = 0;

            label1.Text = "";
            textBox1.Text = sb.ToString();
            // Keep the console window open in debug mode.

        }

        // Read the contents of the file. 
        static string GetFileText(string name)
        {
            string fileContents = String.Empty;

            // If the file has been deleted since we took  
            // the snapshot, ignore it and return the empty string. 
            if (System.IO.File.Exists(name))
            {
                fileContents = System.IO.File.ReadAllText(name);

            }
            return fileContents;
        }
    }
}