1
Answer

How to make normal sql query to dynamic sql query?

Sujeet Raman

Sujeet Raman
4y
470
1
Hi i have normal sql query like:
  1.  'SELECT @studentKey = studentKey , @teacherKey = teacherKey , @name= name, @course= course, @stnumber= stnumber FROM  #temptbl  WHERE ID = @id'   
  2.    
  3. @studentKey int  
  4. @teacherKey  int  
  5. @name VARCHAR(4000),  
  6. @course VARCHAR(4000),  
  7. @stnumber int  
  8. @id int
Answers (1)
Next Recommended Forum