Answer Posted / selvaraj.v

In SQL Server 2000,
Query:
------
select count from employees
Answer:
------
invalid column name 'count'


In SQL Server 2000,
Query:
------
select count(*) from employees

Answer:
-------
No column name
----------------
1. 20

What do mean by xml datatype?

1021

---

Explain what is raid and what are different types of raid levels?

967

---

What happens if you add a new index to large table?

894

---

What is instead of dml trigger?

958

---

How to find the list of fixed hard drive and free space on server?

1111

---

Name 3 of the features that the sql server built-in function loginproperty performs on standard logins? : sql server security

1052

---

What is lock escalation and what is its purpose?

929

---

What is a user-defined function in the sql server and what is its advantage?

1051

---

What according to you is the difference between mysql and sql server performance?

1030

---

How to connect to a sql server using odbc_connect()?

1103

---

How do you maintain database integrity where deletions from one table will automatically cause deletions in another table?

1149

---

Can an automatic recovery be initiated by a user?

948

---

What is nested transaction?

1056

---

Where the sql logs gets stored? : sql server database administration

925

---

tell me what are the steps you will take to improve performance of a poor performing query? : Sql server database administration

970

---