gunakar appala

gunakar appala

  • NA
  • 152
  • 805

How to insert multiple rows in a single query using a stored

Dec 3 2017 11:45 AM
  1. CREATE PROCEDURE Usp_insertgender       
  2. (  
  3. @gendervalues VARCHAR(MAX)) AS   
  4. BEGIN  INSERT INTO sparsha.dbo.Genders ([GenderName]  
  5. )       
  6. VALUES @gendervalues;   
  7.   
  8. END  
I want to execute procedure
execute Usp_insertgender (1),(2)  
but am getting error plz help me 

Answers (4)