Can we hide the definition of a stored procedure from a use?

0 Answers  

---

What is dirty read?

0 Answers  

---

write the query for find the top 2 highest salary in sql server

36 Answers   Cranes, Jayanti Software, Medi Assist, Rmax, TCS,

---

Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?

0 Answers  

---

Differentiate between truncate vs delete in mssql?

0 Answers  

---

If a user does not have permission to a table, but has permission to a view created on it, will he be able to view the data in table?

0 Answers  

---

What is dbcc updateusage?

0 Answers  

---

Explain identity in sql server?

0 Answers  

---

What are the types of sql server?

0 Answers  

---

Can we use Truncate command on a table which is referenced by FOREIGN KEY?

2 Answers   Shriram,

---

What is a Lock and let me know Different types of locks?

2 Answers  

---

You are designing a database for your human resources department in the employee table, there is a field for social security number, which cannot contain null values if no value is given, you want a value of unknown to be inserted in this field what is the best approach?

0 Answers  

---