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

Differentiate between a having clause and a where clause.

1010

---

Define inner join? Explain with an example?

1050

---

What are the security related catalog views? : sql server security

992

---

Explain sql server service broker?

1026

---

What is the difference between local and global temporary tables?

1196

---

Can another user execute your local temporary stored procedures?

1024

---

Can we add an identity column to decimal datatype?

1042

---

Explain primary key, foreign key and unique key?

1024

---

Explain the creation and execution of a user-defined function in the sql server?

1113

---

Why Master database is required?

1188

---

Explain the difference between control flow and data flow?

1061

---

What is trigger and different types of Triggers?

1199

---

How to modify an existing user defined function?

1171

---

How to loop through returning rows?

1091

---

What are the different types of replication you can set up in sql server?

1089

---