 | |
Greyed out View Designer and Query Designer
microsoft.public.sqlserver.tools microsoft.public.sqlserver.tools
 |
| | Thread Tools | Display Modes |
#91
 
| |||
| |||
|
Re: Greyed out View Designer and Query Designer -
12-30-2008
, 04:57 PM
|
Without arguing any of the other points, you can use table aliases in the View Designer. Open the designer and add a table. With the table selected, press F4 to open the Properties window. Now you can see an Alias box. |
Thanks for the enlightment, Rick!
--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se
Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx
#92
| |||
| |||
|
|
Rick Byham, (MSFT) (rickbyh (AT) REDMOND (DOT) CORP.MICROSOFT.COM) writes: Without arguing any of the other points, you can use table aliases in the View Designer. Open the designer and add a table. With the table selected, press F4 to open the Properties window. Now you can see an Alias box. Now, that was well hidden! Does not show up in a context menu or anything. Thanks for the enlightment, Rick! -- Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se Links for SQL Server Books Online: SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx |
#93
| |||
| |||
|
|
Rick Byham, (MSFT) (rickbyh (AT) REDMOND (DOT) CORP.MICROSOFT.COM) writes: Without arguing any of the other points, you can use table aliases in the View Designer. Open the designer and add a table. With the table selected, press F4 to open the Properties window. Now you can see an Alias box. Now, that was well hidden! Does not show up in a context menu or anything. Thanks for the enlightment, Rick! -- Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se Links for SQL Server Books Online: SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx |
#94
| |||
| |||
|
|
Rick Byham, (MSFT) (rickbyh (AT) REDMOND (DOT) CORP.MICROSOFT.COM) writes: Without arguing any of the other points, you can use table aliases in the View Designer. Open the designer and add a table. With the table selected, press F4 to open the Properties window. Now you can see an Alias box. Now, that was well hidden! Does not show up in a context menu or anything. Thanks for the enlightment, Rick! -- Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se Links for SQL Server Books Online: SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx |
#95
| |||
| |||
|
|
Rick Byham, (MSFT) (rickbyh (AT) REDMOND (DOT) CORP.MICROSOFT.COM) writes: Without arguing any of the other points, you can use table aliases in the View Designer. Open the designer and add a table. With the table selected, press F4 to open the Properties window. Now you can see an Alias box. Now, that was well hidden! Does not show up in a context menu or anything. Thanks for the enlightment, Rick! -- Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se Links for SQL Server Books Online: SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx |
#96
| |||
| |||
|
|
Rick Byham, (MSFT) (rickbyh (AT) REDMOND (DOT) CORP.MICROSOFT.COM) writes: Without arguing any of the other points, you can use table aliases in the View Designer. Open the designer and add a table. With the table selected, press F4 to open the Properties window. Now you can see an Alias box. Now, that was well hidden! Does not show up in a context menu or anything. Thanks for the enlightment, Rick! -- Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se Links for SQL Server Books Online: SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx |
#97
| |||
| |||
|
|
Rick Byham, (MSFT) (rickbyh (AT) REDMOND (DOT) CORP.MICROSOFT.COM) writes: Without arguing any of the other points, you can use table aliases in the View Designer. Open the designer and add a table. With the table selected, press F4 to open the Properties window. Now you can see an Alias box. Now, that was well hidden! Does not show up in a context menu or anything. Thanks for the enlightment, Rick! -- Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se Links for SQL Server Books Online: SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx |
#98
| |||
| |||
|
|
Rick Byham, (MSFT) (rickbyh (AT) REDMOND (DOT) CORP.MICROSOFT.COM) writes: Without arguing any of the other points, you can use table aliases in the View Designer. Open the designer and add a table. With the table selected, press F4 to open the Properties window. Now you can see an Alias box. Now, that was well hidden! Does not show up in a context menu or anything. Thanks for the enlightment, Rick! -- Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se Links for SQL Server Books Online: SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx |
#99
| |||
| |||
|
|
Rick Byham, (MSFT) (rickbyh (AT) REDMOND (DOT) CORP.MICROSOFT.COM) writes: Without arguing any of the other points, you can use table aliases in the View Designer. Open the designer and add a table. With the table selected, press F4 to open the Properties window. Now you can see an Alias box. Now, that was well hidden! Does not show up in a context menu or anything. Thanks for the enlightment, Rick! -- Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se Links for SQL Server Books Online: SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx |
#100
| |||
| |||
|
|
Rick Byham, (MSFT) (rickbyh (AT) REDMOND (DOT) CORP.MICROSOFT.COM) writes: Without arguing any of the other points, you can use table aliases in the View Designer. Open the designer and add a table. With the table selected, press F4 to open the Properties window. Now you can see an Alias box. Now, that was well hidden! Does not show up in a context menu or anything. Thanks for the enlightment, Rick! -- Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se Links for SQL Server Books Online: SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx |
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.