Truncation is a search technique used in databases to help you find words with multiple endings. It involves replacing the ending of a word with a truncation symbol, usually an asterisk (*). This allows you to search for different forms of the same word simultaneously, increasing the number of results you get. Another symbol used in many databases is the plus sign (+), which is used to indicate that the database should search for both plural and singular forms of a word.
What is Truncation and How Does it Work?
Truncation is a search technique used in databases to help you find words with multiple endings. Learn more about how it works and how it can help you find what you're looking for.
Charlotte Wilson16/01/230 minutes read0 CommentsCharlotte Wilson
Friendly travel advocate. Freelance zombie scholar. Extreme web practitioner. Evil coffee buff. Professional beer practitioner.
Related Articles
What are the 2 differences between delete and truncate?
Charlotte Wilson2 minutes readWhen interviewing SQL Server candidates, I find that most don't know some of the basic differences between SQL Server's delete and truncate commands, as well as whether these operations can be undone, so in this tip we'll cover some of these aspects. Delete is a DML command, while truncate is a DDL command.
Understanding Truncations and Wildcards in Database Searches
Charlotte Wilson1 minute readTruncations and wildcards are two powerful techniques that can help you find what you need in database searches. Learn how to use them effectively to save time and get more relevant results.
Everything You Need to Know About Truncating in SQL
Charlotte Wilson1 minute readLearn everything you need to know about truncating in SQL with this comprehensive guide. Understand how it works and how it differs from other commands.
Which is Faster: Delete, Truncate or Drop?
Charlotte Wilson1 minute readWhen deleting data from a table there are three main commands available: DELETE, TRUNCATE and DROP. Learn about their advantages and disadvantages so you can make the best decision for your particular situation.