public static DataTable GetModifyedSPNamesBetweenDates(DateTime FromDate, DateTime ToDate) { try { lstParams = new List <SqlParameter>(); string strQuery = @"SELECT name, create_date, modify_date FROM sys.procedures WHERE modify_date BETWEEN @FromDate AND @ToDate ORDER BY modify_date DESC" ; lstParams.Add(new SqlParameter() { ParameterName = "@FromDate", SqlDbType = SqlDbType.DateTime, Value = FromDate }); lstParams.Add(new SqlParameter() { ParameterName = "@ToDate", SqlDbType = SqlDbType.DateTime, Value = ToDate }); return(DLScript.GetResultDataTable(strQuery, CommandType.Text, lstParams)); } catch { throw; } }
public static DataSet SPSchemaReader(string strSPName) { try { return(DLScript.SPSchemaReader(strSPName)); } catch { throw; } }
public static DataTable GetAllSPNames() { try { lstParams = new List <SqlParameter>(); string strQuery = @"SELECT name, create_date, modify_date FROM sys.procedures ORDER BY modify_date DESC" ; return(DLScript.GetResultDataTable(strQuery, CommandType.Text, lstParams)); } catch { throw; } }