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

Can you please explain the difference between function and stored procedure?

1048

---

Explain what is the purpose of sql profiler in sql server?

1131

---

Which data type columns are the best candidates for full-text indexing?

1023

---

What is extended stored procedures?

1026

---

What is difference between rownum and row_number?

1023

---

Explain how would you store your query in an SSRS report or a Database server?

135

---

How to sort query output in descending order in ms sql server?

985

---

You want your report to display a hyperlink that will take users to your intranet. How do you configure such a hyperlink?

319

---

How many types of keys are there?

1076

---

What is the difference between a local and a global temporary table?

1174

---

Tell me can we use custom code in ssrs?

1054

---

Explain what stored procedure sp_replcounters is used for? : sql server replication

1577

---

What are the different acid properties?

1122

---

Does the order of columns in update statements matter?

956

---

How to execute a sql statement using mssql_query()?

1104

---