The Engineering Behind Enterprise AI

–get all storeprocedure and function SELECT * FROM INFORMATION_SCHEMA.PARAMETERS –pass storeprocedure name or function name –get the relavent columns ParameterName,DataType,Length,ParameterType SELECT Parameter_name as ParameterName,Data_type as DataType,coalesce(Character_Maximum_Length,0) as Length,Parameter_Mode as ParameterType FROM INFORMATION_SCHEMA.PARAMETERS WHERE SPECIFIC_NAME=‘sp_InsertOrder’