Short cut key

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by ~~Hari.Bagra » Short cut key

52 posts, Page 1 of 6

1 2 3 4 5 »»»

Short cut key

Rate Topic

Display Mode

Topic Options

Author

Message

Hari.Sharma

Posted Monday, July 14, 2008 1:11 PM

Ten Centuries

Group: General Forum Members
Last Login: Wednesday, December 26, 2012 12:43 PM
Points: 1,330, Visits: 455

Comments posted to this topic are about the item Short cut key

Cheers,
Hari
Tips & Tricks for SQL BI Developers

Post #533843

notquitexena

Posted Monday, July 14, 2008 1:37 PM

SSC Eights!

Group: General Forum Members
Last Login: Monday, November 02, 2009 8:46 AM
Points: 875, Visits: 313

Did anyone else notice the date for this QOTD is a month in the future?

Doc Brown rules!

Blink

Post #533863

OCTom

Posted Monday, July 14, 2008 3:09 PM

SSCrazy

Group: General Forum Members
Last Login: Yesterday @ 6:52 AM
Points: 2,018, Visits: 2,852

I'm fairly new to SQL Server so I may not be seeing it. ALT+F1 brings up nothing at all in management studio. Also, isn't sp_help used in code?

Unsure

Post #533928

Vivien Xing

Posted Monday, July 14, 2008 8:24 PM

Ten Centuries

Group: General Forum Members
Last Login: Tuesday, March 26, 2013 7:19 AM
Points: 1,279, Visits: 2,191

The link "SQL Server Management Studio Keyboard Shortcuts" is very helpful.

Post #533994

Karl_Chand

Posted Monday, July 14, 2008 9:31 PM

SSC Veteran

Group: General Forum Members
Last Login: Wednesday, May 08, 2013 4:46 PM
Points: 282, Visits: 101

Alt+F1 acts a little different to sp_help. sp_help list specifics for an object while Alt+F1 list all objects in a selected database.

Post #534011

Hari.Sharma

Posted Monday, July 14, 2008 11:28 PM

Ten Centuries

Group: General Forum Members
Last Login: Wednesday, December 26, 2012 12:43 PM
Points: 1,330, Visits: 455

Karl_Chand (7/14/2008)

Alt+F1 acts a little different to sp_help. sp_help list specifics for an object while Alt+F1 list all objects in a selected database.

Did you really try this?

Just select a table name and press Alt+F1 and see the result...

Cheers,
Hari
Tips & Tricks for SQL BI Developers

Post #534044

AntonDeski

Posted Monday, July 14, 2008 11:49 PM

SSC Veteran

Group: General Forum Members
Last Login: Wednesday, April 28, 2010 2:15 AM
Points: 214, Visits: 31

Even though my Studio is set up for the shortcut, it doesn't do anything. Most probably because I've got a soft-KVM and that seems to blat most shortcuts just because it can. ;)

I'll have to try it at home.

Post #534050

Iggy-SQL

Posted Monday, July 14, 2008 11:55 PM

SSCrazy

Group: General Forum Members
Last Login: Sunday, May 19, 2013 7:02 PM
Points: 2,861, Visits: 405

I don't have SQL Server 2005 so I can't test, but according to the keyboard shortcut list on BOL (http://msdn.microsoft.com/en-us/library/ms174205.aspx) there is no ALT+F1 at all. Is this a custom keyboard shortcut?

Urbis, an urban transformation company

Post #534052

skyline666

Posted Tuesday, July 15, 2008 2:08 AM

Old Hand

Group: General Forum Members
Last Login: Wednesday, September 24, 2008 1:27 PM
Points: 350, Visits: 229

Hari.Sharma (7/14/2008)
Did you really try this?

Just select a table name and press Alt+F1 and see the result...

Just select a table name and press Alt+F1, is that all I have to do? I click on a table name in the object explorer and pressed Alt+F1 and nothing happened, so I made a new query and put the table name in there (with and without the database name), and I received an error:

Msg 102, Level 15, State 1, Line 1
Incorrect syntax near '.'.

So what do I need to do to see this? Does doing this in Management Studio Express 2005 not work?

PS. I see I wasn't the only one to confuse this with the "How Do I" under Help on the toolbar Hehe

EDIT:
Why is this QOTD for next month anyway? I know there is a question for this month, and that would have something to do with it.

Post #534117

Øystein Fallo

Posted Tuesday, July 15, 2008 2:25 AM

Ten Centuries

Group: General Forum Members
Last Login: Wednesday, April 10, 2013 8:38 AM
Points: 1,419, Visits: 420

You have to enclose the object name in double-quotes when using two-part names (include schema)..
like this : "dbo.spt_values" (in master).

Post #534121

« Prev Topic | Next Topic »

52 posts, Page 1 of 6

1 2 3 4 5 »»»

Permissions