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

What is the difference between cube operator and rollup operator? : SQL Server Architecture

614

---

How many types of stored procedures are there in sql server?

549

---

How does index makes search faster?

595

---

Explain how to send email from sql database?

555

---

What is the difference between NOROW and LOCKROW?

2229

---

---

Explain alternate key, candidate key and composite key in sql server?

515

---

What is a transact-sql statement?

534

---

What is query optimizer in sql server?

541

---

How do I trace a query in sql server?

539

---

Suppose you want to implement the following relationships while designing tables. How would you do it?a.) One-to-oneb.) One-to-manyc.) Many-to-many

516

---

Do you know what are the steps to process a single select statement?

528

---

List layers of abstraction microsoft architectured to provide relational db through cloud platform ?

161

---

Do you know the isolation level that sql server support?

522

---

what are different types of backups available in sql server? : Sql server database administration

493

---

What are three ways you can use an identity value inside a trigger? Why would you prefer one way over another?

544

---