3
Reply

Stored Procedure

Priyank

Priyank

Nov 22 2012 1:39 PM
1.8k
Location (Location_id  int,  Location_name  nvarchar(50))

Sales  (id int  ,Date_of_order date, Amount int,  Location_id int)

Location_id is foreign key in sales.

How to insert n values into Sales table.All elements should b added randomly using random or any function which generates random numbers

Answers (3)