If you failed to insert a new record into a table because of the unique constraint, do not miss to read this article. It will help you to solve this problem.
In this article, we will introduce 4 methods to solve the problem when you fail to insert a new record because it violates the unique constraint of the table in SQL Server.
A Real Case:
Now let’s see a real case. We have a database named “Product” and there is a table called “DataNumenProduct” in the database. There are two fields in...
Read more »
In this article, we want to show you 3 easy and effectual methods to replace a specific font in your Word document.
To process a document in Word often requires more than editing. For example, we are also supposed to consider such elements as style, page layout, etc. And one of all the kinds is the font employment. Given that we are likely to change a font to another one quite often, here we have 3 ways to help us easily handle the task.
Method 1: Use “Find and Replace” Feature
First...
Read more »
Sometimes, you may want to count the total number of the emails from a specific sender in Outlook. This article will introduce you a handy way to quickly get the total count with Outlook VBA.
For some reasons, such as data statistics, you may be required to count the total number of the emails from a specific sender. Without any doubts, if you have numerous mails, manually counting them one by one will be rather troublesome and prone to error. In this case, why not recur to VBA? Here are the...
Read more »
