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 difference between clustered index and non clustered index?

1058

---

Is sql server 2016 free?

912

---

What are the different acid properties?

1046

---

What does nvl stand for?

934

---

Explain transaction server implicit?

971

---

How do I completely remove sql server instance?

1077

---

Explain differentiate between a having clause and a where clause?

890

---

What is a join in sql?

1069

---

What is the maximum size per database for sql server express?

1025

---

What are sql server procedures?

958

---

How many categories of functions based their return modes?

1088

---

Explain what is row_number function?

1005

---

What are distinctive joins find as a part of sql?

939

---

How to delete existing triggers using "drop trigger"?

1037

---

What is the language structure to add a record to a table?

1009

---