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 the sql profiler?

0 Answers  

---

What is fill factor and pad index?

0 Answers  

---

Define self join in sql server joins?

0 Answers  

---

How to find 6th highest salary from Employee table ?

10 Answers  

---

What is "scheduled jobs" or "scheduled tasks"?

0 Answers  

---

how to find maximum identity number in a table ?

2 Answers   JPMorgan Chase, Thomson Reuters, Wipro,

---

How do I find my localdb version?

0 Answers  

---

How to transfer Logins from SQL Server 2000 to 2005

2 Answers  

---

If any stored procedure is encrypted, then can we see its definition in activity monitor?

0 Answers  

---

How to stop log file growing too big?

0 Answers  

---

Explain fundamentals of Data ware housing & OLAP?

2 Answers  

---

What are basics of policy management?

0 Answers  

---