Answer Posted / kumar.t

Select Convert(varchar,getdate(),114) As DateTime

It is Only Run In Sql Server2000

By

Kumar .T

How to use "for" statements in oracle?

1032

---

Whether any commands are used for months calculation? If so, what are they?

1053

---

Does facebook use oracle?

996

---

How to declare a local variable?

1069

---

How to start your 10g xe server from command line?

1019

---

What are the numeric comparison operations?

1071

---

Write a syntax for update query in oracle?

985

---

Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracles. What database recovery options are available? Database is in archive log mode.

1955

---

How to get a list of all user accounts in the database?

1045

---

What is oracle instant client?

983

---

Whats the benefit of dbms_stats over analyze?

1957

---

I have a table called 'test' on source and target with same name, structure and data type but in a different column order. How can you setup replication for this table?

1053

---

What is bulk load in oracle?

1020

---

How to convert characters to times in oracle?

975

---

What happens internally when the user types userID/password@string in SQL PLUS Thanks-Bhaskar

4513

---