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

What do you mean by stored techniques? How would we use it?

996

---

What is temporary stored procedure?

911

---

What is transaction server explicit transaction?

986

---

What are the different types of normalization?

1105

---

What are the different type of replication in sql server?

951

---

What is extent? Types of extents?

1112

---

can a table be moved to different filegroup? : Sql server administration

937

---

What is query parameter in ssrs?

148

---

How can you hide the sql server instances?

987

---

How will you decide the active and passive nodes?

1092

---

what is an extended stored procedure? Can you instantiate a com object by using t-sql? : Sql server database administration

981

---

What do you mean by tablesample?

1049

---

Explain microsoft sql server functions?

1058

---

What is a primary key?

917

---

How many types of triggers in sql server?

989

---