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 are the extra roles available in msdb? : sql server security

1141

---

How to provide default values to stored procedure parameters?

1071

---

Explain database normalization?

1234

---

What is lock escalation and what is its purpose?

979

---

How to compare the top two records using sql?

1353

---

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

1028

---

How do I save a stored procedure in sql server?

1007

---

What is indexing explain it with an example?

1020

---

What is global temp table?

1003

---

Give some Scenario for Non Clusterd index? Can we write system defined functions in side The Function? Wat is the Unique Datatype?

2513

---

What is blocking and how would you troubleshoot it? : sql server database administration

1054

---

Is null vs coalesce?

891

---

Please differentiate between a local and a global temporary table?

1014

---

Can multiple columns be used in sql group by clause in ms sql server?

1058

---

Can group by be used without aggregate functions?

928

---