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 are different backups available in sql server?

994

---

Does a sql server 2005 select statement require a from?

969

---

Explain cursor as data base object?

973

---

What area unit the various kinds of info compression introduced in sql server 2008?

1034

---

What are the different index configurations a table can have?

898

---

Do you know what are the ways available in sql server to execute sql statements?

962

---

What is role playing dimension with two examples? : sql server analysis services, ssas

952

---

Do you know what is blocking?

898

---

What are the underflow and overflow behaviors on float literals?

1058

---

What are alternate keys?

933

---

How to get the definition of a trigger back?

957

---

Suppose you want to implement the one-to-many relationships while designing tables. How would you do it?

912

---

What is @@rowcount in sql?

949

---

Explain trigger classes i.e. Instead of and after trigger?

824

---

Which data types generate inaccurate results if used with an = or <> comparison in a where clause of a sql statement?

992

---