What is sql server locking?

0 Answers  

---

system date format is "yy-mm-dd" "select getdate()" ----> 2009-01-24 20:03:28.513 if i write "select dateadd(dd,2,getdate()) ".it returns "2009-01-26 19:59:38.340"...my question is dat could it be possible to retrive da date in da format "26 jan 2009 ...."??

8 Answers  

---

Explain mixed authentication mode of sql server?

0 Answers  

---

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

0 Answers  

---

How to create a dynamic cursor with the dynamic option?

0 Answers  

---

---

explain different types of jions with examples briefly?

2 Answers   Accenture, Excellence, Zensar,

---

Stored Procedure returns data from multiple tables. How to access it in your ASP.Net code?

0 Answers   HCL,

---

What is the difference between lock, block and deadlock? : sql server database administration

0 Answers  

---

How do you optimize Sql queries ?

0 Answers   Cognizant,

---

What are the differences between left join and inner join in sql server?

0 Answers  

---

Explain about nested stored procedure?

0 Answers  

---

Explain what is use of dbcc commands?

0 Answers  

---