SQL Questions

A UNION query combines the output from multiple queries and must include the same number of columns.

SELECT YEAR(GETDATE()) as "Year";

One can use simple conditions like >= and <=, or use between/and but the trick here is to know your exact data type.

- Sometimes date fields contain time and that is where the query can go wrong so it is recommended to use some date related functions to remove the time issue. In SQL Server common function for accomplishing the task datediff () function.

- Interviewees also have to be aware of different time zones and server time zone.

-To increase query performance you may still want to use between however you should be aware of proper format you should use if not it might misbehave during filtering.

SQL Server can be linked to any server provided it has OLE-DB provider from Microsoft to allow a link. E.g. Oracle has an OLE-DB provider for oracle that Microsoft provides to add it as linked server to SQL Server group.

SELECT *FROM Employees WHERE EmpName like ‘M%’.

SQL Server runs on port 1433. It can be changed from the Network Utility TCP/IP properties.