|
|
-
|
|
A Comparison of IComparable and IComparer interfaces in C#...
|
|
-
|
|
DataTemplateSelector in wpf...
|
|
-
|
|
When a template author in WPF tries to modify the look of the control , it is the controltemplate of the control that get changed....
|
|
-
|
|
Sql server ignores trailing spaces while comparing using WHERE and HAVING clauses .However this behavior is different for LIKE clause....
|
|
-
|
|
In part 1 and part 2 we learned about NULL propagation , ISNULL,COALESCE, tristate logic etc.
Now let’s learn few remaining parts.
...
|
|
-
|
|
In previous post(part 1) we learned about tristate logic for NULL ,Not Exists and Null propagation.In this post I will be explaining about ISNULL ,COALESCE, IS NULL, NULL relation with aggregate functions etc.
...
|
|
-
|
|
Null signifies ‘absence of any data value’ .In other words value is missing or value is unknown. It is important to understand that NULL is not zero or empty value .
...
|
|
-
|
|
XACT_ABORT is a command in sql server . When set to ‘ON’ it will rollback any transaction if an error occurred in it.If used where there is no transaction it will just roll back the statement where error occurred and aborts execution....
|
|
-
|
|
First of all let us understand where exception handling can be useful in sqlserver.
I am listing 2 main purpose of it. 1. In transactions it is a must. 2.To return the client some useful/custom error message....
|
|
-
|
|
Quite often we come across datatypes in sql server with a 'Max' as a size !!!
Lets first understand what it stand for. In sql server varchar can have 8000 characters(=8000 bytes), Nvarchar 4000 characters(1 unicode char=2 bytes).In sql server 2005 a new keyword 'MAX' is added aiming to replace older datatypes like TEXT,NTEXT,IMAGE etc.The size of data it can hold is 2 GB , the same size that can be hold by TEXT, NTEXT etc....
|
|