Answer / gautam k panjikar

getdate()

Answer / rajkumar v

select convert(varchar,getdate(),105)

Answer / anto

select getdate()

Answer / mt

select getdate();

How do I start sql server agent automatically?

0 Answers  

---

UPDATE statement can on a single table or on the multiple table?

7 Answers   iGate, TCS,

---

What's the difference between a primary key and a unique key?

10 Answers   Wipro,

---

How can sql server instances be hidden?

0 Answers  

---

How many types of Cursor in SQL SERVER?

1 Answers  

---

---

Explain active/passive and active/active cluster configurations?

0 Answers  

---

Do you know what is replace and stuff function in sql server?

0 Answers  

---

What is difference between view and materialized view?

0 Answers  

---

Give an example of why you would want to denormalize a database

0 Answers  

---

How to bind a view to the schema of the underlying tables?

0 Answers  

---

What is wide table?

0 Answers  

---

Explain the phases a transaction has to undergo?

0 Answers  

---