Feb 26, 2003 #1 Denaeghel Programmer Apr 23, 2001 61 0 0 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
Is it possible to write a stored procedure that can insert information where the column name is variable? Thanks Karel karel.denaeghel@barco.com
Feb 26, 2003 #2 arst06d Programmer Nov 29, 2002 324 0 0 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
I think you might have to create your query in a string within the procedure, then use the exec function to run it.
Feb 26, 2003 #3 TLGsoft IS-IT--Management Feb 25, 2003 28 0 0 RO use SP_EXECUTESQL() Upvote 0 Downvote