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

What is join and name different type of joins?

0 Answers  

---

What are pages and extents? : SQL Server Architecture

0 Answers  

---

How to create a simple table to test triggers in ms sql server?

0 Answers  

---

Explain the truncate command? : SQL Server Architecture

0 Answers  

---

What is the difference between grant and with grant while giving permissions to the user?

0 Answers  

---

---

Do you know what are various aggregate functions that are available?

0 Answers  

---

what is a major difference between sql server 6.5 and 7.0 platform wise? : Sql server database administration

0 Answers  

---

What is ms sql server reporting services?

0 Answers  

---

What is a transaction and what are ACID properties?

14 Answers   Config Systems, IBM, TCS, Virtusa,

---

What do you mean by an execution plan? Why is it used?

0 Answers  

---

Difference between primary key and clustered index?

0 Answers  

---

What is trigger and different types of Triggers?

0 Answers   QuestPond,

---