I'm new in SQL server. I want to create a stored procedure for a table. suppose table has 6 column.One person implements two or three column and another person implements rest of the columns. how to create stored procedure of this table.
Person A inserts the row and populates three columns, Person B then updates three other columns? If you know that A will only do those three and B the other three, then do two different procs.