Writing where clause has been easiest thing. Most of the time we learn this as a first thing in SQL. I have often seen that many times a simple question with where one has to write about where clause they often fail or get confused

What is an IDENTITY Value? What are the different ways to get IDENTITY values and properties of IDENTITY Values? If you are going to answer that identity value is ever increasing, is it possible to have identity value ever decreasing value?

ANSI ISOLATIONS levels are very important part of any database. There are two database servers both have different isolations levels. Due to the same different results are returned to the users. Let us help them by educating regarding various isolations levels and their various behaviors with example. What are the different ANSI ISOLATION Levels? What is the additional ISOLATION Level with SQL Server and explain its behavior?

This challenge invites you to solve a payroll challenge which requires to calculate the number of hours employee worked in a week. http://beyondrelational.com/puzzles/challenges/106/calculate-the-payroll-hours-of-employees.aspx...

Many of you must have played the 'mangled words' game in the school. Here is a challenge that gives you an opportunity to play it once again using TSQL.

This challenge invites you to identify the longest sequence of alphabets from a string. This challenge is Version 2 of the TSQL Challenge 67. The difference is that in this version, you should apply circling while finding the longest sequence.

A website wants to display most relevant ads on each of its web pages based on the keywords associated with each page. Your job is to write a TSQL query that returns the advertisements most relevant to each web page given in the source table.

This challenge invites you to Generate kaprekar kernel or series from numbers.Kaprekar Series and Kaprekar Constants are numbers generated by applying the Kaprekar Routine on a number!

This challenge invites you to identify the longest sequence of alphabets from a string.

One of the problems I always faced when storing multi-line text into a SQL Server table is the trouble in retrieving it and analysing it in SSMS. If I take output to Grid, I will lose the line breaks and formatting. If I take output to text, it is truncated in the middle.