Sql Queries, Sql Tips, Sql Server, Programming Tips, Sql.
proper data type. Numbers should be of numeric type, and dates should be dates, etc. This is extremely important for indexing. Let’s look at the example below. SELECT employeeID, employeeName FROM employee WHERE employeeID = 13412; The above query fetches the employee ID and name for the employee