Answer / Amit Kumar Srivastav

"Time", "datetime2", and "datetimeoffset" are data types used to store date and time values in SQL Server 2008. The 'time' data type stores time-only values without a date component. The 'datetime2' data type provides improved precision over the traditional 'datetime' data type, with support for fractional seconds up to nanoseconds. The 'datetimeoffset' data type is similar to 'datetime2', but it includes an offset from UTC (Coordinated Universal Time) for time zones.

How to link tables in sql server?

1 Answers  

---

Write a Select Query to display title for each group of records, which are collected with Compute Clause? Like titlefield column-A column-B ..... ..... ..... Sum ... titlefield column-A column-B ..... ..... ..... Sum ...

1 Answers   Crown Solutions,

---

Which sql server table is used to hold the stored procedure script?

1 Answers  

---

Define tempdb database?

1 Answers  

---

How to Run a Query on a Remote SQL Server?

2 Answers  

---

what's the difference between SQL & MY-SQl...? And what we learn from these ....?

2 Answers   Broadridge,

---

What is the order by used for?

1 Answers  

---

when we use function instead of procedure? plz tell me the situation with ex?

3 Answers   IBM,

---

explain query execution plan

1 Answers  

---

List the types of recovery model available in sql server?

1 Answers  

---

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

1 Answers  

---

Every night you run a full backup after every 3 three hours you make a differential backup every hour you make an incremental backup in a worst-case scenario, how much work you can lose?

1 Answers  

---