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 derfloh 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
Joined
Apr 23, 2001
Messages
61
Location
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 Question
Insert into query adds records to unreadable format, how do I change that?
Replies
5
Views
813
Chris Miller
Chris Miller
Cpreston
  • Locked
  • Question Question
Field change as caused issues to store procedure
Replies
19
Views
1K
Andrzejek
Andrzejek
ahmedsa2018
  • Locked
  • Question Question
How to make pivot for features dynamically based on feature name and feature value ?
Replies
1
Views
463
TamarGranor
TamarGranor
Auguy
  • Locked
  • Question Question
Passing TVP instead of Individual Parameters to Procedure
Replies
0
Views
269
Auguy
Auguy
trisoldee
  • Locked
  • Question Question
Query multiple DB's on same server for Dynamics GP
Replies
1
Views
342
trisoldee
trisoldee

Part and Inventory Search

Sponsor

Back
Top