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

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!


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

2 Answers

  • 1 decade ago
    Favorite Answer

    select *

    from test_database.dbo.tradeMark

    where markidentification = 'Microsoft'

    Source(s): twitter: @lud0matic
  • CatNip
    Lv 6
    1 decade ago

    use test_database

    Select * From tradeMark Where Markidentication='Microsoft'

Still have questions? Get your answers by asking now.