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 implement data mining in SSRS?

146

---

What are the different ways you can create databases in sql server?

1081

---

What is a primary key?

943

---

What do you mean by acid?

976

---

Difference between DELETE and TRUNCATE?

1036

---

What do you mean by collation recursive stored procedure?

1044

---

Write a sql query to display the current date?

1078

---

what are different types of backups available in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration

917

---

What is a mixed extent?

998

---

What are the different types of normalization?

1144

---

How to return the second 5 rows in ms sql server?

1044

---

Why truncate is ddl command?

1044

---

How you would rewrite the sql query to return the customerid sorted numerically?

975

---

Can you explain about buffer cash and log cache in sql server?

934

---

Mention the differences between substr and charindex in sql server.

1027

---