Answer Posted / bhagwat sharma

create table student
(
roll_no int,
name varchar(20),
class int,
address varchar(50),
phone int
)
++++++++++++++++run select than press f5

insert into student values(1,'Bhagwat',10,'Mathura',9268450493)
+++++++++++++run select than press f5

select * from student where roll_no=1
+++++++++++++++++++++++++++run select than press f5

what is a deadlock? : Sql server database administration

679

---

Is it true, that there is no difference between a rule and a check constraint?

686

---

Tell me what is sql profiler?

790

---

What is user-defined functions? What are the types of user-defined functions that can be created?

756

---

What is the template in sql?

726

---

---

What are different types of constraints?

692

---

What do you mean by table and field in sql?

738

---

What does indexation mean?

690

---

List all the types of user-defined functions?

685

---

what are the different types of SSRS reports?

122

---

What is attribute relationships, why we need it? : sql server analysis services, ssas

669

---

Explain transaction server implicit?

686

---

Explain filtered indexes benefits?

768

---

In what sequence sql statement is processed?

760

---

How will you make an attribute not process? : sql server analysis services, ssas

753

---