Introduction
If you are applying for a SQL Server Administration or Development job, you may need to study and practice for the interview. It is a common mistake to go for an interview without studying.
In this article, we will show some common SQL interview questions that may help you to secure a good job.
Getting started
What are the new features in SQL Server version X?
A common question is asked about the new features of SQL Server. Here you have a list of SQL Server versions:
At the time this article was published, the last version was SQL Server 2019. Here you have the new features:
For older versions, you can check these links:
What is a stored procedure?
Stored procedures are used all the time in SQL Server, they are more commonly used than the functions. A stored procedure is a piece of code that you can use and reuse multiple times. It is a best practice to use stored procedures instead of queries for security reasons. Also, it is more efficient to send just the stored procedure with a few parameters than the entire select statement from the client to the server.
In order to create a stored procedure, you need to use T-SQL. Here you have the tutorial with examples to create your own stored procedures. One of my fellow authors, Ranga has created a pretty nice article about this topic:
There are several system stored procedures. Here you have the list:
#professional development #sql interview questions #sql
