Just a day before I was presenting at Virtual Tech Days and I wanted to demonstrate the current time to audience using SQL Server Management Studio, I ended up a quick error. If any of you ever tried to concat multiple values of different datatype this should not be surprise to you.
Writing a book was not an easy task. Publishing two books in a month were even harder task. In Sep-Oct 2011 I have published two books. I was very happy when books were published and I got a print copy in my hand. In this blog post we will discuss about Book Authoring.
In latest episode we discuss on the following things:
About his new book
His experience as an author
Why the name SQL Joes 2 Pros
Where can we buy his books
Challenges when writing this book
Recently I got a call from an old friend I used to call “DJ”. Here is the exact conversation we had about SQLCMD.
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.
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.