Answer / 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

Answer / 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

Explain the properties of sub-query in sql server?

0 Answers  

---

what are file groups?

3 Answers   Evalueserve,

---

What do you understand by replication in sql server?

0 Answers  

---

what is lazy writer?

1 Answers   Wipro,

---

Tell me what are cursors and when they are useful?

0 Answers  

---

---

What are the benefits and tasks of object explorer? : sql server management studio

0 Answers  

---

Does sql server use java?

0 Answers  

---

Do you know nested transaction?

0 Answers  

---

what happens on checkpoint? : Sql server database administration

0 Answers  

---

Is it true that rules do not apply to data already existing in a database at the time the rule is created?

0 Answers  

---

Can a table be created inside a trigger?

0 Answers  

---

explain what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration

0 Answers  

---