set rowcount 2

select column,column1 from tblEmployeeMaster

KEYSET Cursor uses the set of keys that are primary key or we can saw uniquely identify the cursor's rows. SQL Server uses a table in tempdb to store keyset. Th..

Here are the some good tips when creating a store procedure

(1)Always use ANSI92 syntax avoid to use the old syntax.

(2)Use SQL keyword in capital lett..

SELECT obj.NAME, ind.rowcnt FROM sysindexes AS ind INNER JOIN sysobjects AS obj ON ind.id = obj.id WHERE ind.indid < 2 AND OBJECTPROPERTY(obj.id, 'IsMSShip..

In SQL 2005 and earlier there was a limitation of 250 indexes per table, one clustered and 249 non-clustered. In SQL 2008, with the addition of filtered indexes..

= is used for assignment to assign some value for example

int i

i=9;

on the other hand == is used for comparing some values

if(i==9)