<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
Article Discussions
»
Article Discussions by Author
»
Discuss content posted by ~~Hari.Bagra
»
Short cut key
52 posts, Page 2 of 6
««
1
2
3
4
5
»
»»
Short cut key
Rate Topic
Display Mode
Topic Options
Author
Message
Hari.Sharma
Hari.Sharma
Posted Tuesday, July 15, 2008 2:48 AM
Ten Centuries
Group: General Forum Members
Last Login: Wednesday, December 26, 2012 12:43 PM
Points: 1,330,
Visits: 455
As simple as it is:
-- Query
USE [MyDataBase]
GO
TableName
-- Bold shows that it is selected
-- Now Press Alt+F1
I think it is very easy and self explanatory.
See the attachment
Cheers,
Hari
Tips & Tricks for SQL BI Developers
Post Attachments
Test1.PNG
(
21 views,
23.33 KB
)
Post #534134
Shaun McGuile
Shaun McGuile
Posted Tuesday, July 15, 2008 4:20 AM
Mr or Mrs. 500
Group: General Forum Members
Last Login: Thursday, October 04, 2012 9:20 AM
Points: 583,
Visits: 1,060
Yeah so if I got it wrong cos I obviously havent answered it yet as that would be next month can i have the point back til 15th August and then lose it? :D
This question is very poor in explanation of what it is asking, like when would you push the help button combo i.e. within a query window or within object explorer?
The QOTD posters should know what pedants we all are - precision is key ambiguity leads to hell :D
--Shaun
Hiding under a desk from SSIS Implemenation Work
Post #534175
skyline666
skyline666
Posted Tuesday, July 15, 2008 5:48 AM
Old Hand
Group: General Forum Members
Last Login: Wednesday, September 24, 2008 1:27 PM
Points: 350,
Visits: 229
Hari.Sharma (7/15/2008)
As simple as it is:
-- Query
USE [MyDataBase]
GO
TableName
-- Bold shows that it is selected
-- Now Press Alt+F1
I think it is very easy and self explanatory.
See the attachment
Tried that and still got the same error. However, if I removed dbo from the table name, it worked.
Learnt something new, and still earned a point
Post #534250
Hari.Sharma
Hari.Sharma
Posted Tuesday, July 15, 2008 5:57 AM
Ten Centuries
Group: General Forum Members
Last Login: Wednesday, December 26, 2012 12:43 PM
Points: 1,330,
Visits: 455
I dont know the reason but it is working on my system without removing dbo
Cheers,
Hari
Tips & Tricks for SQL BI Developers
Post #534256
Grant Fritchey
Grant Fritchey
Posted Tuesday, July 15, 2008 6:37 AM
SSChampion
Group: General Forum Members
Last Login: Today @ 3:04 PM
Points: 13,375,
Visits: 25,159
Well it sure doesn't work by default. I tried it in 2005 and 2008 and received nothing. I also note, that the answer, ALT-F1, is not listed in the documentation linked to. I'm calling shenanigans on this one.
----------------------------------------------------
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood..." Theodore Roosevelt
The Scary DBA
Author of:
SQL Server 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans
Product Evangelist for
Red Gate Software
Post #534300
Shaun McGuile
Shaun McGuile
Posted Tuesday, July 15, 2008 6:41 AM
Mr or Mrs. 500
Group: General Forum Members
Last Login: Thursday, October 04, 2012 9:20 AM
Points: 583,
Visits: 1,060
Grant Fritchey (7/15/2008)
Well it sure doesn't work by default. I tried it in 2005 and 2008 and received nothing. I also note, that the answer, ALT-F1, is not listed in the documentation linked to. I'm calling shenanigans on this one.
Grant:
You gotta do it by highlighting the object name possibly surrounded by double quotes (if of the form schema.object e.g. "dbo.tableX" ) in a query window for it to work.
Not a good question!
Hiding under a desk from SSIS Implemenation Work
Post #534306
Grant Fritchey
Grant Fritchey
Posted Tuesday, July 15, 2008 6:44 AM
SSChampion
Group: General Forum Members
Last Login: Today @ 3:04 PM
Points: 13,375,
Visits: 25,159
OK. I got it to work... eh. I'm underwhelmed by this one. I get more out of Red Gate's SQL Prompt, easier.
One serious comment. If documentation is supplied, it really should mention the functionality that it's supposed to be documenting.
----------------------------------------------------
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood..." Theodore Roosevelt
The Scary DBA
Author of:
SQL Server 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans
Product Evangelist for
Red Gate Software
Post #534313
skyline666
skyline666
Posted Tuesday, July 15, 2008 6:46 AM
Old Hand
Group: General Forum Members
Last Login: Wednesday, September 24, 2008 1:27 PM
Points: 350,
Visits: 229
Shaun McGuile (7/15/2008)
Grant Fritchey (7/15/2008)
Well it sure doesn't work by default. I tried it in 2005 and 2008 and received nothing. I also note, that the answer, ALT-F1, is not listed in the documentation linked to. I'm calling shenanigans on this one.
Grant:
You gotta do it by highlighting the object name possibly surrounded by double quotes (if of the form schema.object e.g. "dbo.tableX" ) in a query window for it to work.
Not a good question!
Thats right. As Øystein Fallo originally pointed out, to have the schema with the table name (e.g. dbo.Test), you need double quotes around (so "dbo.Test"), whereas if it is just the table name alone (e.g. Test), then no double quotes are needed (so Test).
Post #534315
Shaun McGuile
Shaun McGuile
Posted Tuesday, July 15, 2008 6:56 AM
Mr or Mrs. 500
Group: General Forum Members
Last Login: Thursday, October 04, 2012 9:20 AM
Points: 583,
Visits: 1,060
I don't get it whats the point?
How does the functionality help me the DBA/Developer?
It gives me info on a table or proc which I could get elsewhere and more easily.
Hiding under a desk from SSIS Implemenation Work
Post #534325
Jamie Longstreet-481950
Jamie Longstreet-481950
Posted Tuesday, July 15, 2008 7:04 AM
SSCrazy
Group: General Forum Members
Last Login: Yesterday @ 6:41 AM
Points: 2,440,
Visits: 713
Did anyone else notice the date for this QOTD is a month in the future?
Doc Brown rules!
Was that weird or what!
Jamie
Post #534340
« Prev Topic
|
Next Topic »
52 posts, Page 2 of 6
««
1
2
3
4
5
»
»»
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
