private static string DeclareParametersText(ISqlCommand sqlCommand) { var commandParameters = new StringBuilder(); foreach (ISqlParameter parameter in sqlCommand.SqlParameters()) { commandParameters.Append( "{0, -50}".Params(DeclareParameterText(parameter)), "set @", parameter.ParameterName, " = '", parameter.Value.ToStr(), "';\r\n"); } return(commandParameters.ToString()); }