Stored Procedure Field Generator

Field generator creates a number of code blocks for SQL Server Stored Procedures, insert, update, delete and variables.

Save time by copying relevant parts

Coding can take time, but we realised we use a number of types of code blocks regularly, be it to update a table through a stored procedure, or return data back.

This function below can generate he majority of the fields required to update a table for us, all we need to then do is copy and paste the relevant blocks into a new query window and we are done. The declaration part saves a huge amount of time for us in particular.

This won't be perfect for every situation, and can be adapted to suit your coding style.