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.
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
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