The essence of the problem is that when writing the Insert and Update procedure, you need a condition such that when you call this procedure through exec, the condition was met. The condition is simple, there are, for example, 5 columns, you need to insert 3 of 5 when inserting, the other 2 need to be filled with Null. If the Update procedure, then when changing 2 columns 3, the rest did not change. If the question is not clear, I'll chew up the better)) need ideas, help out :)
Source: https://ru.stackoverflow.com/questions/72888/
All Articles