Answer Posted / jaleel ahamed s

create table emp (empid int,empname varchar)

insert into emp values (101,'a')
insert into emp values (102,'b')
insert into emp values (103,'a')
insert into emp values (104,'c')
insert into emp values (105,'a')

select * from emp

SELECT EmpName,Count(EmpID)Cnt From Emp Group By EmpName
Having Count(EmpName) > 1

Which tcl commands are available on the sql server?

1086

---

What is the parse query button used for?

1041

---

what does the automatic recovery do? : Sql server administration

1024

---

Is candidate a key?

955

---

Explain having clause?

972

---

What is the difference between for xml raw and for xml auto?

1033

---

System variable and temporary variables

2255

---

What is query cost in sql server?

998

---

Explain go command in sql server?

1041

---

What are system databases in ms sql server?

1062

---

What is the purpose of data source?

1043

---

Explain index in sql server?

1021

---

How to delete an existing database user?

1021

---

Does any body please help me what question's have asked for SSRS in the interview?

2149

---

what is denormalization? : Sql server database administration

929

---