Some sections of above book I read few months back and today I got a thought to read it again. There are more than 97 things programmer should know but this is great collection and good prioritized list to follow. No need to read it from top to bottom , can switch to any topic as we like. . Also it’s proud to find one author from Sri Lanka who is Rajith Attapattu
In our project we had many many stored procedures and many parameters passes to those sps. But in only one sp it gives error message something like this; "Incorrect number of arguments for PROCEDURE sproc_t_l_Contract_Select_BySearchCriteria; expected 3, got 2” Work long time on this sp but coudnt find it. So i tried to write it again from the begining. In this time it was work perfectly.This problem occurs because of the space between data type and its length. Ex. pName varchar(50) - working pName varchar (50) - Not working But it does not mention syntax error or something.So this error message make us vulnerable.
Comments