sql - How do I change the default SELECT TOP 1000 query to use * instead of each field? -

-

in ssms 2008 r2, have default select top 1000 , edit top 200 queries right click menu. i've seen can change # of rows returns in options.

what i'm after is, can tell select * instead of expanding , including every field?

it's not performance issue or anything, annoyance when querying tables more 5 fields, i'd select *.

for example, if have table following fields:

  • firstname
  • lastname
  • birthday
  • city
  • state
  • zip

when right click on persons table , choose "select top 1000 rows" menu, i'd query run 

select top 1000 *  people

and not

select top 1000 firstname, lastname, birthday, city, state, zip people

edit suspect there isn't answer this, thought i'd see if figured out.

i don't believe there way of customising native ssms functionality. can use ssms tools pack addin "custom scripts" type of thing.

screenshot

(though honest selecting columns , typing * might quick navigating menu)

screenshot 2


Comments

Post a Comment

Popular posts from this blog

c# - Is it possible to remove an existing registration from Autofac container builder? -

-
something along lines: builder.registertype<mytype>().as<itype>(); builder.registertype<mytype2>().as<itype>(); builder.deregistertype<mytype>().as<itype>() var container = builder.build(); var types = container.resolve<ienumerable<itype>>(); assert.istrue(types.count == 1); assert.istrue(types[0].gettype == typeof(mytype2)); scenario: go through bunch of assemblies , go register types want make sure have 1 implementation of given type. need before create container. track on own nice if autofac me bit. this cannot done directly using containerbuilder , unless start on new one. mind you, having first built container should able construct new container filtering away unwanted types , reusing registrations first container. this: ... var container = builder.build(); builder = new containerbuilder(); var components = container.componentregistry.registrations .where(cr => cr.activator.limittype != typ...
Read more

asp.net - Error '2035' ('MQRC_NOT_AUTHORIZED') While Connecting to MQ -

-
i getting error while connecting ibm mq. know because of privileges, there way check connection ibm mq? please suggest. the 2035 suggests connection getting qmgr. if had wrong channel name, host or port 2059. 2035 means connection made listener, found channel of name requested , attempted connection. if want test past point necessary either authorize id using connect or put authorized id in mcauser attribute of channel. for detailed explanation of how wmq security works on client channels, see wmq base hardening presentation @ http://t-rob.net/links .
Read more