Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12345»»»

Short cut key Expand / Collapse
Author
Message
Posted Tuesday, July 15, 2008 2:48 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen 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 (23 views, 23.33 KB)
Post #534134
Posted Tuesday, July 15, 2008 4:20 AM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Thursday, October 4, 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
Posted Tuesday, July 15, 2008 5:48 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld 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
Posted Tuesday, July 15, 2008 5:57 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen 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
Posted Tuesday, July 15, 2008 6:37 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Today @ 12:12 PM
Points: 15,517, Visits: 27,896
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
Posted Tuesday, July 15, 2008 6:41 AM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Thursday, October 4, 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
Posted Tuesday, July 15, 2008 6:44 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Today @ 12:12 PM
Points: 15,517, Visits: 27,896
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
Posted Tuesday, July 15, 2008 6:46 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld 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
Posted Tuesday, July 15, 2008 6:56 AM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Thursday, October 4, 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
Posted Tuesday, July 15, 2008 7:04 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Saturday, June 28, 2014 8:50 AM
Points: 2,649, Visits: 766
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 »

Add to briefcase ««12345»»»

Permissions Expand / Collapse