Search Results

Search found 3 results on 1 pages for 'alexkuznetsov'.

Page 1/1 | 1 

• How do you unit test your T-SQL

  - by AlexKuznetsov

  How do you unit test your T-SQL? Which libraries/tools do you use? What percentage of your code is covered by unit tests and how do you measure it? Do you think the time and effort which you invested in your unit testing harness has paid off or not? If you do not use unit testing, can you explain why not?

  Read the article

• Good advanced book on developing robust C# modules

  - by AlexKuznetsov

  I have some experience with C#, and would like to improve my knowledge of its latest improvements. I am in the middle of reading and enjoying "Effective C#" by Bill Wagner right now. However, I would appreciate more examples, especially with lambda expressions and such. Any suggestions are greatly appreciated. High quality resources are preferable, and it does not matter much if they are free or not.

  Read the article

• Why can I create a table with PRIMARY KEY on a nullable column?

  - by AlexKuznetsov

  The following code creates a table without raising any errors: CREATE TABLE test( ID INTEGER NULL, CONSTRAINT PK_test PRIMARY KEY(ID) ) Note that I cannot insert a NULL, as expected: INSERT INTO test VALUES(1),(NULL) ERROR: null value in column "id" violates not-null constraint DETAIL: Failing row contains (null). ********** Error ********** ERROR: null value in column "id" violates not-null constraint SQL state: 23502 Detail: Failing row contains (null). Why can I create a table with a self-contradictory definition? ID column is explicitly declared as NULLable, and it is implicitly not nullable, as a part of the PRIMARY KEY. Does it make sense? Edit: would it not be better if this self-contradictory CREATE TABLE just failed right there?

  Read the article

1