Answer / Mahipal Singh Kalohiya

The WITH ENCRYPTION keyword in SQL Server provides a way to encrypt a Transact-SQL script before it is executed. This is useful for securing sensitive data by preventing unauthorized access to script content during transmission or storage. Encrypted scripts can be saved, sent as email attachments, or stored in version control systems without exposing sensitive information.

What is read committed?

1 Answers  

---

you have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem? : Sql server administration

1 Answers  

---

Write an sql query to sort a table according to the amounts in a row and find the second largest amount.

1 Answers   Amazon,

---

What is create command?

1 Answers  

---

What is difference between equi join and inner join?

1 Answers  

---

How will you add a dimension to cube? : sql server analysis services, ssas

1 Answers  

---

How get current date in SQL server 2000

6 Answers   Cap Gemini,

---

I have a table EMP in which the values will be like this EmpId Ename Sal DeptId 11 Ram 10000 10 11 Ram 10000 10 22 Raj 20000 20 22 Raj 20000 20 33 Anil 15000 30 33 Anil 15000 30 I want to delete only duplicate Rows. After Delete I want the output like this EmpId Ename Sal DeptId 11 Ram 10000 10 22 Raj 20000 20 33 Anil 15000 30

13 Answers   DELL,

---

What is the boxing and unboxing concept in .net?

1 Answers  

---

How to Update from select query in sql server?

1 Answers  

---

Explain indexing and what are the advantages of it?

1 Answers  

---

What is policy based management (pbm)? : sql server database administration

1 Answers  

---