Introduction It is very common in information systems to have functions where the users are able to search the data by selecting freely among many possible search fields. When you implement such a function with SQL Server there are two Read More …
Category: Mostly Asked Questions
Delete Duplicates From a Table in SQL Server
You can use the following ways to delete duplicate rows from a table in SQL Server. Let’s create a sample Employee table and insert a few records in it. CREATE TABLE Employee([ID] INT identity(1,1),[FirstName] Varchar(100),[LastName] Varchar(100),[Country] Varchar(100),)GOInsert into Employee ([FirstName],[LastName],[Country] Read More …
Part 2: How to quickly search for SQL database data and objects in SSMS
Frequently, developers and DBAs need to search databases for objects or data. If a database function that contains a specific table column or a variable name, or for a table that contains specific data is searched, the simple solution for Read More …
Part 1: MSSQL Frequently Asked Questions
1. Selecting all the values from a table for a particular date This is a very popular question and people sometimes answer that you need to use between. There is a problem with between if you happen to have a Read More …