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

I have to display ten columns values from diffrent ten tables. how many joins are require?

10 Answers   CarrizalSoft Technologies, HCL,

---

What is set nocount on?

0 Answers  

---

what is the maximum size of sql row in mssql?

1 Answers  

---

What is indexing explain it with an example?

0 Answers  

---

How many types of system privileges are there, Can we add or delete privileges?

2 Answers  

---

How is sql used in sql server?

0 Answers  

---

What is data block and how to define data block size?

0 Answers  

---

Define constraints and give an example of their use?

0 Answers  

---

How to disable a login name in ms sql server?

0 Answers  

---

What are orphan records?

0 Answers  

---

Does server sql treat char as a variable-length or fixed-length column?

0 Answers  

---

What do you mean by a dependent functionality in a build?

0 Answers   HCL,

---