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 different types of jions with examples briefly?

1 Answers   Zensar,

---

How to stop log file growing too big?

0 Answers  

---

Is mysql better than sql server?

0 Answers  

---

how to find number of columns in a table in sql server 2000 and 2005 also

7 Answers   HCL, Virtusa,

---

How to skip remaining statements in a loop block using continue statements?

0 Answers  

---

What is use of except clause? How does it differ from not in clause?

0 Answers  

---

what is maximum size of temp db?

4 Answers   iSoft,

---

What are scalar functions in sql?

0 Answers  

---

What is the log shipping?

0 Answers  

---

What is temporal data type?

0 Answers  

---

Can you give me some DBCC command options?(Database consistency check) - DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked.and DBCC CHECKALLOC - To check that all pages in a db are correctly allocated. DBCC SQLPERF - It gives report on current usage of transaction log in percentage. DBCC CHECKFILEGROUP - Checks all tables file group for any damage.

0 Answers   iSoft,

---

What is intellisense?

0 Answers  

---