Friday, 25 November 2011

Deploy/Use assemblies which require Unsafe/External Access with CLR and T-SQL

›
  What is an Unsafe Assembly? Assemblies which are built using normal computational functions are considered as safe assemblies. But when ...
5 comments:
Tuesday, 22 November 2011

Using CLR functions with T-SQL

›
Why use CLR? Before using CLR, you should question ‘Why’. When using CLR functions within T-SQL, you have to maintain two different progra...
Tuesday, 9 August 2011

Change the data source of a Crystal Report at Run-time using C#

›
It’s a known fact, that in Crystal Reports, if you try to display details, using data in a SQL Server Database other than the one that you’v...
7 comments:
Monday, 8 August 2011

Invoke a custom method when Crystal Report Viewers’ print button is clicked / Add custom button to Crystal Report Viewer Toolbar

›
If you are developing applications which includes reporting with Crystal Reports, you may have noticed that it’s not possible to invoke a cu...
3 comments:
Friday, 5 August 2011

How to insert data using SQL Views created using multiple tables

›
A view can be defined as a virtual table or a stored query and the data accessible through a view is not stored in the database as a distinc...
6 comments:
Sunday, 31 July 2011

Using MERGE statement in SQL Server 2008

›
‘MERGE’ statement is a new feature in SQL Server 2008. It can be used to perform insert, update and delete operation on a destination table ...
1 comment:
Thursday, 28 July 2011

How to Use Update Cursors in SQL Server

›
There can be a situation where you have to use a cursor, even though the experts say not to use cursors or to avoid them as much as possible...
8 comments: