Earlier I wrote two articles about how to efficiently copy data from SSMS to Excel. Since I wrote that post there are plenty of interest generated on this subject. There are a few questions I keep on getting over this subject. One of the question is how to get the leading zero preserved while copying the data from SSMS to Excel. Well it is almost the same way as my earlier post SQL SERVER – Excel Losing Decimal Values When Value Pasted from SSMS ResultSet. The key here is in EXCEL and not in SQL Server.
SQL SERVER – Importance of User Without Login
Some questions are very open ended. Here is one question I was asked in recent User Group Meeting about user without login.
SQL SERVER – A Picture is Worth a Thousand Words – A Collection of Inspiring and Funny Posts by Vinod Kumar
One of the most popular quotes is: A picture is worth a thousand words. Working on this concept I started a series over my blog called the “Picture Post”. Rather than rambling over tons of material over text, we are trying to give you a capsule mode of the blog…
Read MoreSQL SERVER – Not Possible – Delete From Multiple Table – Update Multiple Table in Single Statement
There are two questions which I get every single day multiple times. In my gmail, I have created standard canned reply for them. Let us see the questions here. I want to delete from multiple table in a single statement how will I do it? I want to update multiple…
Read More
SQL SERVER – Copy Column Headers from Resultset – SQL in Sixty Seconds #027 – Video
SQL Server Management Studio returns results in Grid View, Text View and to the file. When we copy results from the Grid View to Excel there is a common complaint that the column header displayed in resultset is not copied to the Excel. I often spend time in performance tuning databases and I run many DMV’s in SSMS to get a quick view of the server. In my case it is almost certain that I need all the time copy column headers when I copy my data to excel or any other place.
SQL SERVER – Basic Calculation and PEMDAS Order of Operation
After thinking a long time, I have decided to write about this blog post. I had no plan to create a blog post about this subject but the amount of conversation this one has created on my Facebook page, I decided to bring up a few of the question and…
Read More
SQL SERVER – Excel Losing Decimal Values When Value Pasted from SSMS ResultSet
I often get questions that how to fix the issue where excel loses decimal values when values are pasted from SSMS Resultset.
SQLAuthority News – Download SQL Server 2012 SP1 CTP4
There are few trends I often see in the industry, for example i) running servers on n-1 version ii) wait till SP1 to released to adopt the product. Microsoft has recently released SQL Server 2012 SP1 CTP4. CTP stands for Community Technology Preview and it is not the final version yet. The…
Read More
SQL SERVER – Validating Unique Column Name Across Whole Database
I sometimes come across very strange requirements and often I do not receive a proper explanation of the same. Validating Unique Column Name
SQL SERVER – Replace a Column Name in Multiple Stored Procedure All Together
I receive a lot of emails every day. I try to answer each and every email and comments on Facebook and Twitter. I prefer communication on social media as this gives opportunities to others to read the questions and participate along with me. There is always some question which everyone likes to read and remember. Here is one of the questions which I received in email. How to replace a column name in multiple stored procedure efficiently and quickly? I believe the same question will be there any many developers who are beginning with SQL Server. I decided to blog about it so everyone can read it and participate.