@@Error in SQL

What do you think the output of the following SQL program would be?

 Create table Test(testID tinyint)
Begin Tran Insert into Test(testID ) values (1)
PRINT @@ERROR
Insert into Test(testID ) values (300) // This statement will generate an error as 300 is not a tinyint
 PRINT @@ERROR
IF @@ERROR = 0
 BEGIN
 COMMIT TRAN
END
ELSE
 BEGIN
 ROLLBACK TRAN
END
 The transaction will be Committed :) Surprised?.
Since, we have a PRINT @@ERROR statement before the IF statement, this condition will be executed as true and the output of @@ERROR will be 0.

Comments

Post a Comment

Popular posts from this blog

Knowing too much is bad(in the world of OOP)

In real life, we have heard experts say that knowing too much or sometimes doing too much is bad.  This is the same in the world of Object Oriented Programming, this is called as God Object. The God object is an example of anti-pattern(code that is difficult to understand, refactor and maintain) and a code smell.  We have heard of Single-responsibility Principle(which is "S" in the SOLID principles). The SRP states that each class should have only responsibility and therefore has only one reason to change.  Whenever a code is written, make sure that the class does only one thing. You can refer to the God Object here at wikipedia which gives a brief description: https://en.wikipedia.org/wiki/God_object
Read more

Reverse a LinkedList Algorithm

Reversing a Linked List Problem Statement:  Reverse a Linked List.  Given a Linked List of Nodes  :  1->2->3->4->5->6 , reverse it so that the output is 6->5->4->3->2->1 My Approach:  For this approach, we cannot the same LinkedListNode since it would point to the same memory location. In the above example, 1 should point to null of the new List. 2 which is 1.next (original) should point to 1 of the new List. 3 which is 2.next (original) should point to 2 of the new List. 4 which is 3.next (original) should point to 3 of the new List. 5 which is 4.next (original) should point to 4 of the new List. 6 which is 5.next (original) should point to 5 of the new List. This is where our logic ends. 1) LinkedListNode Class  This class has 2 Components of a Singly Linked List.  Value of the node Pointer to the Next Node.           public class LinkedListNode ...
Read more

DateTime.Now in C#

DateTime Class is used to get the various possibilities that can be included within a day, month or a year. I am going to discuss about some functionalities of DateTime.Now here. For example: To get the current date and time, use DateTime.Now which gives us 6/24/2009 9:45:00 AM DateTime.Now has 5 important functions to get date and time in different formats. 1) DateTime.Now.ToLongDateString() - Displays in the format "Wednesday, June 24, 2009." 2) DateTime.Now.ToLongTimeString() - Displays in the format "12:00:00 AM. " 3) DateTime.Now.ToShortDateString() - Displays in the format "6/24/2009" 4) DateTime.Now.ToShortTimeString() - Displays in the format "12:00 AM" 5) DateTime.Now.ToString("Format") - This method accepts different formats. The formats can be obtained from GetDateTimeFormats() method of DateTime.Now and has 133 different formats that anyone can think of while displaying Date and Time. For example: DateTime.Now.ToString(...
Read more