
	Home > SQL Server Tips > Database Development > Stored procedures: Implement full text search

SQL Server Tips:

EMAIL THIS

TIPS & NEWSLETTERS TOPICS

DATABASE DEVELOPMENT

Stored procedures: Implement full text search

Eli Leiba
02.12.2003
Rating: --- (out of 5)

Digg This!

StumbleUpon

Del.icio.us

Enabling full text search in T-SQL is not as popular as doing it with the Enterprise Manager. Nonetheless, it can be useful in certain situations. Here are the steps to implement FTS in T-SQL.

Here are some examples on how to use this procedure:

About the author

Eli Leiba works at the Israel Electric Company as a senior application DBA in Oracle and Microsoft SQL Server systems. He has certifi

Digg This!

StumbleUpon

Del.icio.us

RELATED CONTENT

	SQL/Transact SQL (T-SQL)
	Working with sparse columns in SQL Server 2008
	Determining the source of full transaction logs in SQL Server
	New GROUP BY option provides better data control in SQL Server 2008
	Using the OPENROWSET function in SQL Server
	Loading data files with SQL Server's BULK INSERT statement
	Importing and exporting bulk data with SQL Server's bcp utility
	Testing transaction log autogrowth behavior in SQL Server
	Securing SQL Server with access control, login monitoring and DDL triggers
	Top 10 SQL Server development tips of 2008
	The sqlcmd utility in SQL Server
	SQL/Transact SQL (T-SQL) Research

SQL Server Stored Procedures

Top 10 SQL Server development tips of 2008

SQL Server trigger vs. stored procedure to receive data notification

SQL Server errors, failures and other problems fixed from the trenches

SQL Server and data manipulation in T-SQL

How to use SQL Server 2008 hierarchyid data type

SQL Server stored procedures tutorial: Write, tune and get examples

Check SQL Server database and log file size with this stored procedure

SQL Server source code analysis and management adds database security

Configure SQL Server Service Broker for sending stored procedure data

Find size of SQL Server tables and other objects with stored procedure

Database Development

Managing the development lifecycle with Visual Studio Team System 2008

Processing XML files with SQL Server functions

A first look at Visual Studio Team System 2008 Database Edition

How to create a SQL inner join and outer join: Basics to get started

New datetime data types in SQL Server 2008 offer flexibility

Using DATEADD and DATEDIFF to calculate SQL Server datetime values

SQL Server database design disasters: How it all starts

SQL Server database design disasters: What not to do

Secure SQL Server from SQL injection attacks

Check SQL Server database and log file size with this stored procedure

RELATED GLOSSARY TERMS

Terms from Whatis.com − the technology online dictionary

ACID (SearchSQLServer.com)

commit (SearchSQLServer.com)

DAO (SearchSQLServer.com)

fetch (SearchSQLServer.com)

OLE DB (SearchSQLServer.com)

query (SearchSQLServer.com)

SQL (SearchSQLServer.com)

T-SQL (SearchSQLServer.com)

RELATED RESOURCES

2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems

Search Bitpipe.com for the latest white papers and business webcasts

Whatis.com, the online computer dictionary

cations from Microsoft and BrainBench in Oracle and SQL Server database administration and implementation. Mr. Leiba holds a B.S. in computer science and has 11 years of experience working in the database field. Additionally, Mr. Leiba teaches SQL Server DBA and development courses at the Microsoft CTEC and serves as a senior database consultant for several Israeli start-up companies.

For More Information

Rate this Tip
To rate tips, you must be a member of SearchSQLServer.com. Register now to start rating these tips. Log in if you are already a member.
Submit a Tip

DISCLAIMER: Our Tips Exchange is a forum for you to share technical advice and expertise with your peers and to learn from other enterprise IT professionals. TechTarget provides the infrastructure to facilitate this sharing of information. However, we cannot guarantee the accuracy or validity of the material submitted. You agree that your use of the Ask The Expert services and your reliance on any questions, answers, information or other materials received through this Web site is at your own risk.

SQL Server Development - .NET, C#, T-SQL, Visual Basic

SEARCH

TechTarget provides technology professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective purchase decisions and managing their organizations' technology projects - with its network of technology-specific websites, events and online magazines.


TechTarget Corporate Web Site \| Media Kits \| Site Map All Rights Reserved, Copyright 2005 - 2009, TechTarget \| Read our Privacy Policy