-->
SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Kapil Blogs

Hi friends, I am Kapil Singh Kumawat and I am from Jaipur in Rajasthan, India. I have been working with SQL Server for the last four and a half years and am currently working with Cognizant Technology Solutions as an SQL Server Developer. I have experience in performance tuning, SSIS, data migration, database designing and writing queries. My other interests include travelling, watching football and listening to music.

Archives: September 2015

SQL Server – Various methods to generate unique number sequence

Hi all, Friends, most of the time we used ranking function like ROW_NUMBER() when it required to generate unique number …

Continue reading Read more

0 comments, 553 reads

Posted in Kapil Blogs on 28 September 2015

SQL Server – Methods to find running totals of a column

HI friends, in some working scenario or during interviews we got the task to find the running totals of a …

Continue reading Read more

0 comments, 529 reads

Posted in Kapil Blogs on 14 September 2015

SQL Server – Using Window ranking function with UPDATE statement

Hi friends, I was working on a scenario in which I need to assign a unique values to a column. …

Continue reading Read more

0 comments, 524 reads

Posted in Kapil Blogs on 8 September 2015