Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 2 of 2
  1. #1
    New to the CF scene
    Join Date
    Apr 2010
    Location
    bahrain
    Posts
    7
    Thanks
    0
    Thanked 0 Times in 0 Posts

    sql server stored procedure problem

    If you have three tables, customer table, saleOrder table and saleOrderItem table. And you wanna delete from salesOrders and related SalesOrderItems which belongs to specific customer “by customer id” and sales order items table not cascade in delete with sales order. How are you going to delete the data from both tables in one stored procedure?

    Thanks

    Waqar

  • #2
    New Coder
    Join Date
    Feb 2008
    Location
    @ God's Own Country
    Posts
    57
    Thanks
    3
    Thanked 5 Times in 5 Posts

    Smile

    Hi,
    Can you please specify schema (structure) of three tables?
    ---
    By
    Sreejith.P.M


  •  

    Tags for this Thread

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •