Google to FTS Syntax Cheat Sheet

OPERATOR EXAMPLE

DESCRIPTION

 

nut

Searches for inflectional forms of the word nut

crank arm

crank AND arm

Searches for documents containing inflectional forms of the words crank AND arm crank and ann. The keyword AND is optional.

tire OR air

Searches for documents containing inflectional forms of the words tire or air,

“reflector bracket”

Performs a phrase search for the phrase "reflector bracket".

hardware -bracket

Searches for documents containing inflectional forms of the word hardware but not the word bracket.

+clamp

Searches for the word darn') without generating inflectional forms.

~seat

Searches for thesaurus forms of the word seat

Assemb*

Searches for words that begin with the prefix assemb

. <washer nut>

Searches for documents that contain the words washer in close proximity to the word nut


Comments

  1. Pratap SinghJuly 7, 2011 at 9:47 AM

    This is nice article

    ReplyDelete
  2. Ram KumarJuly 7, 2011 at 11:20 PM

    #region Private

    ///
    /// Object for Logging
    ///
    private static ILog logger = LogManager.GetLogger(typeof(DBConnectionManager));
    ///
    /// Specifies the time when query was executed last time.
    ///
    private static DateTime 1.lastExecutionTime = DateTime.Now;
    ///
    /// Represent a command to database.
    ///
    private SqlCommand sqlCmd;
    ///
    /// Represent a connection to database.
    ///
    private SqlConnection conn;
    ///
    /// Represent a connection string.
    ///
    private static string connection;
    ///
    /// Represent a time out for connection.
    ///
    private int timeOut;
    ///
    /// Whether component is disposed or not
    ///
    private bool disposed = false;

    #endregion
    2. # region Properties
    ///
    /// Get Command Object
    ///
    public SqlCommand SqlCmd
    {
    get
    {
    return sqlCmd;
    }
    }
    ///
    /// Connection object to the database
    ///
    public SqlConnection Conn
    {
    get
    {
    return conn;
    }
    set
    {
    conn = value;


    }
    }
    ///
    /// get or set the database command time out value
    ///
    public int TimeOut
    {
    get
    {
    return timeOut;
    }
    set
    {
    timeOut = value;

    }
    }
    ///
    /// get/set Database Connection String
    ///
    public string Connection
    {
    get
    {
    return connection;
    }
    set
    {
    connection = value;
    }
    }
    #endregion

    ReplyDelete
  3. Ram KumarJuly 7, 2011 at 11:22 PM

    3. public static void SetDatabaseConnectionString(string connectionString)
    {
    DBConnectionManager.connection = connectionString;
    }

    public void OpenConnection()
    {
    const string ProcName = "OpenConnection";
    try
    {
    logger.Debug(ProcName + EnterProcedure);
    if (conn == null || conn.State == ConnectionState.Closed || conn.State == ConnectionState.Broken
    || DateTime.Now.Subtract(lastExecutionTime).TotalMinutes > 30)
    {
    //open new connection
    conn = new SqlConnection(connection);
    conn.Open();

    }

    lastExecutionTime = DateTime.Now;
    }
    catch (Exception ex)
    {
    logger.Error(ProcName + ErrorOccured, ex);
    throw;
    }
    finally
    {
    logger.Debug(ProcName + ExitProcedure);
    }

    }

    ReplyDelete
  4. Ram KumarJuly 7, 2011 at 11:22 PM

    3.... public void CloseConnection()
    {
    const string ProcName = "CloseConnection";
    try
    {
    logger.Debug(ProcName + EnterProcedure);
    if (conn != null && conn.State == ConnectionState.Open)
    conn.Close();
    }
    catch (Exception ex)
    {
    logger.Error(ProcName + ErrorOccured, ex);
    throw;
    }
    finally
    {
    logger.Debug(ProcName + ExitProcedure);
    }
    }

    public void CloseConnection(SqlConnection sqlConn)
    {
    const string ProcName = "CloseConnection() ";
    try
    {
    logger.Debug(ProcName + EnterProcedure);
    if (sqlConn != null && sqlConn.State == ConnectionState.Open)
    sqlConn.Close();
    }
    catch (Exception ex)
    {
    logger.Error(ProcName + ErrorOccured, ex);
    throw;
    }
    finally
    {
    logger.Debug(ProcName + ExitProcedure);
    }
    }

    ReplyDelete
  5. Ram KumarJuly 7, 2011 at 11:27 PM

    3.2 public void AddParam(string paramName, SqlDbType paramType, Object paramValue, ParameterDirection direction, int size)
    {
    const string ProcName = "AddParam";
    try
    {
    logger.Debug(ProcName + EnterProcedure);
    sqlCmd.Parameters.Add(CreateParameter(paramName, paramType, paramValue, direction, size));
    }
    catch (Exception ex)
    {
    logger.Error(ProcName + ErrorOccured, ex);
    throw;
    }

    finally
    {
    logger.Debug(ProcName + ExitProcedure);
    }
    }

    ReplyDelete
  6. Ram KumarJuly 7, 2011 at 11:27 PM

    3.3 public void AddParam(string paramName, string paramValue, int size)
    {
    const string ProcName = "AddParam";
    try
    {
    logger.Debug(ProcName + EnterProcedure);
    sqlCmd.Parameters.Add(CreateParameter(paramName, SqlDbType.VarChar, paramValue, ParameterDirection.Input, size));
    }
    catch (Exception ex)
    {
    logger.Error(ProcName + ErrorOccured, ex);
    throw;
    }

    finally
    {
    logger.Debug(ProcName + ExitProcedure);
    }
    }
    public void AddParam(string paramName, int paramValue, int size)
    {
    const string ProcName = "AddParam";
    try
    {
    sqlCmd.Parameters.Add(CreateParameter(paramName, SqlDbType.Int, paramValue, ParameterDirection.Input, size));
    }
    catch (Exception ex)
    {
    logger.Error(ProcName + ErrorOccured, ex);
    throw;
    }

    finally
    {
    logger.Debug(ProcName + ExitProcedure);
    }

    }

    ReplyDelete
  7. Ram KumarJuly 7, 2011 at 11:28 PM

    3.4 public void AddParam(string paramName, DateTime? paramValue, int size, bool treatForNull)
    {
    const string ProcName = "AddParam";
    try
    {
    object parameterValue;
    if (paramValue == null)
    {
    parameterValue = DBNull.Value;
    }
    else
    {
    parameterValue = paramValue;
    }
    sqlCmd.Parameters.Add(CreateParameter(paramName, SqlDbType.DateTime,
    paramValue, ParameterDirection.Input, size, treatForNull));
    }
    catch (Exception ex)
    {
    logger.Error(ProcName + ErrorOccured, ex);
    throw;
    }

    finally
    {
    logger.Debug(ProcName + ExitProcedure);
    }
    }
    public void AddOutputParameter(string paramName, int size)
    {
    const string ProcName = "AddOutputParameter";
    try
    {
    sqlCmd.Parameters.Add(CreateParameter(paramName, SqlDbType.VarChar, null, ParameterDirection.Output, size));
    }
    catch (Exception ex)
    {
    logger.Error(ProcName + ErrorOccured, ex);
    throw;
    }

    finally
    {
    logger.Debug(ProcName + ExitProcedure);
    }
    }

    ReplyDelete
  8. Ram KumarJuly 7, 2011 at 11:37 PM

    public DataSet GetFolderByStatus(int statusID, int updateStatus, int projectUpdateStatus, string machineName)
    {
    const string ProcName = "GetProjectByStatus";
    try
    {
    logger.Debug(ProcName + EnterProcedure);
    CreateSqlCommand(GetFolderByStatusProcedure);
    AddParam("@StatusID", statusID, 4);
    AddParam("@UpdateStatusID",updateStatus,4);
    AddParam("@ProjectUpdateStatus", projectUpdateStatus, 4);
    AddParam("@MachineName", machineName, 100);
    ExecuteSQL();
    return GetDataset();
    }
    catch (Exception ex)
    {
    logger.Error(ProcName + ErrorOccured, ex);
    throw;
    }
    finally
    {
    logger.Debug(ProcName + ExitProcedure);
    }
    }

    ReplyDelete
  9. Ram KumarJuly 7, 2011 at 11:38 PM

    public DataSet ProjectLoad(int projectID)
    {
    const string ProcName = "ProjectLoad";
    try
    {
    logger.Debug(ProcName + EnterProcedure);
    CreateSqlCommand(ProjectLoadProcedure);
    AddParam("@projectId", projectID, 4);
    ExecuteSQL();
    return GetDataset();
    }
    catch (Exception ex)
    {
    logger.Error(ProcName + ErrorOccured, ex);
    throw;
    }
    finally
    {
    logger.Debug(ProcName + ExitProcedure);
    }
    }

    ReplyDelete

Post a Comment

Popular posts from this blog

Sql Index

Image
Indexes help us retrieve data from tables quicker. Let's use an example to illustrate this point: Say we are interested in reading about how to grow peppers in a gardening book. Instead of reading the book from the beginning until we find a section on peppers, it is much quicker for us to go to the index section at the end of the book, locate which pages contain information on peppers, and then go to these pages directly. Going to the index first saves us time and is by far a more efficient method for locating the information we need. The same principle applies for retrieving data from a database table. Without an index, the database system reads through the entire table (this process is called a 'table scan') to locate the desired information. With the proper index in place, the database system can then first go through the index to find out where to retrieve the data, and then go to these locations directly to get the needed data. This is much faster. ...
Read more

Soundex Limitations

Image
Names that sound alike do not always have the same soundex code. For example, Lee (L000) and Leigh (L200) are pronounced identically, but have different soundex codes because the silent g in Leigh is given a code. Names that sound alike but start with a different first letter will always have a different soundex code. Thus, names such as Carr (C600) and Karr (K600) have different soundex codes even though they sound alike. Name that sound alike but have different first letters should have each name calculated and searched for separately. Since the soundex system is based on English pronunciationn, some European names may not soundex correctly. For example, some French surnames with silent last letters will not code according to pronunciation. An example is the French name such as Beaux - where the x is silent. While Beau (B000) is pronounced identically to Beaux (B200), they will have different soundex codes. This could be true of any surname that does no...
Read more