I am inserting records after reading them from a CSV file & storing it in a data table variable.
If I want to insert static values then works fine for me but when I try to read the values from the above data table & then insert records one by one after checking some column data for validation then how to pass the variables that I defined to pass in my insert query
Ex of static data:- “Insert into [Health Care Records].[dbo].[DoctorDetails] ( [Doctor Name],[Doctor ID],[Doctor Available Days],[Doctor Location]
,[Doctor Timing] ,[Doctor Type]) values (‘Name’,‘ID’,‘Days’,‘Location’,‘Timing’,‘General’)”
But now I want to pass the data reading from the data table into this query, can someone guide me, please?