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

Explain the database you used in your final year project?

1030

---

If you lose rights to your sql server instance what are the options to connect to sql server instance? : sql server security

1028

---

How to rebuild the master database?

1074

---

Any one plz send me SQL Server Developer/DBA resume for 4 years experience

2739

---

how to overcome kernel isssues

1617

---

What is difference between unique and primary key?

896

---

What is a trigger in sql server?

1159

---

when would you go for denormalization? : Sql server database administration

859

---

What language is sql server written in?

1021

---

How to apply cascading referential integrity in place of triggers?

1025

---

What is difference between count (*) and count column?

888

---

Write the syntax for stuff function in an sql server?

1019

---

What is mean by clustered index and non clustered index, give syntax of creation? : sql server database administration

1079

---

What is a collation?

1084

---

How to display a past time in days, hours and minutes?

1010

---