Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Dynamic Insert procedure

Status
Not open for further replies.
Denaeghel

Denaeghel

Programmer
Apr 23, 2001
61
BE
Is it possible to write a stored procedure that can insert information where the column name is variable?

Thanks

Karel karel.denaeghel@barco.com
 
Sort by date Sort by votes

I think you might have to create your query in a string within the procedure, then use the exec function to run it.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

WomanPro
  • Locked
  • Question
Insert into query adds records to unreadable format, how do I change that? 1
Replies
5
Views
234
Chris Miller
Chris Miller
Cpreston
  • Locked
  • Question
Field change as caused issues to store procedure
Replies
19
Views
192
Andrzejek
Andrzejek
ahmedsa2018
  • Locked
  • Question
How to make pivot for features dynamically based on feature name and feature value ?
Replies
1
Views
119
TamarGranor
TamarGranor
Auguy
  • Locked
  • Question
Passing TVP instead of Individual Parameters to Procedure
Replies
0
Views
85
Auguy
Auguy
trisoldee
  • Locked
  • Question
Query multiple DB's on same server for Dynamics GP
Replies
1
Views
92
trisoldee
trisoldee

Part and Inventory Search

Sponsor

Back
Top