My recent article on SQL SERVER – Download Denali CTP3 and Denali CTP 3 Product Guide has inspired today’s post. After reading this blog post, I received a few emails and few comments on facebook page that if I can post a video guide to Denali CTP3 installation. Finally I create…Read More
SQL SERVER – Connecting to Server Using Windows Authentication by SQLCMD
Recently I got a call from an old friend I used to call “DJ”. Here is the exact conversation we had about SQLCMD.
SQL SERVER – Delete Duplicate Rows
I had previously penned down two popular snippets regarding deleting duplicate rows and counting duplicate rows. Today, we will examine another very quick code snippet where we will delete duplicate rows using CTE and ROW_NUMBER() feature of SQL Server 2005 and SQL Server 2008.
SQL SERVER – Interesting Observation – Using sqlcmd From SSMS Query Editor
A day before I wrote article SQL SERVER – sqlcmd vs osql – Basic Comparison. Today while I was displaying how sqlcmd can be used instead of osql to one of my companies team leader, I found another neat feature of SSMS Query Editor. sqlcmd can be used from Query Editor but it has to be enabled first.