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 coalesce in sql server?

996

---

How to generate create function script on an existing function?

1049

---

What is the fillfactor concept in indexes?

935

---

Find columns used in stored procedure?

938

---

What happens if date-only values are provided as date and time literals?

978

---

How can you check the version of sql server?

1050

---

What is indexing a document?

971

---

How to modify the underlying query of an existing view?

937

---

What is the difference between DataRow.Delete() and DataRow.Remove()?

1168

---

How is sql used in sql server?

944

---

When is the use of update_statistics command?

953

---

Can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible?

962

---

If you're given a raw data table, how would perform etl (extract, transform, load) with sql to obtain the data in a desired format?

918

---

Do you know what are various aggregate functions that are available?

1017

---

What is a virtual table in sql?

944

---