SQL by the book
  • Home
  • SQL Quiz
  • Math Quiz
  • Learning Corner
    • Understanding Query Execution Plans
  • How to
  • Thought Bubble
  • Contact Us

Category: Thought Bubble

icon_thougthbubble

Thought Bubble #3 – Nested transactions

Posted on December 14, 2015November 17, 2016 by SQL by the book

Do you know how many rows will the following statement return, after the query from the thought bubble was executed? SELECT * FROM [dbo].[Numbers]  ? In this short article, we will concentrate on the effect a ROLLBACK statement has over the nested transactions in SQL Server.

Posted in Thought Bubble Tagged nested, rollback, thought bubble, transactions Leave a comment
icon_thougthbubble

Thought Bubble #2 – Date and time offset

Posted on December 1, 2015November 17, 2016 by SQL by the book

Do you know what the thought bubble returns? Do you know if the functions from the bubble do even exist in SQL Server? In this article, we will concentrate on some interesting functions related to date and time values that have an offset. There are many functions in SQL Server which we don’t use on Read More

Posted in Thought Bubble Leave a comment
icon_thougthbubble

Thought Bubble #1 – Float and real in SQL Server

Posted on November 24, 2015November 17, 2016 by SQL by the book

Did you know what the thought bubble returns? Sometimes, when you don’t know what’s real anymore, and you go to your friend, SQL Server to find out…you may see that he doesn’t know either.  You may think that you entered a very specific number and you may want it back the same way at a Read More

Posted in Thought Bubble Leave a comment

Easy search

Join Our Meetup

Pluralsight

Theme by Out the Box