Posted in DotNet 2.0, Sql Server, Techincal on March 17, 2008 | 1 Comment »
A very common question during the interview is to provide difference between IDENT_CURRENT, @@IDENTITY and SCOPE_IDENTITY(). All are used to retrieve the value of identity column after DML statement execution. All three functions return last-generated identity values. However, the scope and session on which last is defined in each of these functions differ:
IDENT_CURRENT returns [...]
Posted in DotNet 2.0, Sql Server, Techincal on March 11, 2008 | 29 Comments »
As we all know SQL Server 2005 has CLR integrated with it. This means one can write a code in manage application and execute it SQL Server. I read about this since Microsoft has launched SQL Server 2005, however I have never used it practically till last week.
First question came in my mind [...]
 | Jignesh Patel on Disable right click on pa… |
 | Chinni on Call parent window’s jav… |
 | Louie on Set Full Image Path in FCK… |
 | Anuradha on Generate Image from text using… |
 | Dasamayee on GROUP BY, CUBE, ROLLUP and SQL… |
