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 deploy, process and build? : sql server analysis services, ssas

1153

---

How can change procedure in sql server?

1124

---

Tell about MOM Tool(Microsoft Operator Manager)?

1957

---

What are the differences between having and where clause.

1014

---

How can sql server instances be hidden?

1026

---

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

2201

---

To which devices can a backup be created and where should these devices be located? : sql server management studio

1099

---

whats the maximum size of view state??

2248

---

What is scrollable cursor?

1080

---

What do you understand by a view?

1044

---

Explain index in sql server?

1061

---

Why should one not prefix user stored procedures with ‘sp_’?

1096

---

What is lock escalation? : sql server database administration

1196

---

How to run sql server 2005 books online on your local system?

999

---

Define Wed Edition in SQL Azure?

102

---