two tables with table name ship(name,year) and battle (name,year),how to find t

two tables with table name ship(name,year) and battle
(name,year),how to find the latest added year in the table
ship

Question Posted / prithiba

two tables with table name ship(name,year) and battle (name,year),how to find the latest added year..

Answer / challa yerriswamy

by using timestamp data type

Is This Answer Correct ?

3 Yes

1 No

More SQL Server Interview Questions

Explain what is sql server english query?

Explain what is analysis service repository?

what is meant by sql injection with example and one more question how to catch the errors in sqlserver

What is the impact on other user sessions when creating indexes?

How do I start sql server agent automatically?

Explain candidate key, alternate key, and composite key?

How many types of keys are there?

Explain the concepts and capabilities of sql server?

What are the different methods available under sqlcommand class to access the data?

Explain triggers in sql?

What are system databases into sql server (2005/2008)?

Does union all remove duplicates?

For more SQL Server Interview Questions Click Here