MSSQL Query Syntax -- Finding a record in a specific table and column...?

Question

I am wanting to perform some queries to find a specific record in a certain column from a certain table in my database. What is the correct syntax to do this?

Could someone write a query if i wanted to search "Microsoft" in a database called test_database, a specific tabled called "tradeMark" and a specific column called "MarkIdentification"

10 easy points!! this is basic MSSQL stuff!

Update:

Thanks guys, that worked perfectly, I will try to remember to log in and give best answer in 3.5 hours

Answer 1

Favorite Answer

select *

from test_database.dbo.tradeMark

where markidentification = 'Microsoft'

Source(s): twitter: @lud0matic

Answer 2

use test_database

Select * From tradeMark Where Markidentication='Microsoft'