Answer / Devaj Pandey

SQL Sandbox is a feature in SQL Server that provides an isolated environment for testing and experimenting with database changes without affecting the production data. It allows users to create temporary databases with limited resources, perform queries, and drop the databases when they are no longer needed.

What are the differences between “row_number()”, “rank()” and “dense_rank()”?

1 Answers  

---

Following are some of the question related to below mentioned query? select e1.salary from employee3 e1 where 2= ( select count(distinct(e2.salary)) from employee3 e2 where e2.salary>=e1.salary ) 1) What the query returns? 2) How it works? - Detail explanation (what the sub query does, why it is (where 2=)....etc...Please?

5 Answers  

---

Why is normalisation important?

1 Answers  

---

How many types of subqueries are there in sql server?

1 Answers  

---

Can you explain the types of Joins that we can have with Sql Server?

2 Answers  

---

Psudo colums

1 Answers   HP,

---

Write a code to select distinct records without using the DISTINCT keyword.

1 Answers   Aspiring Minds,

---

Determine how to use the inserted and deleted pseudo tables?

1 Answers  

---

How to loop through returning rows?

1 Answers  

---

Why we use the openxml clause?

0 Answers  

---

Can you explain important index characteristics?

1 Answers  

---

i have made a project i vb.net n created a .exe of it after installing it in to any pc, the database (sql express) is not geting accesed i.e the aplication cuts the link of the database, so plz help in this matter.

1 Answers  

---