Write the Stored Procedure To Insert The Data in All the 3 tables ?
I have 3 tables Customer, Product And Sales Tables With Columns corresponding constraints as below:
Customer Table:
---------------
CustomerID int PrimaryKey
CustomerName Varchar
Product Table:
--------------
ProductID int identity PrimaryKey
ProductName varchar
Price decimal
Quantity int
Sales Table:
------------
SalesID int identity PrimaryKey
CustomerID int ForiegnKey
Quantity int