Priyank

Priyank

  • NA
  • 503
  • 2k

Stored Procedure

Nov 22 2012 1:39 PM
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)