SelectSql

As a rule of thumb, for small to medium volumes of data and simple usage scenarios you should use table variables. (This is an overly broa...

Introduction In this article, I want to tell you about SQL Server 7.0/2000 Transaction Isolation Levels, what kinds of Transaction Isola...

SELECT @@IDENTITY SELECT SCOPE_IDENTITY() SELECT IDENT_CURRENT(‘TableName’) All of the abouve three will get the identity value but in diff...

Nice One for startup... http://www.codeproject.com/Articles/13725/Getting-started-with-SQL-Server-Reporting-Services http://www.katiea...

     A Constraint is a property that we can assign to column in table. By assigning constraint property on column we can prevent the user...