Loading

How to make normal sql query to dynamic sql query?

Sujeet Raman

Hi i have normal sql query like:

'SELECT @studentKey = studentKey , @teacherKey = teacherKey , @name= name, @course= course, @stnumber= stnumber FROM #temptbl WHERE ID = @id'
@studentKey int
@teacherKey int
@name VARCHAR(4000),
@course VARCHAR(4000),
@stnumber int
@id int

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Nisha Regil6y ago
You can assign the select statement to a sql string variable, and execute it using sp_executesql.

Please refer to link below for more details.
https://www.sqlservertutorial.net/sql-server-stored-procedures/sql-server-dynamic-sql/