Answer Posted / muruga nandhini.p

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 does sql server mean?

1051

---

Does index speed up select statements?

1010

---

How to reaname table name without using sp_Rename in sql server..?

982

---

What are partitioned views?

979

---

What is transaction server implicit?

998

---

How do I change my passwords (database, LDAP, and so on) without causing an outage?

1063

---

What are cursors and when they are useful?

1080

---

Describe in brief authentication modes in sql server.

1020

---

what is an index? : Sql server database administration

968

---

What are the advantages to use stored procedures?

1099

---

What is attribute? : sql server analysis services, ssas

1014

---

Explain why variables called the most powerful component of ssis?

1082

---

What is store procedure? When do you use?

923

---

What is deploy, process and build? : sql server analysis services, ssas

1099

---

What is the sql server 2000 version number?

1072

---