How to insert multiple data into mssql without using loop?
i'm developing a clinic management system, while doctor may give few medicines to patient,therefo re i hope inside my database,the data will look like
Code:
|-----------------------------------|
|   RecordID  |  ItemID   |   Amount|
|-----------------------------------|
|      1      |     1     |    10   |
|      1      |     2     |    100  |
...