Hi Ritesh, I have got several tables without IDENTITY columns. I am trying to add an IDENTITY column to each of the tables. I see that most tables already have a column that stores a sequence number, but it is not an IDENTITY column. I am trying to turn...

<p>I need to have an example to dynamic pivot as in my condition this is not fixed that how much rows i get so.</p> <p>Do you guys have something like dynamic pivot.</p>...

<p>what is the difference between Non-Clustered Index and Index. I am tired of finding any huge difference between them.</p> <p>So can you guys please help me out in this.</p>...

<p>Hi Guys,,,</p> <p>I want to delete duplicate records from my table and there is no primary key which i can use in this and all the values in rows are identical.</p> <p>identity            &nb...