Insert Command: INSERT INTO Customers (CompanyName, FirstName, LastName, Address, City, StateOrProvince, PostalCode, Country, Phone, Fax, Email, Notes, BillName, BillAddress, BillCity, BillState, BillZip, CellorPager, InternetCustomerNo) VALUES (@CompanyName, @FirstName, @LastName, @Address, @City, @StateOrProvince, @PostalCode, @Country, @Phone, @Fax, @Email, @Notes, @BillName, @BillAddress, @BillCity, @BillState, @BillZip, @CellorPager, @InternetCustomerNo); SELECT CustomerID, CompanyName, FirstName, LastName, Address, City, StateOrProvince, PostalCode, Country, Phone, Fax, Email, Notes, BillName, BillAddress, BillCity, BillState, BillZip, CellorPager, InternetCustomerNo FROM Customers WHERE (CustomerID=last_insert_id()) Update Command: UPDATE Customers SET CompanyName=@CompanyName, FirstName=@FirstName, LastName=@LastName, Address=@Address, City=@City, StateOrProvince=@StateOrProvince, PostalCode=@PostalCode, Country=@Country, Phone=@Phone, Fax=@Fax, Email=@Email, Notes=@Notes, BillName=@BillName, BillAddress=@BillAddress, BillCity=@BillCity, BillState=@BillState, BillZip=@BillZip, CellorPager=@CellorPager, InternetCustomerNo=@InternetCustomerNo WHERE (CustomerID=@Original_CustomerID) AND (CompanyName=@Original_CompanyName or (CompanyName IS NULL and @Original_CompanyName IS NULL)) AND (FirstName=@Original_FirstName or (FirstName IS NULL and @Original_FirstName IS NULL)) AND (LastName=@Original_LastName or (LastName IS NULL and @Original_LastName IS NULL)) AND (Address=@Original_Address or (Address IS NULL and @Original_Address IS NULL)) AND (City=@Original_City or (City IS NULL and @Original_City IS NULL)) AND (StateOrProvince=@Original_StateOrProvince or (StateOrProvince IS NULL and @Original_StateOrProvince IS NULL)) AND (PostalCode=@Original_PostalCode or (PostalCode IS NULL and @Original_PostalCode IS NULL)) AND (Country=@Original_Country or (Country IS NULL and @Original_Country IS NULL)) AND (Phone=@Original_Phone or (Phone IS NULL and @Original_Phone IS NULL)) AND (Fax=@Original_Fax or (Fax IS NULL and @Original_Fax IS NULL)) AND (Email=@Original_Email or (Email IS NULL and @Original_Email IS NULL)) AND (Notes=@Original_Notes or (Notes IS NULL and @Original_Notes IS NULL)) AND (BillName=@Original_BillName) AND (BillAddress=@Original_BillAddress or (BillAddress IS NULL and @Original_BillAddress IS NULL)) AND (BillCity=@Original_BillCity or (BillCity IS NULL and @Original_BillCity IS NULL)) AND (BillState=@Original_BillState or (BillState IS NULL and @Original_BillState IS NULL)) AND (BillZip=@Original_BillZip or (BillZip IS NULL and @Original_BillZip IS NULL)) AND (CellorPager=@Original_CellorPager or (CellorPager IS NULL and @Original_CellorPager IS NULL)) AND (InternetCustomerNo=@Original_InternetCustomerNo or (InternetCustomerNo IS NULL and @Original_InternetCustomerNo IS NULL)); SELECT CustomerID, CompanyName, FirstName, LastName, Address, City, StateOrProvince, PostalCode, Country, Phone, Fax, Email, Notes, BillName, BillAddress, BillCity, BillState, BillZip, CellorPager, InternetCustomerNo FROM Customers WHERE (CustomerID=@Original_CustomerID) Delete Command: DELETE FROM Customers WHERE (CustomerID=@Original_CustomerID) AND (CompanyName=@Original_CompanyName or (CompanyName IS NULL and @Original_CompanyName IS NULL)) AND (FirstName=@Original_FirstName or (FirstName IS NULL and @Original_FirstName IS NULL)) AND (LastName=@Original_LastName or (LastName IS NULL and @Original_LastName IS NULL)) AND (Address=@Original_Address or (Address IS NULL and @Original_Address IS NULL)) AND (City=@Original_City or (City IS NULL and @Original_City IS NULL)) AND (StateOrProvince=@Original_StateOrProvince or (StateOrProvince IS NULL and @Original_StateOrProvince IS NULL)) AND (PostalCode=@Original_PostalCode or (PostalCode IS NULL and @Original_PostalCode IS NULL)) AND (Country=@Original_Country or (Country IS NULL and @Original_Country IS NULL)) AND (Phone=@Original_Phone or (Phone IS NULL and @Original_Phone IS NULL)) AND (Fax=@Original_Fax or (Fax IS NULL and @Original_Fax IS NULL)) AND (Email=@Original_Email or (Email IS NULL and @Original_Email IS NULL)) AND (Notes=@Original_Notes or (Notes IS NULL and @Original_Notes IS NULL)) AND (BillName=@Original_BillName) AND (BillAddress=@Original_BillAddress or (BillAddress IS NULL and @Original_BillAddress IS NULL)) AND (BillCity=@Original_BillCity or (BillCity IS NULL and @Original_BillCity IS NULL)) AND (BillState=@Original_BillState or (BillState IS NULL and @Original_BillState IS NULL)) AND (BillZip=@Original_BillZip or (BillZip IS NULL and @Original_BillZip IS NULL)) AND (CellorPager=@Original_CellorPager or (CellorPager IS NULL and @Original_CellorPager IS NULL)) AND (InternetCustomerNo=@Original_InternetCustomerNo or (InternetCustomerNo IS NULL and @Original_InternetCustomerNo IS NULL))