two tables with table name ship(name,year) and battle
(name,year),how to find the latest added year in the table
ship
Answer Posted / challa yerriswamy
by using timestamp data type
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
What is a partition function in sql server?
What were the latest updates to SQL Azure service?
Tell me what is difference between clustered and non clustered index?
Which database stores information about replication?
What is log shipping? Can we do logshipping with SQL Server 7.0 - Logshipping is a new feature of SQL Server 2000. We should have two SQL Server - Enterprise Editions. From Enterprise Manager we can configure the logshipping. In logshipping the transactional log file from one server is automatically updated into the backup database on the other server. If one server fails, the other server will have the same db and we can use this as the DR (disaster recovery) plan.
tell me what is blocking and how would you troubleshoot it? : Sql server database administration
Do you know what is difference between stored procedure and user defined function?
What is a hint?
Difference between DELETE and TRUNCATE?
Mention the uses of stored procedures.
What is multi-statement table-value user-defined function?
Explain what are the different index configurations a table can have?
Can sql server be linked with other servers like oracle?
What do you mean by an execution plan? How would you view it?
Explain concepts of analysis services?