Answer / Mohd Rizwan

Errors while creating a new ODBC DSN can occur due to various reasons such as incorrect server name, invalid system DSN, or missing system files. To troubleshoot these issues, follow the steps in the Microsoft Support article: https://support.microsoft.com/en-us/office/create-a-data-source-name-dsn-for-odbc-6f8d79e3-0ebc-4b82-bf0a-68716dde846d

how to know Who Is Blocking Your SQL Server?

4 Answers  

---

hi, how to match retrieve the unmatched records from 2 tables in which we dont have any primary key. example : table1 has 1,2,3,4,5 and table2 has 1,2,3,4,5,6,7,8,9,10 and i want the numbers from 6 to 10 to be displayed and should not come as null. i need the numbers. please reply as soon as possible.

4 Answers  

---

What is buffer cash in sql server?

1 Answers  

---

What functions can a view be used to performed?

1 Answers  

---

What are the different types of cursor?

1 Answers   HCL,

---

How optimize sql query with multiple joins in sql server?

1 Answers  

---

What is reference section?

1 Answers  

---

How to use user defined functions in expressions?

1 Answers  

---

I Have Employee table having column name as ID,SALARY how to get second max salary from employee table with id ex ID SALARY 1 20000 7 37000 2 5000

17 Answers   HCL, IBM,

---

What is the difference between varchar and nvarchar?

1 Answers  

---

What is sorting and what is the difference between sorting and clustered indexes?

1 Answers  

---

You have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation?

1 Answers  

---