Tuesday, February 14, 2012

Command to run for a query

I nee to query the passwordtxt table. I have never even made a query before
and i was wondering if some couold tell me the command to do so. I have the
table selected but not sure what to type in the window
Thanks
If you want to return data from a table the "SELECT" command is used. Here
is the syntax for a SELECT command (from Books Online). To find out more
read Books Online.
SELECT select_list
[ INTO new_table ]
FROM table_source
[ WHERE search_condition ]
[ GROUP BY group_by_expression ]
[ HAVING search_condition ]
[ ORDER BY order_expression [ ASC | DESC ] ]
----
-
Need SQL Server Examples check out my website
http://www.geocities.com/sqlserverexamples
"rocker40" <rocker40@.discussions.microsoft.com> wrote in message
news:F0AA7C7E-56C0-457E-80ED-D9A76C9C80F7@.microsoft.com...
> I nee to query the passwordtxt table. I have never even made a query
before
> and i was wondering if some couold tell me the command to do so. I have
the
> table selected but not sure what to type in the window
> Thanks

No comments:

Post a Comment