Generating Identity Values for Existing Records of a Table in a Custom Order

Recently I needed to add an Identity column to a table which is already populated. Of course, adding a new column to a table with identity property can be done easily. But the problem is to generate values for the existing records in a custom order, as the values are getting generated automatically...

HTML Ordered List Directly From SQL

Recently I worked on a project that requires an unordered list to be prepared dynamically depending on many filters. Users are consistently generating the results with various filters and the results are shown as a list. Well there are many ways to do this. You can simply get the results to client-side...

Hello World !!!

Hello World…!! :-) Welcome to my blog……  I’m Chamika Goonetilaka, a software developer who is interested in C#, SQL Server and JavaScript. I’m mainly into Web Development, Data Visualization, Business Intelligence, Data Mining and Pattern Recognition. So await for my posts…….!...