MSSQL convert star or asterisk to column names

So you've opened someones stored procedure up and look! They've used the asterisk to select the column names, not only is it slow but it's annoying to look at too. Isn't it much better to have all the column names at the top of your select statement? Before you answer... Yes it is. ;) Delete the asterisk or star, whatever you want to call it.

Expand the table on the right panel that lists all the tables and drag the columns folder straight in front of your select statement within the stored procedure... It'll add all the column names for you without having to type them up manually. Life saver! Definately takes some of the dross out of writing select statements for tables that have a lot of columns.

If you want to speed things up further, take out the column names you don't need selected, it'll save bandwidth and load on the server.

A useful video on this can be found below:

I take no credit for the video.


By Luke Alderton at 6 Jul 2015, 21:29 PM

Tags: MSSQL

Comments

Post a comment
Sit tight...
We're adding your comment.
Thank you.
Your comment has been added.
There's been a problem.
Please try again later.
Share with
Tags
Latest Comments
By dipbleds on Raspberry Pi - Bluetooth using Bluecove on Raspbian
12 Dec 2017, 21:29 PM
By Ich on Replacing the Xamarin Header/Navigation bar with a custom view/template
26 Nov 2017, 17:11 PM
By Ravi Motha on My experience at Umbraco UK Festival 2017
12 Dec 2017, 08:39 AM
By Borges on How to add a Xamarin Forms Loading Screen/Overlay
7 Nov 2017, 19:11 PM
By Rutul Mehta on Auto/Custom height on Xamarin Forms WebView for Android and iOS
4 Nov 2017, 03:15 AM
By Pablo on Xamarin MasterDetailPage has large margin/padding at top
26 Oct 2017, 15:31 PM
By faiza on Using MaryTTS or OpenMary in Java
22 Oct 2017, 12:54 PM
By Nietoperz on Using MaryTTS or OpenMary in Java
29 Sep 2017, 14:34 PM
Categories
App Development
Event
Game Development
Mapping
Modelling
Programming
Review
Robotics
Tutorial
Web Development