Is There a Microsoft product for create an automatic "graphical report" by a
source code SQL, to rectify query and to view the fields and tables used by
query???

Thanks

I'm not entirely sure what you want, but I think you want this:
1. In SQL Server Management Studio, connect Object Explorer, expand your
server, expand Databases, expand your database, right-click Views, and then
click New View.
2. Either build your view (query), or if you have a query you want to see,
past the query into the third of the 4 panes (the SQL pane). When you move
out of the SQL pane your graphical query will show (if it doesn't have any
errors).
If you don't see the SQL pane, right-click anywhere, point to Pane, and then
click SQL.
--
Rick Byham, MSFT
(Implies no warranty or rights)


"Marco R." <Marco R. (AT) discussions (DOT) microsoft.com> wrote

Marco R. (Marco R. (AT) discussions (DOT) microsoft.com) writes:
There is the Query Designer that Rick pointed to. But permit me to say
that this is a piece of crap. There is a lot of SQL syntax that it does
not support. There is all reason to stay away from it.

--
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

It's not exactly what I want...
For example I would like the possibility of write comments in the objects,
I'd like to see the real result of query and not only the list of tables,
fields and links by them...I'd like use a standard SQL ambient and not SQL
server...
I have got a MSDN Premium License, Is there a product in this suite with
these funtions???

Thanks in advance.


"Erland Sommarskog" wrote:

Marco Rossi (MarcoRossi (AT) discussions (DOT) microsoft.com) writes:
Not that I know of.

As for writing comments into objects, SQL Server has a feature that
is called extended properties, where you can store comments about
tables, columns etc. But view all that data in a query? No.


--
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