>>> Programming >> MSSQL > How to select something from SQL Server? (This page has been seen 538 times)
How to select something from SQL Server?
To execute a command to SQL Server you can use the Query Analyzer that comes
with MSSQL Server. Or you can use your programming language to execute code to
the SQL Server. I recommend using Query Analyzer when building your SQL
Statements because its alot easier to find errors when you are able to se your
output live
Here is a simple way to select something from SQL Server.
SELECT * FROM MyTable
What this means is SELECT EVERYTHING FROM MYTABLE. * Means Everything. So this will return every column you have in MyTable. If you want to select just one single column you can do like this.
SELECT Field1 FROM MyTable
Here is a simple way to select something from SQL Server.
SELECT * FROM MyTable
What this means is SELECT EVERYTHING FROM MYTABLE. * Means Everything. So this will return every column you have in MyTable. If you want to select just one single column you can do like this.
SELECT Field1 FROM MyTable
Like
Dislike
Keywords for this article:
SELECT || TSQL || SQL
Advertisement by Google
Comment:
Code Language:
Code:
Here you can paste a code example. It will then be processed by SyntaxHighlighter and formatted for easier readability.
Please remember to select the correct Code Language in the select above so the SyntaxHighlighter can highlight the code properly.
Code:
Please enter the code you see above
What is 8 + 2 =