0

I'm making a webform of a hospital in VS-2012 using three-tier architecture. And I'm using MS-SQL Server 2014. Also, I'm new to the coding so it will be really helpful if the answer is given without using any jargons. Thanks.

1.contains picture of the form . [1]: https://i.stack.imgur.com/tOhGh.png.

[2]: https://i.stack.imgur.com/DrB4e.png and this is the coding behind the last two columns in the form, i.e, preferred time and specialty. As you see the values for the preferred time is day and night only and for the specialty, there are different departments involved.

  1. Now, I want to CREATE A STORED PROCEDURE which will insert the data into the appointment table given here [3]: https://i.stack.imgur.com/wtLqA.png according to the shift and specialty. Also, it is important to fetch the doctor_id from the doctor table [4] https://i.stack.imgur.com/UKV5W.png according to the shift and specialty. Is there any way I can do it?

Thank you.

ilkerkaran
  • 4,214
  • 3
  • 27
  • 42
Sheetal Bhadauriya
  • 17
  • 2
  • 2
    People are very unlikely to click external links. The more text the better, but if pictures are to be used please include them in the content of your question (so we can see them). – mjwills Aug 02 '18 at 13:34
  • Can you focus your question to something specific? Surely you're not simply asking how to write an INSERT. – Tab Alleman Aug 02 '18 at 13:37
  • Pretty sure that just about all you need can be found here. https://learn.microsoft.com/en-us/sql/t-sql/statements/insert-transact-sql?view=sql-server-2017 – Sean Lange Aug 02 '18 at 13:51

0 Answers0