I often enjoy seeing interview questions where the contestant has to write SQL Scripts. Here is another such example. Question: How to find weekdays between two dates? Answer: Here is a function which can be used to find weekdays between two dates. CREATE FUNCTION dbo.getDayCount(@startdate date, @enddate date) RETURNS INT…

One of my popular questions which helps me to understand lots of understanding of SQL by SQL developer. Question: How doing a case sensitive search in SQL Server? Answer: If Column1 of Table1 has following values ‘CaseSearch, casesearch, CASESEARCH, CaSeSeArCh’, following statement will return you all the four records. SELECT…

This question may sound strange but I have personally observed this being asked in one of the interview. Question: How Does SPACE Function Works in SQL Server? Answer: SPACE function accepts one numeric parameter and generates as many as space as a value of the parameter. Observe the output of the…