Office Document APIs for .NET
ITIL Career Advice
PMP Career Advice
Android Intel XDK
Welcome Guest !
what is the use of select hint in sql server? why they use?
on 11/17/2012 |
| Views : 853 | Status :
| Replies : 1
Write New Post
Un Answered Posts
what is the use of select hint in sql server? why they use? can you give example
Reply with Attachment
Databases store data for later retrieval. Do you know how that is achieved? It's the SELECT SQL command that does the job.
That's what it's all about, retrieving data from the database tables. It's part of the data manipulation language that is responsible for query the data from the database.
An SQL SELECT Example:
The "Persons" table:
P_Id LastName FirstName Address City
1 Hansen Ola Timoteivn 10 Sandnes
2 Svendson Tove Borgvn 23 Sandnes
3 Pettersen Kari Storgt 20 Stavanger
Now we want to select the content of the columns named "LastName" and "FirstName" from the table above.
We use the following SELECT statement:
SELECT LastName,FirstName FROM Persons
The result-set will look like this:
For more Refer these links
, if this helps please
Mark As Answer
Login to post response
How to Resolve this installation issue
When create Excel file using c# cannot open it
how to resolve it issues
How to resolve this export Issue
How to Solve 'The remote procedure call failed' with reason.
How to sort and paginate the table, Please its very urgent, help me
How to search values while hidden and visible, Please its urgent
How to pass qr image from picture box to RDLC report