There was a need to insert into a certain table, information about the table I take from here INFORMATION_SCHEMA. First, I recognize field names, data types.
Question: How to generate the corresponding INSERT request?
Procedure.
Vitalina
eleven one 2 eight
namak7 namak7
153 12
- It seems to me that generating a query is outside the SQL language. Additional resources, add-ins (PL) and other programming languages are needed. - BuilderC
|
1 answer
I decided myself. Created a @inert type @inert variable. Filled it with @insert = 'INSERT INTO table VALUES ("qwerty", "qwerty2")' and executed EXEC(@insert) . Everything turned out to be much easier than I thought. )
Vitalina
eleven one 2 eight
namak7 namak7
153 12
- 2Keep in mind that for such a trick, you need the rights of inserting into the table for the caller of the procedure. They are not always. - maxleo
- Everything is taken into account, I just completely forgot about exec (). - namak7
|