how do you test proper tcp/ip configuration windows machine? : Sql server database administration

0 Answers  

---

what's new in sql server 2016?

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  

---

How to get a list of columns using the "sp_help" stored procedure in ms sql server?

0 Answers  

---

What is wide table?

0 Answers  

---

---

What is temporal table?

0 Answers  

---

How do you load large data to the SQL server database?

2 Answers  

---

Hello all, I have data like :- year amt 2004 10 2005 20 2006 30 Now i want output as:- 2004 2005 2006 10 30 60 but i have to use here group by on year.So, i need a single query within that i can find.

3 Answers  

---

Explain what you mean by 3 tier architecture.

0 Answers   TCS,

---

Explain what are commit and rollback in sql?

0 Answers  

---

What is the difference between a primary key and a unique key? Are they the same?

0 Answers  

---

What are logical/boolean operations in ms sql server?

0 Answers  

---