Saturday, August 3, 2013

Is there a syntax that will allow me to exclude certain columns versus explicitly stating every column that I want?



Your assuming that the queries I am interested in are going to be forever embedded in my code that will be viewed in awe by millions of people in future generations. Alas, this is not the case.


I simply find it necessary to craft certain queries on-the-fly to check different data values at different times after different operations or methods are called. And in these situations I would probably save much time if I didn't have to switch in and out of different applications to do so. Visual Studio 2012 has an extension called SSDT which lets you perform queries in Visual Studio 2012. But I am sure you already knew that.


It would be a plus not to have to go into SSMS everytime to craft my "once-off" queries.


So yeah, the ability to be able to execute a short-hand query by typing it in on a whim has value to me.


Do you happen to be a Microsoft Employee by any chance? Your response seems to have an underlying tone that implies I should just "deal with it" the way it is.


The more ways I can accomplish the same goals in life the more empowered I feel. Is there a reason that Microsoft shouldn't think about implementing this type of functionality?




System configuration: Windows 7 RTM, Gigabyte GA-EP45-UD3L motherboard, Intel Pentium Dual-Core E6300 Wolfdale @ 2.8GHz, 4GB PC-1066 DDR2 Patriot Viper Memory, 500 GB Western Digital Hard Disk, "GeForce 8800GT" videocard


No comments:

Post a Comment