SQL Interview Questions and Answers Archives - Page 25 of 67

How to Insert Line Break in SQL Server String? – Interview Question of the Week #139

September 10, 2017

Pinal Dave

SQL Interview Questions and Answers

SQL Function, SQL Scripts, SQL Server, SQL String

Question: How to Insert Line Break in SQL Server String?

What does Keyword STATS Indicates in Backup Scripts in SQL Server? – Interview Question of the Week #138

September 3, 2017

Pinal Dave

SQL Interview Questions and Answers

SQL Backup, SQL Scripts, SQL Server

Question: What does Keyword STATS Indicates in Backup Scripts in SQL Server?

What is the Biggest Limitation of ISDATE() Function? – Interview Question of the Week #137

August 27, 2017

Pinal Dave

SQL Interview Questions and Answers

SQL DateTime, SQL Function, SQL Server

Question: What is the Biggest Limitation of ISDATE() Function?

How to Allow Only Alphabets in Column? – Interview Question #136

August 20, 2017

Pinal Dave

SQL Interview Questions and Answers

SQL Constraint and Keys, SQL Function, SQL Scripts, SQL Server

Question: How to Allow Only Alphabets in Column? Answer: This was a real world scenario and I have mixed feeling about this kind of question.

How to Show Results of sp_spaceused in a Single Result? – Interview Question of the Week #135

August 13, 2017

Pinal Dave

SQL Interview Questions and Answers

SQL Scripts, SQL Server, SQL Stored Procedure

Question: How to Show Results of sp_spaceused in a Single Result?

Answer: When I hear this question from my co-interviewer, I objected. I think it is not a good interview question. I do not expect any of the candidates to remember any of the syntax. Remembering basic syntax should be a good idea, but it should not be the sole requirement of the hiring a good candidate. I believe I am a good DBA but trust me personally I do not remember all the syntax.