Things To Consider While Using SQL Server Reporting (SSRS) With Silverlight (3 and 4)

Reporting is the heart of most business applications. And SQL Server Reporting Service (SSRS) is a preferred choice while MSSQL Server is the database back-end. Apart from ready to use services, SSRS provides different and useful scalability and extensibility options.

On the other end, lately, MS Silverlight has generated positive heat amongst varied business applications.

So you got the point. I’m talking about the marriage between SSRS and Sliverlight.

It started with challenges as the whole concept was an unknown devil which we were able to tame in the end.

Continue reading Things To Consider While Using SQL Server Reporting (SSRS) With Silverlight (3 and 4)

Something about NULL in SQL Server

As developers, we all probably know what a NULL is in SQL Server. NULL is not a specific value but it stands for UNKNOWN value. In other words, NULL represents the ‘absence of data’.

The behavior and treatment of NULL in SQL server is very interesting in different context and part of T-SQL language. Let’s have a quick look on how it is treated in different ways by SQL Server.

When you use NULL (UNKNOWN value) in Arithmetic operations or in String Concatenation operations, the result is always UNKNOWN because the value which is being operated is not available or UNKNOWN. So, all the following statements yield the result of NULL:

Continue reading Something about NULL in SQL Server