Answer Posted / dj

Select Top(5) COLUMN_NAME
from INFORMATION_SCHEMA.COLUMNS
Where TABLE_NAME = 'Emp';

What are cursors and when they are useful?

572

---

Tell me time data type, datetime2, datetimeoffset data type in sql server 2008?

560

---

What is the difference between deallocate cursor and close cursor?

707

---

Does a sql server 2005 select statement require a from?

568

---

Is sql server 2016 free?

526

---

---

Can truncate be rolled back?

532

---

How do I install only the client tools of sql server 2000?

542

---

What are the new security features added in sql server 2012? : sql server security

525

---

What is a schema in ms sql server 2005?

558

---

Explain active/passive and active/active cluster configurations?

620

---

what's the information that can be stored inside a bit column? : Sql server database administration

523

---

What is the use of keyword with encryption.

574

---

What is merge?

564

---

How to list all user defined functions in the current database?

510

---

What are the different editions available in sql server 2000?

582

---