Just some fun with T-SQL.
Recently someone asked me to write a code which answers the question if today is the second business day of the month or not.
Here is a version of the code. If you have better ideas for doing this, feel free to post a comment.
?View Code TSQLdeclare @SecondDayOfMonth datetime
declare @Year int
Continue reading […] Find the second work day of the month […]
SQL SERVER TRANSACTION ISOLATION LEVELS
by Mukiibi Ivan
On a busy day, our streets are given order by the traffic police, they keep the traffic flowing and they also keep motorists safe. Maximum safety can be ensured by only allowing one person to use a junction at a time.
Unfortunately, if there is heavy traffic the safer and
Continue reading […] SQL SERVER TRANSACTION ISOLATION LEVELS […]
Reading books is a very labor-intensive task (well, at least when taken seriously!).
It is not easy for several reasons:
We have to figure out the level of the book according to our knowledge level
We have to question the book’s title
We have to question the structure and the content
And why we have to question, you would ask.
Continue reading […] SQL Server Interview Questions and answers – earning the honor of thinking […]