EXEC usp_InsertUser @Name = 'John', @Surname = 'Doe', @Email = '[email protected]'; EXEC usp_InsertUser @Name = 'Jane', @Surname = 'Smith', @Email = 'jane.smith ...
Instead of sending multiple SQL statements from the client to the server, I encapsulate them in a stored procedure on the server and send one statement from the client end to execute them. Benefits: ...