General Standards: (Code Format, Naming Conventions, Datatype and Data Length, Syntax): § Always follow a template in designing stored procedure so that it can easier developer job while designing and integrating. For example each stored procedure should be defined as various blocks such as “Comments Section”, “Variable Declaration”, “Actual Body”, “Audit”, ”Exception Handling”, “Temp_Obj_Removel” and define environment sections if any required. § Check proper comments are used or not. Always describe procedure, inputs and expected output in comments section. § Check naming conventions are used properly for procedure name, variables and other internal objects. § Check all objects used inside the procedure are prefixed with the schema name and column names are referencing with table alias. § Check all table columns used / mapped are using the correct datatypes and column length. § Check if all required SET based options enabled are not. § Check if there ar